Suikoden Utopian and Informational Knowledge Oblique Xperience

Suikox Home | The Speculation Shelter | Tablet of Stars | Suikoden Timeline | Suikoden Geography |Legacies


  [ View Profile | Edit Profile | Nation System | Members | Groups | Search | Register | Check PMs | Log in | FAQ ]

Deleted Account General Error

 
Post new topic   Reply to topic     Forum Index -> Site Technical issues Forum
View previous topic :: View next topic  
Author Message
Ujitsuna

Red Shoes Dance


Joined: 24 May 2006
Post Count: 4823
Location: Pale Plains
936547 Potch
12000 Soldiers
675 Nation Points

PostPosted: Sat Apr 28, 2007 11:32 am    Post subject: Deleted Account General Error Reply with quote Add User to Ignore List

When trying to access a deleted account through a link, I get the following error:

Quote:
Could not retreive profile views

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 '' at line 3

SELECT user_profile_views FROM phpbb_users WHERE user_id =

Line : 93
File : usercp_viewprofile.php


Not really a big deal but just informing you.
Back to top
View user's profile Send private message MSN Messenger
Zaleria




Joined: 08 May 2005
Post Count: 12483
Location: Ceresfjellet
1296207 Potch
13650 Soldiers
7777 Nation Points

PostPosted: Sat Apr 28, 2007 11:42 am    Post subject: Reply with quote Add User to Ignore List

Well... it is a deleted account, so obviously no profile account can be viewed, right?
_________________

Tonby, while I'm not in Zexen wrote:

I just noticed that if you turn Zexen Activity Levels into an acronym, it makes ZAL. Oh the irony! =P
Back to top
View user's profile Send private message MSN Messenger
Ujitsuna

Red Shoes Dance


Joined: 24 May 2006
Post Count: 4823
Location: Pale Plains
936547 Potch
12000 Soldiers
675 Nation Points

PostPosted: Sat Apr 28, 2007 11:45 am    Post subject: Reply with quote Add User to Ignore List

Still, it should give a notification like "the profile requested does not exist" instead of a database error.
Back to top
View user's profile Send private message MSN Messenger
fuji




Joined: 31 Jul 2004
Post Count: 7067
Location: North Sparrow Pass
9643133 Potch
16500 Soldiers
100 Nation Points

PostPosted: Sat Apr 28, 2007 11:50 am    Post subject: Reply with quote Add User to Ignore List

The reason that error pops up is because of the ability Vextor gave us in typing something something like this. Just consider that cryptic error the system telling you the person does not exist. Nothing too serious and I'm sure Vex has other more pressing matters to attend to.
_________________
______ "We're still flying"

___ "That's not much"

"It's enough"
Back to top
View user's profile Send private message
Vextor




Joined: 09 Mar 2004
Post Count: 12081
Location: Hell
11324811 Potch
23689 Soldiers
160 Nation Points

PostPosted: Sat Apr 28, 2007 2:04 pm    Post subject: Reply with quote Add User to Ignore List

Give me a specific username / Id where this problem occurs.

Oh yes and Blasphemy, this feature is default to PHPbb. It's not some hack I installed.
Back to top
View user's profile Send private message
fuji




Joined: 31 Jul 2004
Post Count: 7067
Location: North Sparrow Pass
9643133 Potch
16500 Soldiers
100 Nation Points

PostPosted: Sat Apr 28, 2007 2:08 pm    Post subject: Reply with quote Add User to Ignore List

Any non-valid username or user id. It never used to do this about 9 months ago, but in the past ~6 or so it has.

http://www.suikox.com/forum/profile.php?mode=viewprofile&u=363
http://www.suikox.com/forum/profile.php?mode=viewprofile&u=asdfasdfds
_________________
______ "We're still flying"

___ "That's not much"

"It's enough"
Back to top
View user's profile Send private message
Vextor




Joined: 09 Mar 2004
Post Count: 12081
Location: Hell
11324811 Potch
23689 Soldiers
160 Nation Points

PostPosted: Sat Apr 28, 2007 2:16 pm    Post subject: Reply with quote Add User to Ignore List

Well, in that case it's caused by the profile view feature, which means the "fame" thing is the culprit. The script doesn't seem to consider whether an account is deleted or not. Of course, normally nobody would think that people would be scouring through the userlist based on userID, so that's understandable.
Back to top
View user's profile Send private message
Ujitsuna

Red Shoes Dance


Joined: 24 May 2006
Post Count: 4823
Location: Pale Plains
936547 Potch
12000 Soldiers
675 Nation Points

PostPosted: Sat Apr 28, 2007 2:20 pm    Post subject: Reply with quote Add User to Ignore List

Vextor wrote:
Of course, normally nobody would think that people would be scouring through the userlist based on userID, so that's understandable.


How exactly do you do that? I came across the error by clicking on a reported bot's profile link (posted by another member).
Back to top
View user's profile Send private message MSN Messenger
Vextor




Joined: 09 Mar 2004
Post Count: 12081
Location: Hell
11324811 Potch
23689 Soldiers
160 Nation Points

PostPosted: Sat Apr 28, 2007 2:38 pm    Post subject: Reply with quote Add User to Ignore List

I won't tell you. It's not particularly good for the site, anyways.

Edit: Okay, the issue is "fixed."

Well, there really was no problem to begin with... but oh well. Always enjoy tweaking small cosmetic scripting issues on a nice Saturday morning when I can be outside doing stuff that's probably better for me.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Site Technical issues Forum All times are GMT - 4 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
suikox.com by: Vextor


Powered by phpBB © 2001, 2005 phpBB Group
  Username:    Password:      Remember me