error 145
Posted: Sat Nov 04, 2006 11:02 am
I'm unable to view my blog after a posting tonight. (Actually, I attempted to delete a post unsuccessfully) I recieve the following error when I try to log on:
/ Can't open file: 'serendipity_entries.MYI'. (errno: 145)
And here is the entire page that is displayed:
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 <= 1162634354
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 4
/ Can't open file: 'serendipity_entries.MYI'. (errno: 145)
Any help is MUCH appreciated!
Bobasaur
/ Can't open file: 'serendipity_entries.MYI'. (errno: 145)
And here is the entire page that is displayed:
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 <= 1162634354
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 4
/ Can't open file: 'serendipity_entries.MYI'. (errno: 145)
Any help is MUCH appreciated!
Bobasaur
You can execute that command using a tool like phpMyAdmin - do you have that installed? If so, just click on the 'SQL' tab, where you can paste the query I gave you into!