[TruthElixirX]

I seem to be encountering a strange problem. If a user goes to their User CP and sees the private message bit (if the PM is brand new and unread), the avatars don't show up. I'm not sure why.

I tried duplicating the plug-in that is used in private_messagelist_messagebit and put it in usercp_pmbit.

When I do this, and refresh the page that has a private message on it says

Database error in vBulletin 3.6.4:

Invalid SQL:

		SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
			customavatar.width, customavatar.height
		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 6
Error Number : 1064
Date         : Sunday, February 4th 2007 @ 10:45:48 AM
Script       : http://********/forums/usercp.php
Referrer     : http://********/forums/private.php?do=newpm
IP Address   : 71.30.147.158
Username     : AdminTest
Classname    : vb_database

Here is a screenshot of what I mean (ignore the header at the top, it was already fixed.)