[YLP1]

Originally Posted by YLP1

SimonHodgkis, I have an error very similar to yours which I can't fix. I wonder if these are related.

Database error in vBulletin 3.0.7:
 
Invalid SQL: 
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM vb3_user AS user
LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb3_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

Any advise on fixing this is greatly appreciated it's been driving me nuts for over a week now.

Hi RJordon.....I got the other error fixed but this one is still hanging around and is intermittent.

I have tried all of the code mods over again and still can't get rid of this.

Any ideas?