1114 Error. Please help

[ru55ian]

This morning i woke up and noticed that my board is producing MySQL error 1114

Database error in vBulletin 3.6.8:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
VALUES
('615c575cb84e6c9e6abd79e150241c39', 1, '74.102.242.248', '9291daa73ad13eaa857368bd08a9be21', 1189175635, '/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2; .NET CLR 1.1.4322)', 0, 0);

MySQL Error : The table 'session' is full
Error Number : 1114
Date : Friday, September 7th 2007 @ 07:33:56 AM

Can anyone tell me how to fix this?

Thanks in advance

[nexialys]

i suppose that your session timeout is too large, like most of the sites i know who wants to show more and more users who are online even if they are not...
from your phpMyAdmin or any mysql manager, go EMPTY your session table...

then go: AdminCP >> vBulletin Options >> Cookies and HTTP Header Options >> Session Timeout ...

set it to the default 900, so you have no more problems.

[ru55ian]

thanks, had to empty session table, p.s. my timeout is already set to 900, dropped it down to 600.

[Marco van Herwaarden]

This is often an indication that your Scheduled Tasks are not running (session table gets cleaned by a schedulaed task). Check your Scheduled Task logs to see if they are running at all.