Remove Non-existent avatars
 

Hi Guys,

I recently did a huge import, vBulletin to vBulletin. Some of the predefined avatars don't seem to have copied over. Here's what's strange: ACP > Avatars > Avatar Manager shows 65 avatars, all of which show. However when I go to a users profile in the ACP and hit change avatar I get a list of 195, over half of which are broken images.

What has me confused is the avatar manager only show 65 avatars which all work, why is change avatar showing 195?

I've all ready run "Rebuild Avatar Thumbnails", in fact since the import of ran all the update counters scripts as suggested by the Impex manual.

Is there a query I can run to drop all non-existent avatars? Or since I have the files on the server and can just re-add them is there a query I can run to drop all the pre-defined avatars?

Thank you,
Dan