MyBB Community Forums

MyBB SQL Error

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 LIMIT 0,100' at line 5
Query:
   SELECT r.dateline, u.username, g.namestyle, u.uid FROM (mybb_threadsread as r, mybb_users as u) LEFT JOIN mybb_usergroups as g ON (g.gid = u.usergroup) WHERE r.uid = u.uid AND r.tid = ORDER BY r.dateline DESC LIMIT 0,100

Please contact the MyBB Group for technical support.





Please help me

url  www.bengforum.com

I received a similar error.

Forum: http://www.roughingafterthewhistle.com
Version: 1.8.3

The error occurred when I tried to Approve moderated posts from a user's search history page: http://www.roughingafterthewhistle.com/s...6cf6e1ebe9

I checked the box next to the individual post and selected Approve Post from the Inline Post Moderation drop down menu. I Clicked 'Go' then received this error:

[attachment=33447]

(I have blacked out the prefix of my table name for security purposes)