DB Corruption

 
Post new topic    LakersGround.net Forum Index -> User Feedback / Report a Bug Reply to topic
View previous topic :: View next topic  
Author Message
angrypuppy
Retired Number
Retired Number


Joined: 13 Apr 2001
Posts: 30387

PostPosted: 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
View user's profile Send private message Reply with quote
K2
Franchise Player
Franchise Player


Joined: 25 Dec 2011
Posts: 22338

PostPosted: 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
View user's profile Send private message Reply with quote
Omar Little
Moderator
Moderator


Joined: 02 May 2005
Posts: 80742
Location: Formerly Known As 24

PostPosted: Sat Aug 03, 2013 9:27 pm    Post subject:

Good call. I think that might be the problem
_________________
Tolerance is an agreement to live in peace, not an agreement to be peaceful no matter the conduct of others. A peace treaty is not a suicide pact.
Back to top
View user's profile Send private message Reply with quote
K2
Franchise Player
Franchise Player


Joined: 25 Dec 2011
Posts: 22338

PostPosted: 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
View user's profile Send private message Reply with quote
GoldenThroat
Moderator
Moderator


Joined: 25 Jul 2005
Posts: 36425

PostPosted: Sun Aug 04, 2013 1:14 pm    Post subject:

Thanks for the heads up, AP.
Back to top
View user's profile Send private message Reply with quote
DancingBarry
Editor-in-Chief
Editor-in-Chief


Joined: 07 Sep 2001
Posts: 35701
Location: O.C.

PostPosted: Tue Aug 06, 2013 3:26 pm    Post subject:

Laughing at the thread title.
Back to top
View user's profile Send private message Reply with quote
Display posts from previous:   
Post new topic    LakersGround.net Forum Index -> User Feedback / Report a Bug All times are GMT - 8 Hours
Page 1 of 1
Jump to:  

 
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






Graphics by uberzev
© 1995-2010 LakersGround.net. All Rights Reserved. Privacy Policy. Terms of Use.
LakersGround is an unofficial news source serving the fan community since 1995.
We are in no way associated with the Los Angeles Lakers or the National Basketball Association.


Powered by phpBB