2014-07-28, 11:23 PM
Just randomly got it today, never seen this error till now.
Nothing has changed, no new plugins, no setting changes.
Site URL: http://chillforum.zone/
Error Code
Figured it out, caused by when I made a section unactive (Uncheck "Forum is Active?" in admin panel). o.0
Nothing has changed, no new plugins, no setting changes.
Site URL: http://chillforum.zone/
Error Code
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 'WHERE t.fid NOT IN (82,83,90,93,96) AND t.visible = '1' GROUP BY t.tid ' at line 9
Query:
SELECT t.tid, t.fid, t.subject, t.lastpost, t.lastposter, t.lastposteruid, f.name, u.usergroup, u.displaygroup FROM 1388453148_threads AS t INNER JOIN 1388453148_forums as f ON (f.fid = t.fid) LEFT JOIN 1388453148_users AS u ON (t.lastposteruid = u.uid) WHERE t.fid NOT IN ('11','82','34','7','33','16','29','32','37','46','83','90','93','96') WHERE t.fid NOT IN (82,83,90,93,96) AND t.visible = '1' GROUP BY t.tid ORDER BY t.lastpost DESC LIMIT 5
Figured it out, caused by when I made a section unactive (Uncheck "Forum is Active?" in admin panel). o.0