database access problems
Posted: Tue Jun 28, 2005 12:55 am
hello,
I installed serendipity with MySQL database, and this went fine. However, after about a week of inactivity, the index page suddenly showed this:
- How to solve?
- May the problem be caused by serendipity, or is there something wrong with the MySQL installation?
thanks,
wouter
I installed serendipity with MySQL database, and this went fine. However, after about a week of inactivity, the index page suddenly showed this:
In PhpMyAdmin, the table 'serendipity_entries' is 'in use' and when trying to access it, the same error is given: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)
Two questions:#1016 - Can't open file: 'serendipity_entries.MYI'. (errno: 138) ')
- How to solve?
- May the problem be caused by serendipity, or is there something wrong with the MySQL installation?
thanks,
wouter