Serendipity Forums

I was editing a post on my blog and when i saved something went wrong. I saw a strange outline and the blog said i should repair things.

Well i just closed the window and reloaded my weblog. I got an big error and i've got no idea how to fix it. Some ideas, help?

I do have the add that i was editing a post which had strange signs after a mysql update two weeks ago. The ë was something like this for instance: ₧. So i edited those to show corectly in my blog.

---Error: www.wesselvanschaijk.nl

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.username AS loginname,
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
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1180099200 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Can't open file: 'serendipity_entries.MYI' (errno: 145)

Hi!

This error means that Serendipity cannot access the table 'serendipity_entries' on your database server.

It might be that file is either missing, or corrupt.

The cause of this is not within Serendipity, but with the database server itself. Please talk to your provider and ask him if the server crashed and if he can check/repair the 'serendipity_entries' table for you.

If you're using phpMyAdmin, you can try to check yourself if you can issue the repair command on that table.

Best regards
Garvin

I never worked with phpMyAdmin, so how and where to repair.

If i click at serendipity_entries it says this:

Error

SQL query: Edit

SHOW INDEX FROM `serendipity_entries` ;

MySQL said: Documentation
#1016 - Can't open file: 'serendipity_entries.MYI' (errno: 145)

------

What to do to repiar or fix it in phpMyAdmin?

Hi!

If that happens, you will need to contact your system provider to help you. It seems to be an error you cannot fix with phpMyAdmin. It must be fixed by the admin.

Regards,
Garvin

It has been repaired by my host, thank god

thanks for your help and quick reply.

cheers