Announcement

Collapse
No announcement yet.

Database Troubles

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

  • Database Troubles

    Hello!
    I know this isn't directly related to vBulletin, probably the server is underpowered. But I was wondering what exactly happened and if there's anything I can do to prevent it from happening again except for upgrading the server.
    Database error in vBulletin 3.8.1:

    Invalid SQL:

    INSERT IGNORE INTO PREFIX_community_session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
    VALUES
    ('57fdca6321c08fa8ade42ab45b43ec3d', 335, 'Users IP', 'd205e273fc24fbbsjndsb550e8e7b8b46', 1234782301, '/community/', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6', 0, 0);

    MySQL Error : The table 'PREFIX_community_session' is full
    Error Number : 1114
    Request Date : Monday, February 16th 2009 @ 12:05:01 PM
    Error Date : Monday, February 16th 2009 @ 12:05:01 PM
    Script : mydomain.com
    Referrer :
    IP Address : Users IP
    Username : Username
    Classname : vB_Database
    MySQL Version : 5.0.26
    selling kawaiiNation.com

  • #2
    Run this query:

    DELETE FROM PREFIX_community_session;

    Then revert your footer template. You made a change somewhere that stopped the Scheduled Tasks from running and clearing out this table on a regular basis.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Originally posted by Steve Machol View Post
      Run this query:

      DELETE FROM PREFIX_community_session;

      Then revert your footer template. You made a change somewhere that stopped the Scheduled Tasks from running and clearing out this table on a regular basis.
      Thanks!!~
      Hm, Only thing I changed a while back was to add the Google Analytics link.
      Is there any other place for me to put their script?
      selling kawaiiNation.com

      Comment


      • #4
        Generally that would be placed at the bottom of the footer template. Just make sure you do not remove the rest of the default code from that template.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

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