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?
seems that some of the avatar links are looking in an old upload folder... hmmm... the root path of the site was changed... could be something in the settings...maybe...
I see it now... the database stores absolute paths to uploaded images instead of relative paths in the table wpforo_profiles (my setup)...
So i need an sql query that would update
UPDATE `wp_wpforo_profiles` SET `avatar` = 'https://www.thewebsiteaddress.io/wp-content/irrelevantfolder/uploads/gc-avatars/y!.gif' WHERE `wp_wpforo_profiles`.`userid` = 10
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?
Anyone could give me a clue please?