Page 1 of 1

Help Help Serendipity black out

Posted: Wed Jul 27, 2005 1:23 pm
by FRandy
Query failed:
SELECT
ep_sticky.value AS orderkey,

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 OUTER JOIN serendipity_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN serendipity_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
WHERE isdraft = 'false' AND e.timestamp <= '1122455848' AND (ep_access.property IS NULL OR ep_access.value = 'public')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 3
/ Reçu l'erreur 28 du handler de la table

What does it mean ?
could you help me please ?

Thanks alot

Frandy

Re: Help Help Serendipity black out

Posted: Wed Jul 27, 2005 1:25 pm
by garvinhicking
This is a MySQL error. See http://dev.mysql.com/doc/mysql/en/repair.html

It means you must use phpMyAdmin or MySQL command line to repair your tables, or contact your server administrator.

Table failures can happen if your server unexpectedly crashed.

Regards,
Garvin