PDA

View Full Version : This happens when I post...

Super Shadow
03-22-2003, 02:36 AM
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/showthread.php?threadid=1773


Anyone know how I can fix that?
filburt1
03-22-2003, 02:48 AM
Run the query:

REPAIR TABLE searchindex;

If it fails then just drop the searchindex and word tables and rebuild the search index from the admin CP.
Super Shadow
03-22-2003, 02:53 AM
Where, exactly, can I run this query? phpMyAdmin, I know, but where IN it? Which little link (on the left)?
filburt1
03-22-2003, 02:55 AM
The SQL tab (provided you have PMA 2.3.0 or later)
Super Shadow
03-22-2003, 02:55 AM
I think I have 2.2.8, actually.
filburt1
03-22-2003, 02:56 AM
PMA 2.3.0, not vB 2.3.0.
Davey
03-22-2003, 02:57 AM
-- 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
03-22-2003, 02:57 AM
Ohhhhhhh, I'll try that out.
Davey
03-22-2003, 02:58 AM
And don't forget to submit the query ;).

Dave.
Super Shadow
03-22-2003, 02:59 AM
I don't have the SQL tab on the left... Nor do I have the database tag on the left.
Davey
03-22-2003, 03:04 AM
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.
Super Shadow
03-22-2003, 03:07 AM
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.
Super Shadow
03-22-2003, 03:12 AM
Ohhhhhh wait, now I understand what you're saying... The thing is, I don't have a textarea box in my left frame...
N!ck
03-22-2003, 03:14 AM
You're kidding, right?
Super Shadow
03-22-2003, 03:14 AM
No, seriously. There's no textarea box in my left frame.
Super Shadow
03-22-2003, 03:20 AM
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?
AmericanWoman
09-15-2003, 11:43 AM
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.