MyBB Community Forums

[attachment=42192]hELLO
after upgrade to 1.8.21
among another error, there IS New error, when I removed the option of "force users to login" I rcv this error on my site

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 (119,91,98,74,112,117,130,46,93,106,79,84,108,30,78,95,109,38' at line 9
Query:
SELECT t.tid, t.fid, t.subject, t.lastpost, t.lastposter, t.lastposteruid, f.name, u.usergroup, u.displaygroup FROM mybb_threads AS t INNER JOIN mybb_forums as f ON (f.fid = t.fid) LEFT JOIN mybb_users AS u ON (t.lastposteruid = u.uid) WHERE t.fid NOT IN (43,94,26,37,4,98,74,112,117,130,46,93,106,79,84,30,78,95,109,38,105,40,57,63,45) WHERE t.fid NOT IN (119,91,98,74,112,117,130,46,93,106,79,84,108,30,78,95,109,38,105,40,57,63,6,120,132,14,121,13,15,48,25,128,18,39,125,122,45,51,11,104,110,10,96,137,133,116) AND t.visible = '1' GROUP BY t.tid ORDER BY t.lastpost DESC LIMIT 5

Looks like a plugin's causing the error.

The query doubles the WHERE t.fid NOT IN (...)

Okay I have found the plugin which was creating this error
"recent posts forum index"
dis activated it. Now site works fine
Thanks.

(2019-09-15, 08:33 AM)noyle Wrote: [ -> ]Looks like a plugin's causing the error.