Please help
Posted: Wed Feb 15, 2006 11:52 pm
Query failed:
SELECT
mr.read_date,
mr.read_date,
mr.read_date,
mr.read_date,
multilingual_body.value AS multilingual_body,
multilingual_extended.value AS multilingual_extended,
multilingual_title.value AS multilingual_title,
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_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_entryproperties multilingual_body
ON (e.id = multilingual_body.entryid AND multilingual_body.property = 'multilingual_body_ro')LEFT OUTER JOIN serendipity_entryproperties multilingual_extended
ON (e.id = multilingual_extended.entryid AND multilingual_extended.property = 'multilingual_extended_ro')LEFT OUTER JOIN serendipity_entryproperties multilingual_title
ON (e.id = multilingual_title.entryid AND multilingual_title.property = 'multilingual_title_ro') 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') LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_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 <= '1140043565' 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, timestamp DESC
LIMIT 5
/ Not unique table/alias: 'mr'
Hello, i have a huge problem.
I cannot display my site anymore, i also cannot edit my posts, i can post them still....
I don't know what is de the problem, but when i open the website (url: www.uitgesproken.com) then the text above is displayed.
Who can help me whit this problem?
Greets
SELECT
mr.read_date,
mr.read_date,
mr.read_date,
mr.read_date,
multilingual_body.value AS multilingual_body,
multilingual_extended.value AS multilingual_extended,
multilingual_title.value AS multilingual_title,
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_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_markread
AS mr
ON (mr.entryid = e.id AND mr.visitor = '3fc4ee0ef7d4ca5e70af6c8fdb9a3080a9a3c5df5fbbf33dd68023757cd87b57')
LEFT OUTER JOIN serendipity_entryproperties multilingual_body
ON (e.id = multilingual_body.entryid AND multilingual_body.property = 'multilingual_body_ro')LEFT OUTER JOIN serendipity_entryproperties multilingual_extended
ON (e.id = multilingual_extended.entryid AND multilingual_extended.property = 'multilingual_extended_ro')LEFT OUTER JOIN serendipity_entryproperties multilingual_title
ON (e.id = multilingual_title.entryid AND multilingual_title.property = 'multilingual_title_ro') 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') LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_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 <= '1140043565' 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, timestamp DESC
LIMIT 5
/ Not unique table/alias: 'mr'
Hello, i have a huge problem.
I cannot display my site anymore, i also cannot edit my posts, i can post them still....
I don't know what is de the problem, but when i open the website (url: www.uitgesproken.com) then the text above is displayed.
Who can help me whit this problem?
Greets