MyBB Community Forums
[F] MySQL error - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: Archived Bug Reports (https://community.mybb.com/forum-74.html)
+------ Forum: MyBB 1.2.7 (https://community.mybb.com/forum-55.html)
+------ Thread: [F] MySQL error (/thread-20082.html)



[F] MySQL error - Michael S. - 06-15-2007

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 ()



RE: MySQL error - Asad_Niazi - 06-17-2007

Nasty.. Just a simple check is needed.

Good find.


RE: [F] MySQL error - Chris Boulton - 06-17-2007

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.