Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 1 Month, 5 Days ago SQL ERROR 1064
#1
Solved: 1 Month, 5 Days ago
    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
Reply
#2
Solved: 1 Month, 5 Days ago
Looks like a plugin's causing the error.
Worth a try.
Reply
#3
Solved: 1 Month, 5 Days ago
The query doubles the WHERE t.fid NOT IN (...)
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply
#4
Solved: 1 Month, 5 Days ago
Okay I have found the plugin which was creating this error
"recent posts forum index"
dis activated it. Now site works fine
Thanks.
(09-15-2019, 08:33 AM)noyle Wrote: Looks like a plugin's causing the error.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)