error 145

[Bobasaur]

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

[garvinhicking]

Hi!

This error message says that an important file of your database server, "serendipity_entries.MYI" no longer exists.

The MySQL file server relies on that file, and it seems your server crashed or some other external mechanism destroyed that file. You can ask your provider how this could have happened?

In either case, you or your provider needs to restore a backup! It is sadly not the fault of Serendipity what happened here, but a crash in the provider's MySQL system. PHP applications have no change to selecitvely delete a "MYI" file, only the MySQL server process or other external Shell-Processes can have an influence on these files.

Best regards,
Garvin

[Bobasaur]

Thanks for the reply Garvin!

The file is still there in the database, and I noted that it had been written to on 11/4 when I tried to post a "test" entry. It was somehow corrupted on 11/3.

I'll contact the host and see if they have a backup for 11/2 (which I doubt).

Bob Jackson

[garvinhicking]

Hi!

MySQL might be able to rewrite the missing MYI file if you try to issue a "REPAIR TABLE serendipity_entries" command?

Best regards,
Garvin

[Bobasaur]

I really appreciate the feedback Garvin! Now, how do I run that command (dense? I'd love to!) on Hostopia's server, or do I contact their tech support. I do not think I've got that kind of shell access with the account.

Bob

[garvinhicking]

Hi Bob!

Ah, sorry for not being verbose. 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!

HTH,
Garvin

[Bobasaur]

Got it all back Garvin. Thanks for the assist. (I enjoyed installing and using phpMyAdmin, but in the end had to re-install and back up from the rss.xml file)

Bob

[fidij]

Just to thank you for your great support -
I had the same problem and reading this thread I tried the "Repair" command and it worked

[guidol]

Just to thank you for your great support -
I had the same problem and reading this thread I tried the "Repair" command and it worked

Me too!