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]

Originally Posted by 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.

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