Notifications
Clear all

[Solved] How to sychronize avatar pictures stored in DB but hidden in front end

6 Posts
3 Users
2 Likes
1,033 Views
Posts: 93
Topic starter
(@ldj72)
Estimable Member
Joined: 2 years ago

Hi,

After a DB restore, the avatar's profile pictures are hidden on the front end

But they are still stored in DB.

How do synch?

 

Thank you

5 Replies
Robert
Posts: 10499
Admin
(@robert)
Support Team
Joined: 8 years ago

I don't see avatars in the database, I only see avatars in the file system. Please check the avatar field in the wp_wpforo_profile table of your forum database and make sure they are still stored there. Use phpMyAdmin plugin or the same tool in your hosting control panel.

Posts: 93
Topic starter
(@ldj72)
Estimable Member
Joined: 2 years ago

Hi Robert,

You are right I don't see avatars in DB wp_wpforo_profiles

But  I see all in DB backup vp_backup_wp_wpforo_profiles

How to transfer it?

Regards

 

 

Posts: 93
Topic starter
(@ldj72)
Estimable Member
Joined: 2 years ago

Up.

Thanks

BlackRaz
Posts: 406
Admin
(@blackraz)
Contributor
Joined: 7 years ago

Hi @ldj72

Please try to run this SQL query in your phpMyadmin.

UPDATE `wp_wpforo_profiles` p
	INNER JOIN `vp_backup_wp_wpforo_profiles` pb ON pb.`userid` = p.`userid`
    SET p.`avatar` = pb.`avatar`
	WHERE ( p.`avatar` IS NUll ) OR p.`avatar` = ''
Page 1 / 2