Help Paul!

H

Highboy90

Guest
When members try to use the "View New Posts" feature, they and I now get the following error. The search function works fine. Any ideas?

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT searchid FROM search WHERE query='1=1 AND NOT (thread.forumid='52') AND thread.lastpost>=1048198121 AND thread.open<>10'
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Thursday 20th of March 2003 05:14:32 PM
Script: http://www.xxxxxxxxxxx.com/forum/fo...p?action=getnew
Referer: http://www.xxxxxxxxxxx.com/forum/

I know I should upgrade to 2.2.9 and I did search Vbulletin and found that the search table could be corrupted though as I said, the search function works fine. Do you think running this query in phpMyAdmin would hurt anything?

REPAIR TABLE search;
 
Never mind Paul. I did manage to fix it.

Uploaded fresh search.php (made no difference)
Uploaded repair.php ..../forum/admin/repair.php?html=1&check=1
Found error but did not repair.
Closed browser and reopened. Ran repair.php again. All is fine now. B)
 
Yeah. I know you got this stuff down much better than I do. Been busy or don't like us anymore?
 
Back
Top Bottom