MyBB Community Forums

Hi

i set up a delayed moderation task earlier, when it didn't work i tried to run the task from task manager, i ran into this error

Quote: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 ') AND (canview=0 OR canviewthreads=0)' at line 1
Query:
SELECT gid FROM njyf6_forumpermissions WHERE fid IN () AND (canview=0 OR canviewthreads=0)

any help would be much appreciated, i tried searching but with no luck

That's weird... did you choose the 'Remove Subscriptions' option when you setup the delayed moderation??

hey, thanks for the reply

nope

What plugins have you installed??

Did you choose to move the thread?? There's not many ways the delayed moderation could run this code.

yeah I know this thread is super old, but the solution is here:

http://dev.mybb.com/issues/1497

wow thanks