wieder ein kleines Problem, und zwar würde ich gerne mal dieses Newsbox Plugin antesten.
Habe es schon mehrmals Installiert, aber es kommt immer das gleiche.
Wenn ich als Inhalt der Newsbox den Punkt "Categories" auswähle, und dann noch eine oder mehrere Kategorien auswähle, kommt folgende meldung auf der Index:
Ist das ein fehler von meiner Seite?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.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')
WHERE isdraft = 'false' AND e.timestamp <= 1139063511 AND
e.id IN
(SELECT entryid FROM serendipity_entrycat
WHERE categoryid IN (Which categories will this newsbox contain?
If you decided this newsbox should contain categories, you can select them here. You may select multiple categories. Their entries will be removed from the entry listing, and added to this newsbox.
Kategorien
)
) 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')
GROUP BY e.id
ORDER BY orderkey DESC, timestamp DESC
LIMIT 5
/ You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT entryid FROM serendipity_entrycat WHERE categoryid IN