The Arcive of vBulletin Modifications Site.

search.MYD · **Released**: 08-23-2002

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT searchid,dateline FROM search WHERE userid=19 ORDER BY
dateline DESC LIMIT 1
mysql error: Can't open file: 'search.MYD'. (errno: 145)

mysql error number: 1016

Date: Friday 23rd of August 2002 07:31:34 PM
Script: http://forum.racesimcentral.com/search.php
Referer: http://forum.racesimcentral.com/search.php?s=

[b]what does this mean??{/b]

Steve Machol · #2 08-23-2002, 06:18 PM

Your search table crashed. 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:

repair.php?html=1&check=1

It everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.

Tim Wheatley · #3 08-23-2002, 06:58 PM

repair.php didn't work as it couldn't get access, it also just seemed to do nothing too (the blue bar was loading for 5mins or more).

I had to use phpmyadmin and repair it in there, it's now fixed, thanks for your time on the answer.