This happens when I post...
 

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?

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.

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

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

I think I have 2.2.8, actually.

PMA 2.3.0, not vB 2.3.0.

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

Ohhhhhhh, I'll try that out.

And don't forget to submit the query ;).

Dave.

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

It should be a drop down menu with a bunch of database names and how many tables there are in round brackets.
When you select a database, phpMyAdmin opens it in the right hand side of the screen.
Find the big edit box and put the query in there.
Then submit :p.

Dave.

PS: If this is not what it looks like to you, I'm afraid you're not talking about phpMyAdmin.

I'm quite sure it's phpMyAdmin, considering the name, address, and title say so... LoL. But the thing is, WHICH LINK on the left do I have to click? I don't see any button that allows to drop, they're just 52 separate files. I'll click one, I'll get a page for that... Etc.

Ohhhhhh wait, now I understand what you're saying... The thing is, I don't have a textarea box in my left frame...

You're kidding, right?

No, seriously. There's no textarea box in my left frame.

Found it... 'nother problem. I ran the query, and got this:

Table Op Msg_type Msg_text
searchindex repair error 28 when writing to datafile
searchindex repair error 28 when writing to datafile
infin.searchindex repair status Operation failed

I can sort of imagine that means it didn't work, so, what do I do now?

I'm going through fixing this error now, and I've got to say, thank GOD I have a development database that I could grab the structure of the searchindex and word tables from (after dropping them, per filburt's instructions).

If you drop these tables, run a sql export of their structure first, because rebuilding the index isn't possible without the table's existence.