EMERGENCY ERROR! What does this mean?

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
psiege
Regular
Posts: 52
Joined: Thu Mar 27, 2008 4:21 pm

EMERGENCY ERROR! What does this mean?

Post by psiege »

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 = 1
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 <= 1214326800 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 10

/ Got error 28 from storage engine

I get this when visiting the home page of my blog... http://www.pcdoctor-community.com

Please help!

Thanks
Don Chambers
Regular
Posts: 3652
Joined: Mon Feb 13, 2006 2:40 am
Location: Chicago, IL, USA
Contact:

Post by Don Chambers »

Did you just perform an upgrade? I have seen that behavior when an upgrade was not completed correctly. There is a FAQ on how to correctly perform an upgrade.

If you did nothing, it could be a temporary problem with your hosting provider (if you have one). Hopefully, those with greater server/SQL experience will provide a more complete answer.
=Don=
psiege
Regular
Posts: 52
Joined: Thu Mar 27, 2008 4:21 pm

Post by psiege »

Nope, no upgrade performed. From what I'm reading, might be a storage issue on the server drives.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Exactly, you must contact your provider, the problem is beyond Serendipity -- it's a fault of your database service.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply