raylifes Posted July 24, 2007 Share Posted July 24, 2007 In a certain thread on General discussion I get a nice sql error, but I have no idea if I should pm an admin, or post it on a certain board, so I decided to post it here. I get the error when I go to this page: http://forum.tip.it/viewtopic.php?t=681 ... c&start=20 The error is: General Error Could not obtain post/user information. DEBUG MODE 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 pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY' at line 3 SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_clan, u.user_rsn, u.user_website, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.post_id in () AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC Line : 364 File : viewtopic.php Link to comment Share on other sites More sharing options...
mchainmail Posted July 24, 2007 Share Posted July 24, 2007 That's a pic of the error I just came into the forum to report it. It's in the "Increase of Drop Party Scams" thread. Link to comment Share on other sites More sharing options...
raylifes Posted July 24, 2007 Author Share Posted July 24, 2007 Hmmm, the bug seems to have resolved itself... I'll leave this here as a reference for a mod, incase he/she sees a need. If this topic is no longer needed, feel free to delete it. Link to comment Share on other sites More sharing options...
mchainmail Posted July 24, 2007 Share Posted July 24, 2007 I posted on the thread, and now the problem is solved. Link to comment Share on other sites More sharing options...
McGuff1 Posted July 24, 2007 Share Posted July 24, 2007 These SQL Errors can happen once in a while when forum traffic is high or a background process is running. They usually resolve themselves fairly quickly. Locking this topic for now. Link to comment Share on other sites More sharing options...
Recommended Posts