MyBB Community Forums

I got this when trying to approved a thread using moderation options. When I hit backspace, I noticed I got the error but it still approved the thread....

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 ')' at line 1
Query:
UPDATE mybb_threads SET deleted=0, deletedposts=deletedposts-1 WHERE tid IN ()

It must be a plugin doing this as deletedposts is not a default column in the threads table; what plugins do you have??

Undo delete and softdelete

It'll be an issue with one of those then. Disable them one by one and see if you can approve it then.

Disable Soft Delete