Random forum lockouts... [message #41013] |
Wed, 07 May 2008 00:03 |
|
While trying to update to 2.7.7 and perform some testing I am running into something very odd. It is hard to reproduce, but has occurred several times. Basically at various times after selecting 'Log out' something happens to the FUDforum and visiting the site just crashes.
By crashes, I mean a white screen. Very early in the index.php process it crashes in ses_update_status.
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<br />
Query: UPDATE fud26_ses SET sys_id='', forum_id=0, time_sec=1210112266, action='Browsing the <a href=\"index.php?t=index\&qu
ot;>forum list</a>', returnto='' WHERE id=<br />
Server Version: 5.0.22<br />
I am not sure why this is getting corrupted. Oddly there is no way to recover from this. Even removing all rows of the fud26_ses table does not recover. (A complete restore of the entire database is needed).
So far while debugging this, the only thing I have notice specifically is that when this happens, the entries in the fud26_ses have a 'action' of NULL. Normally the 'action' field says something like 'Browsing...' etc. 'returnto' is also NULL.
When this happens you cannot even log in via the adm control panel. Perhaps some other table is getting in a weird state because clearing the fud26_ses does not fix the issue, only a full database restore to an earlier version does.
Any ideas? Suggestion? Debugging tips?
[Updated on: Wed, 07 May 2008 00:05] Report message to a moderator
|
|
|