Page 1 of 1

Incorrect key file for table 'serendipity_entries'

Posted: Fri Sep 09, 2005 5:43 pm
by mburger
If I try to save an edited entry I will get the following error message:

Code: Select all

Error:

UPDATE serendipity_entries SET id='26', title='Heavy problems with RMI - solution found', timestamp='1113736816', body='

While reading an \"old\" tutorial at http://java.sun.com/docs/books/tutorial/rmi/running.html I found the solution, the codebase was not specified in the right way.
\r\n', extended='

The code base has to be
\r\n\r\n    file:/E:\\Uni\\DiplInf\\workspace\\RMItest\\bin/\r\n\r\n

and not
\r\n\r\n    file://E:/Uni/DiplInf/workspace/RMItest/bin/\r\n\r\n', isdraft='false', allow_comments='true', moderate_comments='false', exflag='1', last_modified='1126272743', authorid='1'  WHERE id='26'

/ Incorrect key file for table 'serendipity_entries'; try to repair it

Re: Incorrect key file for table 'serendipity_entries'

Posted: Fri Sep 09, 2005 6:20 pm
by garvinhicking
It would help if you could state your serendipity version, how/if you upgraded from/to which version and what database type you're using.

The error seems to be MySQL specific. Use phpMyAdmin or the mysql command line client to repair your database - or contact your system administrator. It's a problem of the database files, so the error is not coming from Serendipity itself...

Regards,
Garvin

Posted: Fri Sep 09, 2005 6:48 pm
by mburger
"Do'h!" I should read the error message more carefully. The table was marked as crashed. REPAIR TABLE `serendipity_entries` should solved the problem. Thank you for the fast response!