No announcement yet.

Search results returning MySQL error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Search results returning MySQL error

    My forum returns a MySQL error message upon searching, whether you are using the search feature, or just clicking on a link to view the latest posts since your last visit. I have not changed or adjusted anything recently. What could it be?

  • #2
    <!-- Database error in vBulletin 2.3.0:

    Invalid SQL: INSERT INTO search (searchid,query,dateline,querystring,showposts,userid,ipaddress) VALUES (NULL,'1=1 AND NOT (thread.forumid=\'80\' OR thread.forumid=\'44\' OR thread.forumid=\'123\' OR thread.forumid=\'116\' OR thread.forumid=\'92\' OR thread.forumid=\'122\' OR thread.forumid=\'66\') AND thread.lastpost>=1066256104 AND<>10',1066342504,'',0,0,'')
    mysql error: Can't open file: 'search.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Thursday 16th of October 2003 05:15:04 PM
    Your search table is corrupted. 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. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.)
    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.