MySQL Error : The table 'session' is full

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Abhik
    Senior Member
    • Feb 2007
    • 137
    • 3.8.x

    MySQL Error : The table 'session' is full

    Hello,
    I am getting the error

    MySQL Error : The table 'session' is full

    And the forum isn't opening..
    What should I do now?

    Thanks
    Mobile Discussion Forum | Technology ReDiscussed | Make Money Online
  • DirtyHarry
    Member
    • Feb 2004
    • 96
    • 3.8.x

    #2
    You may want to delete older sessions in your session table by running something like this:

    Code:
        DELETE FROM session  WHERE lastactivity < 1258502460
    Which will delete all older sessions. Of course, you can adjust the timestamp to your liking.

    Anyhow, you should find the cause of the issue. vBulletin NEEDs to run its cleanup.php cronjob to clean old/expired sessions. Otherwise you can end up with problems like this. Make sure that your cron scripts in vBulletin are working and that the $cronimage variable is in your footer template.
    CarlitoBrigante on vb.org - MagnetiCat.com
    Professional vBulletin development, support, upgrades

    Comment

    • Abhik
      Senior Member
      • Feb 2007
      • 137
      • 3.8.x

      #3
      Thanks..
      I just run theDELETE FROM session; and it's working now.
      Mobile Discussion Forum | Technology ReDiscussed | Make Money Online

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...