PDA

View Full Version : 1064 Error When Trying to View Own Profile


The Equivocate
04-14-2005, 07:49 PM
When you try and view your own profile, you get this error:

Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid =
mysql error: 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 5

mysql error number: 1064

tnguy3n
04-15-2005, 12:33 AM
When you try and view your own profile, you get this error:
Did you install any hacks that alter the code of your member.php file?
There's a null value , which gives that error, in WHERE clause.

The Equivocate
04-15-2005, 06:22 PM
So it would be an edit in member.php? I mean, I've figured out that the vBookie hack is causing it, but that hack doesn't alter member.php... what part of the vBookie hack would make the change that causes that error?