Current time: 04-18-2014, 08:44 PM Hello There, Guest! (LoginRegister)


 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] MySQL error
06-15-2007, 07:08 PM (This post was last modified: 06-15-2007 07:09 PM by Michael S..)
Post: #1
[F] MySQL error
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 ()

Greets,
Michael
-------------
[Image: donation_drive_sig.png]
Visit this user's website Find all posts by this user
06-17-2007, 12:12 PM
Post: #2
RE: MySQL error
Nasty.. Just a simple check is needed.

Good find.

Linux Server overloading explained
Move MySQL to a second drive
Visit this user's website Find all posts by this user
06-17-2007, 01:06 PM
Post: #3
RE: [F] MySQL error
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.
Visit this user's website Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication