HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


after upgrade to 5.02 errors

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#64006 (In Topic #13809)
Avatar

Well-settled

Hi there.
I have upgraded from 5.0.1 to 5.0.2 anyway i noticed to day I got errors on the site.
I got about 500 errors int he last 5 hrs and some yesterday.

Some examples are:

An error has occurred

Unfortunately a query has failed [SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t on t.id=f.cf_name WHERE (text_original='ocp_points_gained_given') ] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON t.id=f.cf_name WHERE (text_original='ocp_points_gained_given')' at line 1] (version: 5.0.2, PHP version: 5.2.14, URL: /forum/topics/new_topic/58.htm?keep_cache%3D0)

Here is the stack trace:

Below is a stack trace revealing the state the software was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Home Education Tasmania website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

File
'/home/homeed/public_html/sources/failure.php'
Line
'604'
Function
'get_html_trace'
Args



File
'/home/homeed/public_html/sources/global2.php'
Line
'920'
Function
'_fatal_exit'
Args
object



File
'/home/homeed/public_html/sources/database/mysql.php'
Line
'238'
Function
'fatal_exit'
Args
object



File
'/home/homeed/public_html/sources/database.php'
Line
'1,042'
Function
'db_query'
Class
'Database_Static_mysql'
Type
'->'
Object
Database_Static_mysql::__set_state(array( ))
Args
'SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t on t.id=f.cf_name WHERE (text_original=\'ocp_points_gained_given\') '

array ( 0 => NULL, 1 => 'homeed_homeedtas', )

NULL

NULL

false

false

false

false



File
'/home/homeed/public_html/sources/database.php'
Line
'910'
Function
'_query'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t on t.id=f.cf_name WHERE (text_original=\'ocp_points_gained_given\') '

NULL

NULL

false

false

NULL

''



File
'/home/homeed/public_html/sources/forum/ocf.php'
Line
'340'
Function
'query_select'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'f_custom_fields f LEFT JOIN ocp4_translate t on t.id=f.cf_name'

array ( 0 => 'f.id', 1 => 'f.cf_type', )

array ( 'text_original' => 'ocp_points_gained_given', )



File
'/home/homeed/public_html/sources/users_inactive_occasionals.php'
Line
'194'
Function
'set_custom_field'
Class
'forum_driver_ocf'
Type
'->'
Object
forum_driver_ocf::__set_state(array( 'connection' => database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), )), 'MEMBER_ROWS_CACHED' => array ( ), ))
Args
1

'points_gained_given'

'266765'



File
'/home/homeed/public_html/sources/users.php'
Line
'476'
Function
'create_session'
Args
1



File
'/home/homeed/public_html/sources/site.php'
Line
'118'
Function
'get_member'
Args



Function
'init__site'
Args



File
'/home/homeed/public_html/sources/global.php'
Line
'198'
Function
'call_user_func'
Args
'init__site'



File
'/home/homeed/public_html/sources/global2.php'
Line
'438'
Function
'require_code'
Args
'site'



Function
'init__global2'
Args



File
'/home/homeed/public_html/sources/global.php'
Line
'198'
Function
'call_user_func'
Args
'init__global2'



File
'/home/homeed/public_html/sources/global.php'
Line
'419'
Function
'require_code'
Args
'global2'



File
'/home/homeed/public_html/forum/index.php'
Line
'48'
Args
'/home/homeed/public_html/sources/global.php'

Function
'require'




Back to the top
 
Posted
Rating:
#64007
Avatar

Well-settled

Couple more examples

An error has occurred

Unfortunately a query has failed [SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t ON t.id=f.cf_name WHERE (text_original='ocp_points_gained_given') ] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON t.id=f.cf_name WHERE (text_original='ocp_points_gained_given')' at line 1] (version: 5.0.2, PHP version: 5.2.14, URL: /backend.php?mode=news&filtered=1&type=atom)

Here is the stack trace:

Below is a stack trace revealing the state the software was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Home Education Tasmania website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

File
'/home/homeed/public_html/sources/failure.php'
Line
'604'
Function
'get_html_trace'
Args



File
'/home/homeed/public_html/sources/global2.php'
Line
'920'
Function
'_fatal_exit'
Args
object



File
'/home/homeed/public_html/sources/database/mysql.php'
Line
'238'
Function
'fatal_exit'
Args
object



File
'/home/homeed/public_html/sources/database.php'
Line
'1,042'
Function
'db_query'
Class
'Database_Static_mysql'
Type
'->'
Object
Database_Static_mysql::__set_state(array( ))
Args
'SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t ON t.id=f.cf_name WHERE (text_original=\'ocp_points_gained_given\') '

array ( 0 => NULL, 1 => 'homeed_homeedtas', )

NULL

NULL

false

false

false

false



