This happens when I post...

[Super Shadow]

I get an error message saying the following...









There seems to have been a slight problem with the Infinity Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.





Database error in vBulletin 2.2.8:

Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (167,29703,0),(272,29703,0),(2221,29703,0),(4963,2 9703,0),(12478,29703,0)
mysql error: Can't open file: 'searchindex.MYD'. (errno: 145)

mysql error number: 1016

Date: Friday 21st of March 2003 11:30:31 PM
Script: http://www.infinityforums.com/newreply.php
Referer: http://www.infinityforums.com/showth...?threadid=1773


Anyone know how I can fix that?

[filburt1]

Run the query:
[sql]
REPAIR TABLE searchindex;
[/sql]
If it fails then just drop the searchindex and word tables and rebuild the search index from the admin CP.

[Super Shadow]

Where, exactly, can I run this query? phpMyAdmin, I know, but where IN it? Which little link (on the left)?

[filburt1]

The SQL tab (provided you have PMA 2.3.0 or later)

[Super Shadow]

I think I have 2.2.8, actually.

[filburt1]

PMA 2.3.0, not vB 2.3.0.

[Davey]

-- In phpMyAdmin --
Select the database from the left and then you should see a textarea box (edit box with about 7 lines and it's almost the same size as this quick reply box).
Place in that box as filburt1 said:

REPAIR TABLE searchindex;

Dave.

[Super Shadow]

Ohhhhhhh, I'll try that out.

[Davey]

And don't forget to submit the query .

Dave.

[Super Shadow]

I don't have the SQL tab on the left... Nor do I have the database tag on the left.