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

 

 

 

 

 

 

 

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.

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.

I posted on the thread, and now the problem is solved.

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.