[Forum] Database Error

[Tailfeathers]

After upgrading to 4.1.4, when I edit a post, I get a popup alert saying nothing more than "Database Error".

The edit goes through, however.

Any thoughts on how to solve this?

[Zachery]

You should be getting an email with a database error.

[Tailfeathers]

Here's the error:

Invalid SQL:
INSERT INTO searchcore_text (searchcoreid, keywordtext)
                       VALUES ( 793253, 'Re: Oh Dan... I noticed it with editing yeah, just posted it on vbulletin forums to ask about it...\n\nDo you get it when quick replying, doing a full reply, or what? I haven\'t noticed it yet when replying!' )
                       ON DUPLICATE KEY UPDATE  searchcoreid = VALUES(searchcoreid), keywordtext = VALUES(keywordtext);

MySQL Error   : Incorrect key file for table './tailfea_community/searchcore_text.MYI'; try to repair it
Error Number  : 126

I'll try the repair function in the settings. I already ran these on everything other than the search ones actually (they are large so they tend to crash!). Will give them a try...

[Tailfeathers]

It's over 11mb, it just sits there forever and never completes. Maybe it's timing out?

Any tips on how I can get the repair function to actually work here (or how to otherwise get rid of this error)?

[Tailfeathers]

Got it. The repair solved it.