RSS feed does not work anymore
Posted: Wed May 20, 2009 1:25 am
Ladies and gentlemen,
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
In my feedreader the message shows
What to do to get things working again?
Regards,
Hanjo.
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.