database error 1114 please help

[chris.t]

im getting hundreds of these errors. I cant into site or admin cp. any help?


here is one of the emails I got.


Database error in vBulletin 4.2.2:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
('89a72c78d61e86d1dc0d5374109718f4', 0, '172.245.240.188', '163693b0749e3ff4787c0d7c2b37ff68', 1402975383, '/vb4/member.php?u=5656-WKLGY', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/28.0.1500.52 Chrome/28.0.1500.52 Safari/537.36', 0, 0, 0, '');

MySQL Error : The table 'session' is full
Error Number : 1114
Request Date : Monday, June 16th 2014 @ 10:23:03 PM
Error Date : Monday, June 16th 2014 @ 10:23:03 PM
Script : http://www.rzrlife.com/vb4/member.php?u=5656-WKLGY
Referrer : http://www.rzrlife.com/
IP Address : 172.245.240.188
Username : Unregistered
Classname : vB_Database
MySQL Version :

[hoangserip]

:) you Clean table ' session ' , is able to function properly

[tbworld]

Read this thread, with advice from @Lynne:
http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/3960243-mysql-error-session-table-is-full

[chris.t]

:) you Clean table ' session ' , is able to function properly

How and where do I do this? I ant access admin cp. Do I do this in the files on my server?

Can you walk me through this, anyone? I have never done this.

thanks

chris

[tbworld]

First Backup your database!

Since you do not have access to the admincp.

Use a MySql administration tool that you have access to and truncate the "session" table in your database.

Ex: phpMyAdmin

After you clear the table make sure you did not delete the cronimage from the footer template.

[RichieBoy67]

This can happen if your session/cookie time is set to high.

You can do as tbworld said or even a simple mysql restart with ssh would work.
Depends on your server but most common is /etc/init.d/mysqld restart - just log in using putty and use that.

[chris.t]

First Backup your database!

Since you do not have access to the admincp.

Use a MySql administration tool that you have access to and truncate the "session" table in your database.

Ex: phpMyAdmin

After you clear the table make sure you did not delete the cronimage from the footer template.

I did that...but how do I know if I deleted the cronimage?

[Dave]

I did that...but how do I know if I deleted the cronimage?

The cronimage is located in the footer template, it's called {vb:raw cronimage}. Might want to check if it exists in the template.