Notifications
Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

 

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

6 Posts
3 Users
2 Reactions
1,659 Views
ldj72
Posts: 95
Topic starter
(@ldj72)
Estimable Member
Joined: 3 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: 10616
Admin
(@robert)
Support Team
Joined: 9 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.

ldj72
Posts: 95
Topic starter
(@ldj72)
Estimable Member
Joined: 3 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

 

 

ldj72
Posts: 95
Topic starter
(@ldj72)
Estimable Member
Joined: 3 years ago

Up.

Thanks

BlackRaz
Posts: 396
Admin
(@blackraz)
Contributor
Joined: 9 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