Notifications
Clear all

Limited Support

Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.

We appreciate your patience and understanding while our team is away. Thank you for being part of the wpForo community!

Merry Christmas and Happy Holidays! 🎄

wpForo 1.x.x [Closed] Some forum avatars missing after migration to new domain

7 Posts
2 Users
0 Reactions
2,413 Views
Homdax
Posts: 21
Topic starter
(@homdax)
Eminent Member
Joined: 6 years ago

Greetings,

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?


6 Replies
Homdax
Posts: 21
Topic starter
(@homdax)
Eminent Member
Joined: 6 years ago

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... 


Homdax
Posts: 21
Topic starter
(@homdax)
Eminent Member
Joined: 6 years ago

I see it now... the database stores absolute paths to uploaded images instead of relative paths in the table wpforo_profiles (my setup)... 


Homdax
Posts: 21
Topic starter
(@homdax)
Eminent Member
Joined: 6 years ago

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![10].gif' WHERE `wp_wpforo_profiles`.`userid` = 10

 

to

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

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


Homdax
Posts: 21
Topic starter
(@homdax)
Eminent Member
Joined: 6 years ago

Anyone could give me a clue please?


Page 1 / 2