Announcement

Collapse
No announcement yet.

Search Page Errors

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

  • Search Page Errors

    can someone please tell me how to fix this?

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE querystring!="" AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,10
    mysql error: Can't open file: 'search.MYI'. (errno: 145)

    mysql error number: 1016

    Date: Wednesday 04th of June 2003 01:35:43 AM
    Script: http://www.xbox100.com/forums/forums/search.php?s=
    Referer:

  • #2
    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:

    http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

    [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.


    Comment


    • #3
      thank you a lot, worked great

      Comment

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