Announcement

Collapse
No announcement yet.

problem for session table"help me"plz

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

  • problem for session table"help me"plz

    Database error in vBulletin 3.0.1:

    Invalid SQL:
    INSERT INTO session
    (sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
    VALUES
    ('5cea820d82798bec7b906b048b5a95bf', 1, '195.229.241.188', '4720f49637ec2cb0e5f9335e447e37d8', 1086176197, 0, 1, 1, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; ESB{610E5335-2BBA-4FDD-9CEB-AD62F800E4A6})')

    mysql error: The table 'session' is full

    mysql error number: 1114



    in my phpmy admin table session for heab

  • #2
    You can clear the session table. It will only show the current online users as 0 until someone gets online again.

    Close your forum first, then empty the table (don't drop it) and open your forum again.

    Comment


    • #3
      have you removed $cronimage from your footer?
      Scott MacVicar

      My Blog | Twitter

      Comment


      • #4
        thankx team vbulliten

        Comment


        • #5
          Originally posted by Floris
          You can clear the session table. It will only show the current online users as 0 until someone gets online again.

          Close your forum first, then empty the table (don't drop it) and open your forum again.
          Hello, I have done this, but is there a workaround to avoid it from happening in the future. Why does the table session keep filling up?

          Here is the exact error I keep getting . . . note that once I clear the session table I am good for a couple of weeks.

          Database error in vBulletin 3.0.1:

          Invalid SQL:
          INSERT INTO session
          (sessionhash, userid, host, idhash, lastactivity, styleid, useragent)
          VALUES
          ('317fa5c6e9afad5c9dc758755fc0c09c', 0, '', '', 1086821230, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)')

          mysql error: The table 'session' is full

          mysql error number: 1114

          Comment


          • #6
            Revert your footer template back to original. You are missing the $cronimage part that automatically empties the session table on a regular schedule. Either that or you have removed one or more of the default Scheduled Tasks.
            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


            • #7
              Thanks Steve

              Comment

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