[Forum] INSERT IGNORE INTO session The table 'session' is full

[devrimow]

Hi
I updated from 4.1.11 to 4.2.0

updated over

error

Database error in vBulletin 4.2.0:

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
                    ('c46671c6fb32095e0083a4d745c5e7ee', 4, '78.179.111.28', 'fa66556ed610817f1a84a2e863543d03', 1364121963, '/', 0, 2, 1, 0, 0, 1, 0, 'Mozilla/5.0 (Windows NT 6.1; rv:19.0) Gecko/20100101 Firefox/19.0', 0, 0, 0, '');

MySQL Error   : The table 'session' is full
Error Number  : 1114
Request Date  : Sunday, March 24th 2013 @ 12:46:03 PM
Error Date    : Sunday, March 24th 2013 @ 12:46:04 PM
Script        : http://www.derinport.in/
Referrer      :
IP Address    : xx.xxx.111.28
Username      : xxxxxxx
Classname     : vB_Database
MySQL Version : 5.1.62

Regime I

1. truncate table session
2. UPDATE setting SET value = '0' WHERE varname = 'gzipoutput';
3. Options > Cookies and HTTP Header Options > GZIP HTML Output >> no

It also does not work in the forum page view counter

cron does not work

Scheduled Task Manager > Hourly Cleanup and Hourly Cleanup #2

does not work

scheduled tasks not only in logs

Process E-Mail Queue
Daily Digest
Daily Digest Sent
Paid Subscriptions Updated
E-mail processing completed.


Can I get help please

[Trevor Hannant]

What is the session timeout value you have here:

AdminCP > Settings > Options > Cookies and HTTP Header Options

[devrimow]

What is the session timeout value you have here: AdminCP > Settings > Options > Cookies and HTTP Header Options

Hi

Session Timeout ; 900

thanks

[Lynne]

You have removed the part in the footer template that says "Do not remove cronimage or your scheduled tasks will cease to function " and that is why your Scheduled Tasks do not work.

[BirdOPrey5]

Reverting you footer template, or copying the code from the default style footer template, will fix it. (Reverting will also lose any customization you made.)

[devrimow]

You have removed the part in the footer template that says "Do not remove cronimage or your scheduled tasks will cease to function " and that is why your Scheduled Tasks do not work.

Reverting you footer template, or copying the code from the default style footer template, will fix it. (Reverting will also lose any customization you made.)

hi

cronimage code has been deleted
yes thank you my problem is resolved

[gemleo]

Hello we are getting the same problem
Here is our stats at this time: There are currently 7743 users online. 849 members and 6894 guests
our session time out is 3600 and we haven't removed any copyright thing all our cron jobs are working
We are getting this error more often session table is full.
Is there any way to check is the hourly cleanup is working or not some other cron jobs store logs in schedule log but hourly cleanup cron job do not log anything
kindly help us our site gets down every time we get this error.