Notifications

Clear all

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

Page 1 / 2 Next

How-to and Troubleshooting

Last Post by ldj72 3 years ago

6 Posts

3 Users

2 Reactions

1,601 Views

RSS

Posts: 95

ldj72

Topic starter

Oct 19, 2022 3:35 pm

(@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

Topic Tags

profile avatar db error

5 Replies

Posts: 10606

Robert

Admin

Oct 19, 2022 8:06 pm

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

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Posts: 95

ldj72

Topic starter

Oct 20, 2022 9:52 am

(@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

Posts: 95

ldj72

Topic starter

Oct 22, 2022 8:24 pm

(@ldj72)

Estimable Member

Joined: 3 years ago

Up.

Thanks

Posts: 392

BlackRaz

Admin

Oct 24, 2022 11:08 am

(@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` = ''

In case you want to say thank you !) We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.