Incorrect key file for table 'serendipity_entries'

Found a bug? Tell us!!
Post Reply
mburger
Posts: 2
Joined: Fri Sep 09, 2005 5:41 pm

Incorrect key file for table 'serendipity_entries'

Post 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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Incorrect key file for table 'serendipity_entries'

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
mburger
Posts: 2
Joined: Fri Sep 09, 2005 5:41 pm

Post 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!
Post Reply