2012-09-02, 03:46 PM
Hey,
I have made a custom junk moderation tool that just moves the thread, adds a prefix and a reply to it.
When I go onto a users profile and do view all threads and select all threads (not just on one page, but all of their threads) then click junk it gives me this error:
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 closed NOT LIKE 'moved|%'' at line 1
Query:
SELECT fid, subject, tid, firstpost, closed FROM mybb_threads WHERE tid IN () AND closed NOT LIKE 'moved|%'
Any idea how to fix this?
URL - http://theprofiters.com
Thanks,
I have made a custom junk moderation tool that just moves the thread, adds a prefix and a reply to it.
When I go onto a users profile and do view all threads and select all threads (not just on one page, but all of their threads) then click junk it gives me this error:
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 closed NOT LIKE 'moved|%'' at line 1
Query:
SELECT fid, subject, tid, firstpost, closed FROM mybb_threads WHERE tid IN () AND closed NOT LIKE 'moved|%'
Any idea how to fix this?
URL - http://theprofiters.com
Thanks,