File
'/home/homeed/public_html/sources/database.php'
Line
'910'
Function
'_query'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t ON t.id=f.cf_name WHERE (text_original=\'ocp_points_gained_given\') '

NULL

NULL

false

false

NULL

''



File
'/home/homeed/public_html/sources/forum/ocf.php'
Line
'340'
Function
'query_select'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'f_custom_fields f LEFT JOIN ocp4_translate t ON t.id=f.cf_name'

array ( 0 => 'f.id', 1 => 'f.cf_type', )

array ( 'text_original' => 'ocp_points_gained_given', )



File
'/home/homeed/public_html/sources/users_inactive_occasionals.php'
Line
'194'
Function
'set_custom_field'
Class
'forum_driver_ocf'
Type
'->'
Object
forum_driver_ocf::__set_state(array( 'connection' => database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), )), 'MEMBER_ROWS_CACHED' => array ( ), ))
Args
1

'points_gained_given'

'266765'



File
'/home/homeed/public_html/sources/users.php'
Line
'476'
Function
'create_session'
Args
1



File
'/home/homeed/public_html/sources/site.php'
Line
'142'
Function
'get_member'
Args



Function
'init__site'
Args



File
'/home/homeed/public_html/sources/global.php'
Line
'198'
Function
'call_user_func'
Args
'init__site'



File
'/home/homeed/public_html/sources/global2.php'
Line
'438'
Function
'require_code'
Args
'site'



Function
'init__global2'
Args



File
'/home/homeed/public_html/sources/global.php'
Line
'198'
Function
'call_user_func'
Args
'init__global2'



File
'/home/homeed/public_html/sources/global.php'
Line
'419'
Function
'require_code'
Args
'global2'



File
'/home/homeed/public_html/backend.php'
Line
'44'
Args
'/home/homeed/public_html/sources/global.php'

Function
'require'



Back to the top
 
Posted
Rating:
#64008
Avatar

Well-settled

An error occurred at:
http://www.homeeducationtasmania.com/index.php?

The full error details follow:

Unfortunately a query has failed [SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t ON t.id=f.cf_name WHERE (text_original='ocp_points_gained_given') ] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON t.id=f.cf_name WHERE (text_original='ocp_points_gained_given')' at line 1] (version: 5.0.2, PHP version: 5.2.14, URL: /)

Front page Skip navigation

Home

| Forums

Features


Home

Guidelines

Rules

Guestbook

Community


THEAC

THE Forums

THE Chatrooms

Founding Members

THE Lounge

Support tickets

THE Events

Members Blogs

Members Clubs

Members List

Record Keeping

Downloads

Assistance

Feedback

Usergroups

Point-store

Gallery

Links

Glimpse


Subscribe to Glimpse

Download Glimpse

Not logged in


Username

Password

Username [ ]

Remember me [X]


[Login]

[ Join | More ]

Users online


1 guest

Welcome to our newest member, thekellygang

Image of the day

Image of the day


Eagle Hawk Neck, Tasmania

[ View all View (0 comments) ]

Poll

News/blog categories


General

GLIMPSE

Calendar - Oct 2010

M
T
W
T
F
S
S




2010-10-01
1

2010-10-02
2

2010-10-03
3

2010-10-04
4

2010-10-05
5

2010-10-06
6

2010-10-07
7

2010-10-08
8

2010-10-09
9

2010-10-10
10

2010-10-11
11

2010-10-12
12

2010-10-13
13

2010-10-14
14

2010-10-15
15

2010-10-16
16

2010-10-17
17

2010-10-18
18

2010-10-19
19

2010-10-20
20

2010-10-21
21

2010-10-22
22

2010-10-23
23

2010-10-24
24

2010-10-25
25

2010-10-26
26

2010-10-27
27

2010-10-28
28

2010-10-29
29

2010-10-30
30

2010-10-31
31

Site statistics


Activity:

oUsers online: 0

oUsers online (record): 76

oHits today: 164

oHits this week: 3,781

oHits this month: 28,891

Community:

oMembers: 180

oJoined today: 0

oActive today: 2

oActive this week: 8

oActive this month: 17

oTopics: 191

oPosts: 701

Chat system:

oChatrooms: 2

Downloads:

oTotal: 3

Calendar:

oEvents: 3

Galleries:

oImages: 10

News:

oPosts: 29

An error has occurred

Unfortunately a query has failed [SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t ON t.id=f.cf_name WHERE (text_original='ocp_points_gained_given') ] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON t.id=f.cf_name WHERE (text_original='ocp_points_gained_given')' at line 1] (version: 5.0.2, PHP version: 5.2.14, URL: /)

Here is the stack trace:

Below is a stack trace revealing the state the software was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Home Education Tasmania website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

File
'/home/homeed/public_html/sources/failure.php'
Line
'604'
Function
'get_html_trace'
Args



File
'/home/homeed/public_html/sources/global2.php'
Line
'920'
Function
'_fatal_exit'
Args
object



File
'/home/homeed/public_html/sources/database/mysql.php'
Line
'238'
Function
'fatal_exit'
Args
object



File
'/home/homeed/public_html/sources/database.php'
Line
'1,042'
Function
'db_query'
Class
'Database_Static_mysql'
Type
'->'
Object
Database_Static_mysql::__set_state(array( ))
Args
'SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t ON t.id=f.cf_name WHERE (text_original=\'ocp_points_gained_given\') '

array ( 0 => NULL, 1 => 'homeed_homeedtas', )

NULL

NULL

false

false

false

false



File
'/home/homeed/public_html/sources/database.php'
Line
'910'
Function
'_query'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'SELECT f.id,f.cf_type FROM ocp4_f_custom_fields f STRAIGHT_JOIN ocp4_translate t ON t.id=f.cf_name WHERE (text_original=\'ocp_points_gained_given\') '

NULL

NULL

false

false

NULL

''



File
'/home/homeed/public_html/sources/forum/ocf.php'
Line
'340'
Function
'query_select'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'f_custom_fields f LEFT JOIN ocp4_translate t ON t.id=f.cf_name'

array ( 0 => 'f.id', 1 => 'f.cf_type', )

array ( 'text_original' => 'ocp_points_gained_given', )



File
'/home/homeed/public_html/sources/users_inactive_occasionals.php'
Line
'194'
Function
'set_custom_field'
Class
'forum_driver_ocf'
Type
'->'
Object
forum_driver_ocf::__set_state(array( 'connection' => database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'connection_write' => array ( 0 => NULL, 1 => 'homeed_homeedtas', ), 'text_lookup_original_cache' => array ( 265 => 'ocp_points_gained_seedy', 276 => 'ocp_points_gained_chat', 354 => 'ocp_points_used', 356 => 'ocp_gift_points_used', 358 => 'ocp_points_gained_given', 360 => 'ocp_points_gained_rating', 362 => 'ocp_points_gained_voting', 364 => 'ocp_sites', 366 => 'ocp_role', 368 => 'ocp_fullname', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'text_lookup_cache' => array ( 265 => '', 276 => '', 354 => '', 356 => '', 358 => '', 360 => '', 362 => '', 364 => '', 366 => '', 368 => '', 266 => '', 277 => '', 355 => '', 357 => '', 359 => '', 361 => '', 363 => '', 365 => '', 367 => '', 369 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), )), 'MEMBER_ROWS_CACHED' => array ( ), ))
Args
1

'points_gained_given'

'266765'



File
'/home/homeed/public_html/sources/users.php'
Line
'476'
Function
'create_session'
Args
1



File
'/home/homeed/public_html/sources/site.php'
Line
'142'
Function
'get_member'
Args



Function
'init__site'
Args



File
'/home/homeed/public_html/sources/global.php'
Line
'198'
Function
'call_user_func'
Args
'init__site'



File
'/home/homeed/public_html/sources/global2.php'
Line
'438'
Function
'require_code'
Args
'site'



Function
'init__global2'
Args



File
'/home/homeed/public_html/sources/global.php'
Line
'198'
Function
'call_user_func'
Args
'init__global2'



File
'/home/homeed/public_html/sources/global.php'
Line
'419'
Function
'require_code'
Args
'global2'



File
'/home/homeed/public_html/index.php'
Line
'111'
Args
'/home/homeed/public_html/sources/global.php'

Function
'require'



Not sure why, all of a sudden, unless it is server issue.
Slav
Back to the top
 
Posted
Rating:
#64009
Avatar

Hi,

I think you may be using an unsupported old version of MySQL. But please try replacing 'STRAIGHT_JOIN' with 'JOIN' in sources/database.php.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#64011
Avatar

Well-settled

Hi I will try that, its been running fine for like a year now… it just doesn't make sense all of a sudden. it comes and goes.. here is the server info
Kernel version    2.6.9-89.0.23.ELsmp
cPanel Version    11.26.20
Architecture    i686
MySQL version    4.1.22-standard-log
Path to sendmail    /usr/sbin/sendmail
Apache version    2.2.16
PHP version    5.2.14

Will try what you suggest , will let you know how it goes
Slav

Back to the top
 
Posted
Rating:
#64012
Avatar

I have done some checking, and this is a bug: we are supposed to support MySQL 4.1 but this version can't support that type of query. My fix should work though.

The reason for the code change is we worked around a MySQL performance bug in 5.0.2 by changing how we run the queries, but I wasn't aware it broke 4.1 compatibility.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#64032
Avatar

Well-settled

Thanks Chris. My wife said it has not errored in the last 24 hrs. So a good sign :):
Slav
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: