Avatar images broken

[mrcrx]

I opened a ticket with vbulletin.com but they told me to come here.

Last month the folder that stored the avatar images was lost. I understand the images are gone but is there anyway I can globally reset all the broken image avatars back to the default image? I have 86,000 members. Asking everyone to do it will take a very long time and there is no way I can go into each and every profile to repair this. Anyone have any suggestions?

[kh99]

I think you would need to write a script to remove the records from the customavatar table where the file doesn't exist any more.

(Sorry, I originally posted that you should truncate the table, but then I remembered that you said you lost the files a month ago, so if you were to truncate the table you'd lose any avatars that were uploaded since then).

[mrcrx]

Know anyone that can write a script like that?

[kh99]

OK, first, use at your own risk! (ETA ...and if you decide you don't want to risk it, I understand). You should backup your database first, or at least the customavatar table.

Upload the attached file to your forum directory, then point your browser at it (i.e. www.mydomain.com/forum/fixavatars.php). You must be logged in as an admin. I'm not sure how long it will take, but it won't look like it's doing anything until it's done (it'll look like it's taking a long time to load the page), so be patient.

If it works, when you run it a second time it should immediately tell you that it removed 0 rows.

[mrcrx]

Thank you! I will try this tomorrow morning when I have less traffic.

[kh99]

You know, I read your post again and you say you want to set them "back to the default image". I'm not sure if this will do that - the users may end up with no avatar (that's what happened when I tested it, but that's what my test site has by default). What do you get as the default image (and did you have to configure that somehow?).

[Lynne]

There is no default avatar for users. Default is to have no avatar at all. So, Kevin's script may set the site back to default (no avatar), not back to some default avatar.

[mrcrx]

Ok, I tried running the script.

The first time I ran it the results came back in 30 secs.

It said Removed 15252 rows from customavatar

The second time I ran it it came back with

Removed 0 rows from customavatar

I think it worked. Thank you!

Can this be changed to fix my broken profile and signature pictures as well?

What I ment by default avatar was the image that shows up if you have no avatar at all. In my case it is a Silhouette of a person.

[kh99]

Try going to Maintenance in the admincp, and under General Update Tools (or Update Cunters if you have an older version) run Rebuild Custom Avatar Thumbnails.

[mrcrx]

Ok, I did that. Not sure what that did. However I am seeing broken images for the thumbnail of the avatar in my recent post section. Is this another spot that needs to be repaired?

--------------- Added [DATE]1335090127[/DATE] at [TIME]1335090127[/TIME] ---------------

Something odd is going on. Depending on the page I am viewing will now depend on if the link is broken.

2 examples