Error: Query failed

This is the place to chat about anything that's related to the free blog-hosting-service called supersized.

Moderator: jhermanns

Locked
PrinzessinS
Posts: 1
Joined: Fri May 29, 2009 7:33 pm

Error: Query failed

Post by PrinzessinS » Fri May 29, 2009 7:43 pm

I hav an Error: Query failed and / Table './ss_7951/entries' is marked as crashed and should be repaired

Code: Select all

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
                    entries AS e
                    LEFT JOIN authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN category c
                        ON ec.categoryid = c.categoryid
                     LEFT OUTER JOIN entryproperties ep_no_frontpage
                                                  ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
 LEFT OUTER JOIN entryproperties ep_access
                                              ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
 LEFT JOIN entryproperties ep_sticky
                                            ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
                    WHERE isdraft = 'false' AND e.timestamp <= 1243619100 AND  (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 2))  AND  (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true') 
                     GROUP BY e.id
            ORDER BY orderkey DESC, timestamp DESC
                      LIMIT 10


Blog: http://prinzessin.supersized.org/

User avatar
jhermanns
Site Admin
Posts: 378
Joined: Tue Apr 01, 2003 11:28 pm
Location: Berlin, Germany
Contact:

Re: Error: Query failed

Post by jhermanns » Fri Jun 12, 2009 11:56 am

hey, did this happen right after you signed up?

Locked