I have a problem that occurs about once a month, where my forum stops working and gives this error page:
I have found a fix here on the forums, which means manually logging in to the database every time it happens to run this query:
That gets the forum back up, but doing this manually every time I notice the forum is down is a pain! What can I do to stop this happening? Thanks.
Code:
Database error in vBulletin 3.8.1: Invalid SQL: INSERT IGNORE INTO vbul_session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate) VALUES ('xxxxxxxxxxxxxxxxxxx); MySQL Error : The table 'vbul_session' is full Error Number : 1114 Request Date : Thursday, October 1st 2009 @ 01:07:43 PM Error Date : Thursday, October 1st 2009 @ 01:07:43 PM Script : http://www.notesfromspain.com/forums/search.php?do=getnew Referrer : IP Address : Username : Classname : MySQL Version : 5.0.81-community
Code:
DELETE FROM vbul_session;
Comment