MyBB Community Forums
MyBB SQL Error - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: MyBB SQL Error (/thread-218954.html)



MyBB SQL Error - Skyderp - 2018-07-26

I get this error when I visit my forums: 

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 MariaDB server version for the right syntax to use near ')' at line 5Query:SELECT s.sid, s.ip, s.uid, u.username, s.time, u.avatar, u.usergroup, u.displaygroup, u.invisible FROM mybbbh_sessions s LEFT JOIN mybbbh_users u ON (s.uid=u.uid) WHERE u.usergroup IN(3,4,6,9,10) AND time > 1532595670 ORDER BY FIELD(u.usergroup, 10,4,9,3,6,)


RE: MyBB SQL Error - effone - 2018-07-27

Is this resolved (as it is marked)?

Seems like usage of a restricted keyword. Can you please describe further visiting which page this error has occurred and for which line, if possible?