Page 1 of 1

Eeep! Meep! My blog died.

Posted: Tue Jul 26, 2005 4:50 pm
by Martin
Okay; One second my blog is fine and dandy and the next time I check it it's dead. what I get is this error message:

Code: Select all

Query failed:
SELECT 
                    ep_sticky.value AS orderkey,

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.author,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.email

                    
                    
                FROM
                    blog_entries AS e
                    LEFT JOIN blog_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN blog_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN blog_category c
                        ON ec.categoryid = c.categoryid
                    LEFT OUTER JOIN blog_entryproperties ep_access
                                             ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN blog_entryproperties ep_sticky
                                                 ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
                     WHERE  (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1))  
                    GROUP BY e.id
                    ORDER BY orderkey DESC, timestamp DESC
                     LIMIT 0, 12
/ Got error 28 from table handler
Just thought I'd see if anyone here can make heads or tails of this before I start my (usually destructive) troubleshooting.

-M

Posted: Tue Jul 26, 2005 5:13 pm
by Martin
Nevermind folks...
Server hiccup it seems.

-M