| Occasional blank pages and SQL error messages... [message #19788] |
Thu, 02 September 2004 07:44  |
FitnessJunkie
Messages: 13
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
Hi. At times forum users and I get blank pages randomly, and
this error is generated:
(/my/path/to/the/forum/index.php:116
/my/path/to/the/forum/index.php:214
/my/path/to/the/forum/theme/default/thread.php:226
/my/path/to/the/forum/theme/default/thread.php:562
/my/path/to/the/forum/index.php:1148
) 1064: 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 'WHERE f.id= LIMIT 1' at line 4
Query: SELECT m.forum_id, g1.group_cache_opt FROM fud26_forum f INNER JOIN fud26_group_cache g1 ON g1.user_id=0 AND g1.resource_id=f.id LEFT JOIN fud26_mod m ON m.user_id=0 AND m.forum_id= WHERE f.id= LIMIT 1
Server Version: 4.0.20-standard
[Referring Page] http://my/URLpath/to/the/forum/index.php?t=threadt&frm_id=8&rid=0&a mp;S=f06ab69f8095cddb2064a6f7cc538ed6
Can you please tell me what it means? I'm using 2.6.6, but
upgraded TO this version because I was getting the blank
pages in 2.6.4.
Thanks.
Namaste,
FitnessJunkie
|
|
|
|
|
|
| Re: Any idea? [message #19890 is a reply to message #19796] |
Wed, 15 September 2004 05:47  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Try running consistency checker if it does not try upgrading the forum.
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
| Re: Occasional blank pages and SQL error messages... [message #19994 is a reply to message #19987] |
Mon, 20 September 2004 22:14 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
open thread.php.t inside src/ directory and change:
if (!($usr->users_opt & 1048576) && !th_moved_perm_chk($r[11])) {
to
if (!($usr->users_opt & 1048576) && $r[11] && !th_moved_perm_chk($r[11])) {
and then rebuild the theme and see if it fixes the problem, please let me know if it does.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]