Db error, looking for some advice please

[bashy]

Hi

I created a new usergroup last night and created a promotion, and all users with 1 post or more went into the new usergroup, since doing this i have been getting this db error for certain members and i cannot figure out why, i have put all the members back in to the registered user group and removes the 1 i created, but still getting the error, can anyone advise please?

Database error in vBulletin 3.6.7:

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 : Thursday, June 7th 2007 @ 06:58:41 PM
Script : http://www.bashys-place.com/forums/

[Lynne]

It's right here:

WHERE user.userid =;
It needs to have a userid there. I would check the php code and see why the userid isn't being passed.

[bashy]

It's right here:

WHERE user.userid =;
It needs to have a userid there. I would check the php code and see why the userid isn't being passed.
Thanks Lynne by bottled it, I ended up restoring a backup from two days ago, I ended up losing a little bit but not too much i suppose,

Thanks anyway Lynne