vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   MySQL Error : The table 'session' is full (https://vborg.vbsupport.ru/showthread.php?t=277401)

dznmods 01-23-2012 02:46 AM
MySQL Error : The table 'session' is full
 
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&...GZ8bIvwQ-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
Quote:
Originally Posted by HMBeaty (Post 2291231)
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
Quote:
Originally Posted by final kaoss (Post 2600832)
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?...rsion=40205500

pay attention to the following areas.

PHP Code:
//    ****** 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
Quote:
Originally Posted by final kaoss (Post 2600835)
Do you have access to the server? If you do, simply add your userid to access the admincp
https://www.vbulletin.com/docs/html?...rsion=40205500

pay attention to the following areas.

PHP Code:
//    ****** 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


All times are GMT. The time now is 10:41 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01382 seconds
  • Memory Usage 1,763KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete