getting this error, whats it mean?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • risestar
    Member
    • Apr 2000
    • 85

    getting this error, whats it mean?

    Database error in vBulletin: Invalid SQL: INSERT INTO session
    (sessionid,userid,ipaddress,lastactivity,location) VALUES
    (NULL,0,'166.62.61.76',962680955,'/forum/member.php')
    mysql error: Got error -1 from table handler
    mysql error number: 1030
    Date: Monday 03rd of July 2000 08:22:35 PM
    Script: /forum/member.php
    Referer:
    [url]http://www.dsschat.com/forum/member.php?action=register&who=adult[/url]
  • John
    Senior Member
    • Apr 2000
    • 4042

    #2
    This means that the session table has become corrupted. Delete everything from it, and it should go back to normal.

    John
    John Percival

    Artificial intelligence usually beats real stupidity ;)

    Comment

    • risestar
      Member
      • Apr 2000
      • 85

      #3
      Thanks john ,

      I cleared a bunch of stuff from there, hopefully it will be ok now

      Comment

      • risestar
        Member
        • Apr 2000
        • 85

        #4
        hi john,

        Yes I emptied the session table out and its still re-occuring, any ideas on what is causing it and how to fix?

        Database error in vBulletin: Invalid SQL: INSERT INTO session
        (sessionid,userid,ipaddress,lastactivity,location) VALUES
        (NULL,3237,'24.7.92.179',962746893,'/forum/index.php')
        mysql error: Got error -1 from table handler
        mysql error number: 1030
        Date: Tuesday 04th of July 2000 02:41:33 PM
        Script: /forum/index.php
        Referer: [url]http://www.dsschat.com/forum/forumdisplay.php?forumid=23[/url]



        Using php 4.0.0 with Zend optimizer and VB 1.1.3 Beta

        [Edited by risestar on 07-04-2000 at 05:57 PM]

        Comment

        • Mike Sullivan
          Former vBulletin Developer
          • Apr 2000
          • 13327
          • 3.6.x

          #5
          Well, I would suggest using something like phpMyAdmin, writing down ALL the settings for the table, dropping it, and then recreating it. (Close your board of course)

          Comment

          • John
            Senior Member
            • Apr 2000
            • 4042

            #6
            You would want to run this SQL:

            [code]
            DROP TABLE session;
            CREATE TABLE session (
            sessionid MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL,
            userid SMALLINT UNSIGNED NOT NULL,
            ipaddress CHAR(20) NOT NULL,
            lastactivity INT UNSIGNED NOT NULL,
            location CHAR(250) NOT NULL,
            PRIMARY KEY(sessionid)
            )
            [/code]
            John Percival

            Artificial intelligence usually beats real stupidity ;)

            Comment

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