Notifications
Clear all

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

7 Posts
2 Users
0 Reactions
1,185 Views
Homdax
Posts: 21
Topic starter
(@homdax)
Eminent Member
Joined: 5 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: 5 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: 5 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: 5 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: 5 years ago

Anyone could give me a clue please?

Page 1 / 2