View previous topic :: View next topic |
Author |
Message |
angrypuppy Retired Number
Joined: 13 Apr 2001 Posts: 32752
|
Posted: Fri Aug 02, 2013 5:54 am Post subject: DB Corruption |
|
|
No, DancingBarry isn't taking bribes.
The database seems to have been corrupted on page 2 of the "Houston Rockets player Terrence Jones arrested" within the General BB forum. The thread isn't important, but perhaps whether this is a one time event or a potential recurring problem should be investigated. |
|
Back to top |
|
|
K2 Franchise Player
Joined: 25 Dec 2011 Posts: 23529
|
Posted: Sat Aug 03, 2013 8:56 pm Post subject: |
|
|
Looks like it's still on page 2. Hmm, haven't seen this type of error before, wonder if it might have been triggered by a user with the 3 asterisks in the username?
"***" only joined recently and when I tried to lookup his/her post history it didn't work. Thought the wildcard might have had an effect and I'm surprised someone was able to register it as a username in the first place.
Code: | 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 p.post' at line 3
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, 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, u.user_wpublog_id 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 : 435
File : viewtopic.php |
|
|
Back to top |
|
|
Omar Little Moderator
Joined: 02 May 2005 Posts: 90305 Location: Formerly Known As 24
|
Posted: Sat Aug 03, 2013 9:27 pm Post subject: |
|
|
Good call. I think that might be the problem _________________ “We must always take sides. Neutrality helps the oppressor, never the victim. Silence encourages the tormentor, never the tormented.” ― Elie Wiesel |
|
Back to top |
|
|
K2 Franchise Player
Joined: 25 Dec 2011 Posts: 23529
|
Posted: Sat Aug 03, 2013 9:48 pm Post subject: |
|
|
Thanks for fixing the thread, will update if a similar error is seen elsewhere. |
|
Back to top |
|
|
GoldenThroat Moderator
Joined: 25 Jul 2005 Posts: 37474
|
Posted: Sun Aug 04, 2013 1:14 pm Post subject: |
|
|
Thanks for the heads up, AP. |
|
Back to top |
|
|
DancingBarry Editor-in-Chief
Joined: 07 Sep 2001 Posts: 40198 Location: O.C.
|
Posted: Tue Aug 06, 2013 3:26 pm Post subject: |
|
|
Laughing at the thread title. |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|