Attempt to edit entry kills whole blog????

Found a bug? Tell us!!
Post Reply
Hathor
Regular
Posts: 118
Joined: Tue Mar 22, 2005 11:48 pm

Attempt to edit entry kills whole blog????

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

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

Post 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
# 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/
Hathor
Regular
Posts: 118
Joined: Tue Mar 22, 2005 11:48 pm

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