database access problems

[wous]

hello,

I installed serendipity with MySQL database, and this went fine. However, after about a week of inactivity, the index page suddenly showed this:

Query failed:

SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email

, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid

WHERE isdraft = 'false' AND e.timestamp <= '1119448826'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Can't open file: 'serendipity_entries.MYI'. (errno: 138)

In PhpMyAdmin, the table 'serendipity_entries' is 'in use' and when trying to access it, the same error is given:

#1016 - Can't open file: 'serendipity_entries.MYI'. (errno: 138) ')

Two questions:

- How to solve?
- May the problem be caused by serendipity, or is there something wrong with the MySQL installation?

thanks,

wouter

[garvinhicking]

You need to login to your phpMyAdmin and choose "Repair table" in the dropdown of your table structure. If this does not help you need to contact your server Administrator.

The problem is most likely caused by a hardware failure of your server; it could have crashed somewhen, or the MySQL daemon could have crashed. In any case it's a failure of the server itself, applications cannot cause this error.

Regards,
Garvin

[wous]

Thanks for the fast reply! Time to contact my server's system administrator...