Announcement

Collapse
No announcement yet.

session table missing?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    Then you need to ask your host to raise the limits.

    Leave a comment:


  • kingshah
    replied
    it's already set to 0

    Leave a comment:


  • Steve Machol
    replied
    The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off in your config.php:

    PHP Code:
    // ****** PERSISTENT CONNECTIONS ******
    // This option allows you to turn persistent connections to MySQL on or off.
    // The difference in performance is negligible for all but the largest boards.
    // If you are unsure what this should be, leave it off.
    // 0 = Off; 1 = On
    $usepconnect 0
    But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.

    Leave a comment:


  • kingshah
    replied
    ok i did that and have no more problem with session table.. but after adding that line.. i start getting these message... like one every 15 mins..

    Database error in vBulletin :

    mysql_connect(): User [email protected] has already more than 'max_user_connections' active connections
    /services2/webpages/g/l/site.com/public/forums/includes/class_core.php on line 273

    MySQL Error :
    Error Number :
    Date : Thursday, October 27th 2005 @ 06:38:06 AM
    Script : http://www.site.com/forums/forumdisplay.php?s=&daysprune=&f=17
    Referrer : http://www.site.com/forums/showthread.php?t=2510
    IP Address : 202.54.*.*
    Username :
    Classname : vb_database

    Leave a comment:


  • Steve Machol
    replied
    That's the problem. That is an absurdly low number. The default is 8 hours (28800). When this i
    s lowered from the default setting, there seems to be an increase in 'lost connection' errors. You can try adding this line to your config.php file right under <?php:

    define('NOSHUTDOWNFUNC', true);

    But better yet, have your host change this back to the default setting.

    Leave a comment:


  • kingshah
    replied
    wait_timeout300

    Leave a comment:


  • Steve Machol
    replied
    Sorry, I asked for the wrong info. Please provide the 'wait_timeout' setting from your MySQL variables:

    Admin CP -> Maintenance -> Diagnostics -> System Information -> MySQL Variables

    Leave a comment:


  • kingshah
    replied
    http://www.site.com/forums/index.php?do=phpinfo
    Last edited by kingshah; Wed 26th Oct '05, 2:27pm.

    Leave a comment:


  • Steve Machol
    replied
    Enable phpinfo in the Admin CP, then provide the URL to your forums. This may help us troubleshoot this problem.

    Admin CP -> vBulletin Options -> Server Settings and Optimization Options -> Public phpinfo() Display Enabled

    Leave a comment:


  • kingshah
    replied
    these messages are coming to my admin email every 15 mins with new error in session table always.

    Invalid SQL:

    UPDATE forums_session
    SET lastactivity = 1130356618, location = '/forums/newreply.php?do=newreply&amp;noquote=1&amp;p=127684', loggedin = 2, inforum = 11, inthread = 2009, incalendar = 0, badlocation = 0, useragent = 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; ntlworld v2.0; FunWebProducts; .NET CLR 1.1.4322)'
    WHERE sessionhash = '6aa44ed7a54b65a1b654b16e2847e6cc';

    MySQL Error : Lost connection to MySQL server during query
    Error Number : 2013
    Date : Wednesday, October 26th 2005 @ 04:14:13 PM
    Script : http://www.site.com/forums/newreply.php?do=newreply&noquote=1&p=127684
    Referrer :
    IP Address : 62.253.*.*
    Username : lazyangel
    Classname : vb_database

    Leave a comment:


  • Steve Machol
    replied
    Nothing serious since vB does this automatically once per hour. Why do you want to do this?

    Leave a comment:


  • kingshah
    replied
    what if i empty it and reset it.. what will happen?

    Leave a comment:


  • Steve Machol
    replied
    You can't repair a HEAP table and there is no reason to.

    Leave a comment:


  • kingshah
    replied
    how do i repair the table in phpmyadmin?

    Leave a comment:


  • Steve Machol
    replied
    It won't show in the Admin CP because it's a HEAP type table and does not respond to 'repair'.

    Leave a comment:

Related Topics

Collapse

Working...
X