Page 1 of 1

Attempt to edit entry kills whole blog????

Posted: Sun Apr 17, 2005 8:15 pm
by Hathor
I tried to edit an entry from March, and it gave me an error message, and now when I attempt to load the blog, all that shows up is a big blank white page with:
Query failed:

SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.author,
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 <= '1113761525'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15

/ Can't open file: 'serendipity_entries.MYI' (errno: 145)
This is the blog in my signature, the one that's never had any problems, not the one I just moved hosts on.

The only thing I did to it today was, in the CSS for the style I'm using, I changed one font color. I can't see how that would have caused this.

The only other thing I can think of is, when I went to hit "Save" to my edited entry, it didn't do anything at first. What if I accidentally hit "Preview" first, then hit "Save" before it could do the preview, not realizing I'd hit both? Could that have caused this?

I'm upgrading to .8 now, which may take care of the problem, but I want to know what I did wrong so I won't make that mistake again!

Re: Attempt to edit entry kills whole blog????

Posted: Sun Apr 17, 2005 8:47 pm
by garvinhicking
The error message means your MySQL Database crashed or your server crashed.

This it not an issue Serendipity may cause, it's a fault on the server side. Maybe HDD corruption or memory garbabe or a crash. You'll need to talk to your provider.

You probably did not cause this by any actions.

Regards,
Garvin

Posted: Sun Apr 17, 2005 10:22 pm
by Hathor
In case anyone has a similar problem ever, the solution was simply to use the database repair feature in MySql in my cpanel.