Announcement

Collapse
No announcement yet.

mySQL Error

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

  • Floris
    replied
    Yahoo!

    Leave a comment:


  • bgtking
    replied
    Ok, thanks. I'll try that.

    EDIT: The repair fixed it.
    Last edited by bgtking; Wed 9 Jul '03, 6:48am.

    Leave a comment:


  • Floris
    replied
    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.

    Leave a comment:


  • bgtking
    started a topic mySQL Error

    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
Loading...
Working...
X