No announcement yet.

Unkown MYSQL Error Help Please!

  • Filter
  • Time
  • Show
Clear All
new posts

  • Unkown MYSQL Error Help Please!

    Database error in vBulletin 2.3.0:
    Invalid SQL: SELECT thread.replycount,thread.threadid,thread.lastpost,thread.lastposter,thread.views,thread.ti tle,user.userid FROM thread LEFT JOIN user ON (user.username=thread.lastposter) WHERE forumid NOT IN(0) ORDER BY lastpost DESC LIMIT 10
    mysql error: Can't open file: 'thread.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Wednesday 04th of June 2003 03:54:06 PM

    Please help me what to do, I cant figure out the problem.

  • #2
    1. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums (ignore the message that the session table can't be repaired.) If not, then run it again. The second time everything should report Ok.

    2. Read this thread:
    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.


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