The path has changed. The path stored in the database has one folder too many and all I need is to adjust that path, but since it is about 50 profile rows I was looking for an SQL Update to do that for me.

I find no setting in WPForo that defines the Path to uploaded avatars, maybe there should be instead of storing the full path in the database. The images are available.

Worst case, sure I can do it manually in phpmyadmin, it is simple but a tad tedious.

There are zero errors in debug.

Have you tried to look at the Error logs?  

1) Forum Dashboard
2) Tools
3) Select Debug tab
4) Under Debug Information, select Errors & Issues

Also, I was wondering if the missing Avatars in your new domain were originally stored in your old forum using the "Specify avatar by URL", if the old avatars were stored in the old domain?  

Since on the Forum, we have three ways to display Avatars

1. Default Avatar
2. Specify avatar by URL
3. Upload an avatar

If the avatars belong to the Admins, might be simpler to just reupload.    

I thought about the above because you mentioned that you were able to migrate the other avatars.  

Good luck and God bless you! :-) 

UPDATE `wp_wpforo_profiles` SET `avatar` = 'https://www.thewebsiteaddress.io/wp-content/irrelevantfolder/uploads/gc-avatars/y!.gif' WHERE `wp_wpforo_profiles`.`userid` = 10

to

UPDATE `wp_wpforo_profiles` SET `avatar` = 'https://www.thewebsiteaddress.io/wp-content/uploads/gc-avatars/y!.gif' WHERE `wp_wpforo_profiles`.`userid` = 10

for all users...via phpmyadmin, can I please get som help with that?

I have migrated my WP site and WPForo to a new domain and everything seems ok but for a few avatars that somehow went missing. Had it been all it would be a general thing, but this is a few admin usres avatars, among them my own, that are turning up blank. 

Any clue as to what may be fixed?