error

[rexxx]

installed the forum this is what I get

Query failed:
SELECT


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
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 JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
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.authorid = 0) AND (()) 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 timestamp DESC
LIMIT 15
/ 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 ')) AND ( c.categoryid IS N

[garvinhicking]

Hi!

Hm, this error should actually not be related to the forums plugin?!

Did you install other plugins? Can you go to your admin center and remove the forum plugin and see if the error goes away? Because I believe it must be caused by some other interference.

This part of the query:

Code: Select all

WHERE isdraft = 'false' AND (e.authorid = 0) AND (()) AND

is making trouble. "AND (())" should not be there, and it can only be injected by a misfunctioning plugin. But the forum plugin does not touch/hook into this part of the code...

Best regards,
Garvin