MyBB Community Forums

Full Version: SQL Error on Index page ONLY
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
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
It had to have been caused by a bug in a plugin. I'm guessing Recent Topics on Index.