what is this Database error in vBulletin 4.2.0 patch 2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Huskermax
    Senior Member
    • Mar 2010
    • 622
    • 4.2.X

    [Forum] what is this Database error in vBulletin 4.2.0 patch 2

    Database error in vBulletin 4.2.0:

    Invalid SQL:

    INSERT IGNORE INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken, openid_original_request)
    VALUES
    ('42e278f7cccccefa1f23b457289b4b93', 1226, '198.228.217.149', 'f7bfb2e5255b5d24af35d1843d93e924', 1347170647, 'forumdisplay.php?f=4', 0, 0, 1, 4, 0, 0, 0, 'Mozilla/5.0 (iPad; U; CPU OS 4_3_5 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8L1 Safari/6533.18.5', 0, 0, 0, '', '');

    MySQL Error : The table 'session' is full
    Error Number : 1114
    Request Date : Sunday, September 9th 2012 @ 01:04:07 AM
    Error Date : Sunday, September 9th 2012 @ 01:04:07 AM
    Script : http://www.huskermax.com/vbbs/forumdisplay.php?4-Football
    Referrer : http://www.huskermax.com/
    IP Address : 198.228.217.149
    Username : lincoln84
    Classname : vB_Database
    MySQL Version :
  • beishe8
    Senior Member
    • Oct 2005
    • 6782
    • 4.2.X

    #2
    Perhaps you should empty your session table in phpmyadmin?


    vB5 is unequivocally the best forum software, but not yet...

    Comment

    • Guest

      #3
      The 'session' table is of type MEMORY so you are running out of memory on your server.
      What's your session timeout value in AdminCP?
      Have you increased to a very high value causing the sessions to pile up?

      Comment

      • Huskermax
        Senior Member
        • Mar 2010
        • 622
        • 4.2.X

        #4
        Originally posted by beishe8
        Perhaps you should empty your session table in phpmyadmin?
        That won't hurt anything will it? Is like dumping all your temp files in windows?

        Comment

        • Huskermax
          Senior Member
          • Mar 2010
          • 622
          • 4.2.X

          #5
          Originally posted by mgyver
          The 'session' table is of type MEMORY so you are running out of memory on your server.
          What's your session timeout value in AdminCP?
          Have you increased to a very high value causing the sessions to pile up?
          We're do I find that in admincp?

          Comment

          • Huskermax
            Senior Member
            • Mar 2010
            • 622
            • 4.2.X

            #6
            Originally posted by mgyver
            The 'session' table is of type MEMORY so you are running out of memory on your server.
            What's your session timeout value in AdminCP?
            Have you increased to a very high value causing the sessions to pile up?
            Found it. It was set at 7400 so I dropped it down to 1200.

            Comment

            • Huskermax
              Senior Member
              • Mar 2010
              • 622
              • 4.2.X

              #7
              what is this Database error in vBulletin 4.2.0 patch 2

              Can I see the size of the session table in phpmyadmin?

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              😀
              😂
              🥰
              😘
              🤢
              😎
              😞
              😡
              👍
              👎