Query failed:

[master__]

If I go to my blog this appears:
###################
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
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 <= '1132786038' 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: 126)
##############
What is the problem? Is it the mysql server?

Master

[garvinhicking]

Yes, a file read/permission/crash error happened with your MySQL database. You might need to contact your admin. First try to use a tool like phpMyAdmin to repair this table.

Or google for your error message "Can't open file errno: 126"

Regards,
Garvin

[master__]

I've tried it with phpMyAdmin. Every table is accessable exept serendipity_entries.MYI! phpMyAdmin is not able to open that table. But the file exists in the mysql dir.

Can't open file: 'serendipity_entries.MYI'. (errno: 126)

Fehler
SQL-Befehl:
SHOW KEYS FROM `serendipity_entries` ;

MySQL meldet:
#1016 - Can't open file: 'serendipity_entries.MYI'. (errno: 126)

foo:/var/lib/mysql/s9y# ls -l serendipity_entries*
-rw-rw---- 1 mysql mysql 9001 2005-11-02 20:34 serendipity_entries.frm
-rw-rw---- 1 mysql mysql 6724 2005-11-18 21:17 serendipity_entries.MYD
-rw-rw---- 1 mysql mysql 18432 2005-11-23 14:25 serendipity_entries.MYI

I have no plan what the error is


Master

[garvinhicking]

The error is with your MySQL installation. Please talk to your sysadmin to use the mysql commandline tools to repair the table.

It seems your MySQL crashed once, and the file was left in a damaged state.

You might need to ask MySQL support for further help.

Regards,
Garvin

[master__]

a
"mysql> REPAIR TABLE serendipity_entries USE_FRM;"
has repaired the table


Master