Announcement

Collapse
No announcement yet.

mySQL Error

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

  • mySQL Error

    I am getting this error when I try to access my board:
    Database error in vBulletin 3.0.0 Beta 4:
    Invalid SQL:
    ### SHOW USERS BROWSING THE BOARD ###
    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM session AS session
    LEFT JOIN user AS user ON(user.userid = session.userid)
    WHERE session.lastactivity > 1057752338
    ORDER BY invisible ASC, username ASC

    mysql error: Can't open file: 'session.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Wednesday 09th of July 2003 07:35:38 AM
    Script: http://www.floridathrills.net/
    Referer:
    Username: BGTKing
    http://www.bgtguide.com
    Busch Gardens Tampa Guide
    Forums: http://www.floridathrills.net

  • #2
    Your database is corrupt (the thread table it seems).

    Goto phpmyadmin and check the thread table.

    Brows down below all the tables and from the drop down box select optimize

    When the page reloads, check the thread table again and browse down again, this time select repair from the drop down box.

    Test your forum and see if the error still occurs.

    Comment


    • #3
      Ok, thanks. I'll try that.

      EDIT: The repair fixed it.
      Last edited by bgtking; Wed 9 Jul '03, 6:48am.
      http://www.bgtguide.com
      Busch Gardens Tampa Guide
      Forums: http://www.floridathrills.net

      Comment


      • #4
        Yahoo!

        Comment

        Loading...
        Working...
        X