Serendipity Forums

Code: Select all

Fehler:

UPDATE s9y_entries SET id='88', title='Was ich an DSDS wirklich mag', timestamp='1170206849', body='Also Schadenfreude ist es nun wirklich nicht, aber es ist doch eine gewisse Art der Unterhaltung mit großem, wenn auch unfreiwilligem, komediantischem Ausdruck.\r\n\r\nGesang ist hier nur zweitrangig das Thema. Tatsächlich steht an erster Stelle, das Thema Selbstüberschätzung. Wobei es dann doch auch diese anderen Momente gibt...\r\n\r\nMr. Uncool alias Mr. Depp\r\n\r\n\r\nDer Wiederholungstäter\r\n\r\n\r\nDie fleischgewordene Selbstüberschätzung\r\n\r\n\r\n\r\nUnd dann gibt es dieses überaus positive Beispiel, wo die Jury nicht auf das Aussehen achtet, sondern insbesondere auf die Stimme und dies bei einem Stück, welches gar nicht so leicht zu interpretieren ist. Soviel stimmliche Objektivität, hätte ich einem Dieter Bohlen, ehrlich gesagt, nicht zugetraut. \r\n\r\nCarmen Leib mit Zombie von den Cranberries\r\n\r\n', extended='', isdraft='false', allow_comments='true', moderate_comments='false', exflag='0', authorid='<', last_modified='1171285631'  WHERE id='88'

/ Table 's9y_entries' is marked as crashed and should be repaired

Code: Select all

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
                    s9y_entries AS e
                    LEFT JOIN s9y_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN s9y_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN s9y_category c
                        ON ec.categoryid = c.categoryid
                     LEFT OUTER JOIN s9y_entryproperties ep_no_frontpage
                                                  ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
 LEFT OUTER JOIN s9y_entryproperties ep_access
                                              ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
 LEFT JOIN s9y_entryproperties ep_sticky
                                            ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') LEFT JOIN s9y_authorgroups AS acl_a
                                   ON acl_a.authorid = 1
                            LEFT JOIN s9y_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 <= 1171285500 AND  (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1))  AND  (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')   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 orderkey DESC, timestamp DESC
                      LIMIT 15

/ Table 'e' is marked as crashed and should be repaired

Code: Select all

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
                     
                     
                FROM
                    s9y_entries AS e
                    LEFT JOIN s9y_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN s9y_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN s9y_category c
                        ON ec.categoryid = c.categoryid
                     LEFT JOIN s9y_authorgroups AS acl_a
                                   ON acl_a.authorid = 1
                            LEFT JOIN s9y_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'category'
                                       AND acl_acc.artifact_id   = c.categoryid
                                      )
                    WHERE e.isdraft = 'true' 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 0, 13

/ Table 'e' is marked as crashed and should be repaired