MyBB Community Forums

Full Version: [F] MySQL error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
If you use a custom post/thread moderation tool without selecting any posts/threads you get a mysql error:
Quote:MySQLi 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_posts SET tid='6172', fid='50', replyto='0' WHERE pid IN ()
Quote:MySQLi 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: SELECT fid, visible, replies, unapprovedposts FROM mybb_threads WHERE tid IN ()
Nasty.. Just a simple check is needed.

Good find.
This bug has been fixed in the latest code.

Please note the latest code is not live on the site or for download. An update will be released which contains this fix.