View Full Version : MySQL Error : The table 'session' is full
dznmods
01-23-2012, 02:46 AM
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
('bafebca212a548f8a662f413602d664e', 0, '24.79.168.101', '57650810cc00d7a3e90982d80ab334b5', 1327288987, '/showthread.php?7113-Xbox-360-Bio-Art!', 0, 0, 0, 0, 0, 0, 2, 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB7.2; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; .NET4.0C; .NET4.0E; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 2.0.50727)', 0, 0, 0, '');
MySQL Error : The table 'session' is full
Error Number : 1114
Request Date : Sunday, January 22nd 2012 @ 08:23:07 PM
Error Date : Sunday, January 22nd 2012 @ 08:23:07 PM
Script : http://dznmods.net/showthread.php?7113-Xbox-360-Bio-Art!
Referrer : http://www.google.ca/url?sa=t&rct=j&q=xbox%20360%20bio%20art&source=web&cd=2&sqi=2&ved=0CDsQFjAB&url=http%3A%2F%2Fdznmods.net%2Fshowthread.php%3F71 13-Xbox-360-Bio-Art!&ei=MNIcT4LSKcma2gXb5NXYCw&usg=AFQjCNGLg709_XDK7OEzWdbz_A_B7pNLkA&sig2=jB74wWWEGZ8bIvwQ-xdImQ
IP Address : 24.79.168.101
Username : Unregistered
Classname : vB_Database
MySQL Version :
and also this when u go to my site
This webpage is not available
The webpage at http://dznmods.net/forum.php might be temporarily down or it may have moved permanently to a new web address.
Error 330 (net::ERR_CONTENT_DECODING_FAILED): Unknown error.
HMBeaty
01-23-2012, 02:52 AM
Go into phpMyAdmin and empty the contents of that table.
You might want to check that your cron jobs are running properly also as this table should be periodically pruned by them
As far as the second error, have you contacted your host about that?
dznmods
01-23-2012, 03:54 PM
Yes and they say it's. Compressing
creative-friend
09-29-2019, 05:31 PM
Go into phpMyAdmin and empty the contents of that table.
You might want to check that your cron jobs are running properly also as this table should be periodically pruned by them
As far as the second error, have you contacted your host about that?
I face same error.
Please anyone guide me that which table should be empty? and how did it
final kaoss
09-29-2019, 06:29 PM
Make sure all of your cronjobs are running and you won't have to worry about which table to empty.
creative-friend
09-30-2019, 02:00 AM
Make sure all of your cronjobs are running and you won't have to worry about which table to empty.
I have not access to forum and AdminCP.
What is the other way to check cronjobs?
final kaoss
09-30-2019, 02:08 AM
Do you have access to the server? If you do, simply add your userid to access the admincp
https://www.vbulletin.com/docs/html?manualversion=40205500
pay attention to the following areas.
// ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
// The users specified here will be allowed to view the admin log in the control panel.
// Users must be specified by *ID number* here. To obtain a user's ID number,
// view their profile via the control panel. If this is a new installation, leave
// the first user created will have a user ID of 1. Seperate each userid with a comma.
$config['SpecialUsers']['canviewadminlog'] = '1';
// ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
// The users specified here will be allowed to remove ("prune") entries from the admin
// log. See the above entry for more information on the format.
$config['SpecialUsers']['canpruneadminlog'] = '1';
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';
// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$config['SpecialUsers']['undeletableusers'] = '';
// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$config['SpecialUsers']['superadministrators'] = '1';
creative-friend
09-30-2019, 02:35 AM
Do you have access to the server? If you do, simply add your userid to access the admincp
https://www.vbulletin.com/docs/html?manualversion=40205500
pay attention to the following areas.
// ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
// The users specified here will be allowed to view the admin log in the control panel.
// Users must be specified by *ID number* here. To obtain a user's ID number,
// view their profile via the control panel. If this is a new installation, leave
// the first user created will have a user ID of 1. Seperate each userid with a comma.
$config['SpecialUsers']['canviewadminlog'] = '1';
// ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
// The users specified here will be allowed to remove ("prune") entries from the admin
// log. See the above entry for more information on the format.
$config['SpecialUsers']['canpruneadminlog'] = '1';
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';
// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$config['SpecialUsers']['undeletableusers'] = '';
// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$config['SpecialUsers']['superadministrators'] = '1';
My Id is already superadmin. When I tried to open AdminCP. I face same database error
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.