2012-05-20, 12:34 PM
When I make as read the reports i get this error message:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 ') ORDER BY r.dateline DESC' at line 7
Query:
SELECT r.*, u.username, up.username AS postusername, up.uid AS postuid, t.subject AS threadsubject FROM mybb_reportedposts r LEFT JOIN mybb_posts p ON (r.pid=p.pid) LEFT JOIN mybb_threads t ON (p.tid=t.tid) LEFT JOIN mybb_users u ON (r.uid=u.uid) LEFT JOIN mybb_users up ON (p.uid=up.uid) WHERE r.rid IN () ORDER BY r.dateline DESC
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 ') ORDER BY r.dateline DESC' at line 7
Query:
SELECT r.*, u.username, up.username AS postusername, up.uid AS postuid, t.subject AS threadsubject FROM mybb_reportedposts r LEFT JOIN mybb_posts p ON (r.pid=p.pid) LEFT JOIN mybb_threads t ON (p.tid=t.tid) LEFT JOIN mybb_users u ON (r.uid=u.uid) LEFT JOIN mybb_users up ON (p.uid=up.uid) WHERE r.rid IN () ORDER BY r.dateline DESC