| Fatal error: SQL Error has occurred [message #21592] |
Mon, 06 December 2004 12:15  |
srchild
Messages: 88
Registered: December 2003
Location: UK
Karma:
|
Member |
|
|
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /usr/www/users/web/forum/index.php on line 59
Somehow I broke my forum, which I have just set up. I think what happened was this:
I was logged in as admin and viewing it in firefox. For some reason I fired up IE6 and got error as above. I remembered that last evening I tinkered with multihost setting and wondered if that was something to do with it, especially as I had seen a warning about sessions. Since I was logged in as admin in firefox I went to admin, switched off multi-host, and went to the consistency checker. That seemed to work fine.
But then I found that I got the same problem with both ie and firefox, and have continued getting it ever since. I also can't login to adm, same problem:
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /usr/www/users/web/FUDforum/include/theme/default/db.inc on line 56
Here is the first sql error message that occurred:
Mon Dec 6 10:46:35 GMT 2004 (/usr/www/users/web/forum/index.php:126
/usr/www/users/web/forum/index.php:350
/usr/www/users/web/forum/theme/default/index.php:80
/usr/www/users/web/forum/index.php:1164
) 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 '' at line 1
Query: UPDATE fud_ses SET sys_id='', forum_id=0, time_sec=1102329995, action='Browsing the <a href=\"index.php?t=index\">forum list</a>', returnto='' WHERE id=
Server Version: 4.0.17-log
Subsequent errors are all similar.
Why is the id empty on the end of that query?
I have tried clearing sessions file.
Using 2.6.8 latest stable version.
Suggestions please!
Simon Child
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]