When I try to connect to my blog I get:
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.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 OUTER JOIN serendipity_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
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') 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 <= 1204133100 AND (ep_access.property IS NULL OR ep_access.value = 'public') AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true') AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 15
/ Table './acampbell/serendipity_entries' is marked as crashed and should be repaired
Not sure what to do here - should I upload everything again?
Anthony
Serendipity has crashed
-
- Regular
- Posts: 138
- Joined: Fri Jun 09, 2006 8:59 pm
- Location: London, UK
- Contact:
Serendipity has crashed
Anthony Campbell
Your provider's MySQL host or database had a problem. Obviously your provider should fix it; contact them to tell them what the problem is and get them moving. At the very least, they should be able to restore a backup.
Meanwhile, you may be able to repair the table and get Serendipity running again.
Repairing MySQL tables in cPanel
Other software has the same problem; try accessing your database through phpMyAdmin, if your provider includes it. You should have the option to repair the table, or even the whole database.
Meanwhile, you may be able to repair the table and get Serendipity running again.
Repairing MySQL tables in cPanel
Other software has the same problem; try accessing your database through phpMyAdmin, if your provider includes it. You should have the option to repair the table, or even the whole database.
-
- Regular
- Posts: 138
- Joined: Fri Jun 09, 2006 8:59 pm
- Location: London, UK
- Contact:
-
- Regular
- Posts: 138
- Joined: Fri Jun 09, 2006 8:59 pm
- Location: London, UK
- Contact: