Avatar issue

[Vanrau]

I upgraded from 3.4.9 to 4.1.19.2 and when I'm looking at avatars in the ACP, most of the users avatar images are broken. Some users have their avatars that uploaded to the site. I'm not exactly sure if these users had gravatars before the upgrade but it seems like every single person I see with a broken avatar image is set to gravatar.

I did a database backup before I upgraded. Where can I check if a user had a gravatar before the upgrade?

[opentype]

To what URLs are the broken images pointing to? 

[Vanrau]

Here is an example when looking at the source of the acp members page for someone with a broken avatar image.

http://mydomain.com/index.php?app=core&module=system&controller=redirect&url=https://secure.gravatar.com/avatar/da3d7f470848669bc56aa9ff3a630461?d=http://www.mydomain.com/uploads/set_resources_1/84c1e40ea0e759e3f1505eb1788ddf3c_default_photo.png&key=c02df6d788f3d6486c92955c95d1929f4c00b23201b829a3b123b297038a4405&resource=1

 

[opentype]

Is your site public already? If it isn’t, then this call will fail but the problem will go away once you remove the access protection. 

I can’t check the individual call since mydomain.com is probably not your actual domain. 

[Vanrau]

Yes the site is public. I changed the domain of course just in case something sensitive was in the url.

[Vanrau]

I'm thinking many of these users never actually had a gravatar for an avatar. Something in the upgrade went in and set them as using a gravatar and their email addresses of course aren't on record for having a gravatar so I get a broken avatar image on the admin panel. I can just change them back to having no avatar one by one and that will fix it but there are hundreds of users like this.

Is there a quicker way I can just select all the users and change them all to not use a avatar? I couldn't find where it stores the avatar info in the database or I would have just run a query.

[opentype]

That doesn’t sound right. Gravatar isn’t a per-user choice or setting. If there is no image uploaded, the system contacts the Gravatar server to check if there is an image for the email address and if not, it falls back to the theme default image. And that would be the first check for broken images: to see what the check returns and whether the default image exists. But since you didn’t post the actual URL, we can’t do that. If you can’t provide more details, just open a support ticket and let IPS staff check it out on your site. Otherwise it’s just guesswork here. 

[Vanrau]

On the forums themselves, all those users have the theme default image for not having a avatar, however in the admin panel, they have the broken image instead of the theme default image.

[opentype]

Yes, I get that. But since I don’t have access to your ACP, I can’t check out the calls and why they fail. Open a ticket …

[Vanrau]

Thanks for all the help opentype. I fixed this myself by running a sql query to look for blank values of pp_main_photo and set it to none which is what the site puts in when you change someone's avatar to none.