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: 32730

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: 23529

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: 90299
Location: Formerly Known As 24

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


Joined: 25 Dec 2011
Posts: 23529

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: 37474

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: 40188
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-2018 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