As the title says I get an error when I select 'rebuild custom avatar thumbnails' in 'Update Counters'.
This is the database error:
Can anyone else replicate this?
This is the database error:
Database error in vBulletin 3.7.0 Beta 2:
Invalid SQL:
SELECT filedata, userid, filename, dateline, avatarrevision, width, height
FROM vb_customavatar AS customavatar
INNER JOIN vb_user AS user USING (userid)
WHERE customavatar.userid >= 3
ORDER BY customavatar.userid
LIMIT 25;
MySQL Error : Column 'userid' in field list is ambiguous
Error Number : 1052
Date : Tuesday, December 18th 2007 @ 06:26:19 PM
Script : http://www.***.com/forums/admincp/mi...rebuildavatars
Referrer : http://www.***.com/forums/admincp/misc.php?do=chooser
IP Address : ***
Username : ***
Classname : ***
Invalid SQL:
SELECT filedata, userid, filename, dateline, avatarrevision, width, height
FROM vb_customavatar AS customavatar
INNER JOIN vb_user AS user USING (userid)
WHERE customavatar.userid >= 3
ORDER BY customavatar.userid
LIMIT 25;
MySQL Error : Column 'userid' in field list is ambiguous
Error Number : 1052
Date : Tuesday, December 18th 2007 @ 06:26:19 PM
Script : http://www.***.com/forums/admincp/mi...rebuildavatars
Referrer : http://www.***.com/forums/admincp/misc.php?do=chooser
IP Address : ***
Username : ***
Classname : ***
Comment