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;
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;