Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.0.7 [Help!]

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

  • Database error in vBulletin 3.0.7 [Help!]

    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity, session.host ,
    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 > 1127856578
    ORDER BY username ASC

    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016


    ""Can some one please help me out with this ?""

  • #2
    [Thread moved to the appropiate forum]

    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    Can't open file: '<table>.MYI'. (errno: 145)
    Error 145 = Table was marked as crashed and should be repaired

    You should run optimize & repair on your database tables.

    Comment

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