Another Newsbox Question
Posted: Fri Feb 23, 2007 4:37 pm
I see that others have had this same issues, however I read English only so I could not read the answers. Newbox installs, but if I check the Use category option, this shows up on the frontpage -- If I check Newbox option, normal frontpage shows up but the newsbox will not nest other newsboxes that contain categories. Suggestions for fixing greatly appreciated.
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
s_entries AS e
LEFT JOIN s_authors a
ON e.authorid = a.authorid
LEFT JOIN s_entrycat ec
ON e.id = ec.entryid
LEFT JOIN s_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN s_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN s_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN s_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') LEFT JOIN s_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN s_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 <= 1172244900 AND
e.id IN
(SELECT entryid FROM s_entrycat
WHERE categoryid IN (5)
) 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 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 s_entrycat WHERE categoryid IN (5) ) AND
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
s_entries AS e
LEFT JOIN s_authors a
ON e.authorid = a.authorid
LEFT JOIN s_entrycat ec
ON e.id = ec.entryid
LEFT JOIN s_category c
ON ec.categoryid = c.categoryid
LEFT OUTER JOIN s_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN s_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
LEFT JOIN s_entryproperties ep_sticky
ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') LEFT JOIN s_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN s_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 <= 1172244900 AND
e.id IN
(SELECT entryid FROM s_entrycat
WHERE categoryid IN (5)
) 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 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 s_entrycat WHERE categoryid IN (5) ) AND