Notifications
Clear all
Oct 19, 2022 7:35 pm
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
wpForo Version
2.09
WordPress Version
6.2
5 Replies
Oct 20, 2022 12:06 am
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.
Oct 20, 2022 1:52 pm
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
Oct 23, 2022 12:24 am
Up.
Thanks
Oct 24, 2022 3:08 pm
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
Next