the feed on http://www.bs-eutin.de does not work anymore (it did before; unfortunately I did not notice when and why it stops working).
In my browser (Safari) the message
shows up.This page contains the following errors:
error on line 1 at column 1: Document is empty
Below is a rendering of the page up to the first error.
In my feedreader the message shows
Code: Select all
Query failed: <pre>SELECT
e.isdraft AS orderkey,
ep_cache_extended.value AS ep_cache_extended,
ep_cache_body.value AS ep_cache_body,
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 OUTER JOIN s9y_categorytemplates ctpass
ON (ec.categoryid = ctpass.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_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN s9y_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN s9y_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access') LEFT JOIN s9y_authorgroups AS acl_a
ON acl_a.authorid = 0
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 <= 1242773700 AND (ctpass.pass IS NULL OR ctpass.pass = '' OR ctpass.pass = '') AND (e.id NOT IN (SELECT e.id FROM s9y_entries AS e
LEFT JOIN s9y_entrycat AS ec ON ec.entryid = e.id
JOIN s9y_categorytemplates AS t ON ec.categoryid = t.categoryid AND hide_rss = '1')) AND (ep_access.property IS NULL OR ep_access.value = 'public') AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true') AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY e.id
ORDER BY orderkey DESC, last_modified DESC
LIMIT 1</pre> / 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 e.id FROM s9y_entries AS e
L
Regards,
Hanjo.