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
|
Posted: Sat Apr 28, 2007 11:32 am Post subject: Deleted Account General Error |
|
|
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 |
|
|
Zaleria
Joined: 08 May 2005
Post Count: 12483
Location: Ceresfjellet
1296207 Potch
13650 Soldiers
7777 Nation Points
|
Posted: Sat Apr 28, 2007 11:42 am Post subject: |
|
|
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 |
|
|
Ujitsuna
Red Shoes Dance
Joined: 24 May 2006
Post Count: 4823
Location: Pale Plains
936547 Potch
12000 Soldiers
675 Nation Points
|
Posted: Sat Apr 28, 2007 11:45 am Post subject: |
|
|
Still, it should give a notification like "the profile requested does not exist" instead of a database error. |
|
Back to top |
|
|
fuji
Joined: 31 Jul 2004
Post Count: 7067
Location: North Sparrow Pass
9643133 Potch
16500 Soldiers
100 Nation Points
|
Posted: Sat Apr 28, 2007 11:50 am Post subject: |
|
|
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 |
|
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat Apr 28, 2007 2:04 pm Post subject: |
|
|
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 |
|
|
fuji
Joined: 31 Jul 2004
Post Count: 7067
Location: North Sparrow Pass
9643133 Potch
16500 Soldiers
100 Nation Points
|
|
Back to top |
|
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat Apr 28, 2007 2:16 pm Post subject: |
|
|
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 |
|
|
Ujitsuna
Red Shoes Dance
Joined: 24 May 2006
Post Count: 4823
Location: Pale Plains
936547 Potch
12000 Soldiers
675 Nation Points
|
Posted: Sat Apr 28, 2007 2:20 pm Post subject: |
|
|
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 |
|
|
Vextor
Joined: 09 Mar 2004
Post Count: 12086
Location: Hell
11331071 Potch
23689 Soldiers
160 Nation Points
|
Posted: Sat Apr 28, 2007 2:38 pm Post subject: |
|
|
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 |
|
|
|
|