2018-07-26, 09:16 AM
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,)
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,)