How to sychronize avatar pictures stored in DB but hidden in front end - How-to and Troubleshooting - wpForo 2.0

RE: How to sychronize avatar pictures stored in DB but hidden in front end

ldj72 — Mon, 24 Oct 2022 12:54:18 +0000

It works perfectly. Thanks @blackraz

RE: How to sychronize avatar pictures stored in DB but hidden in front end

BlackRaz — Mon, 24 Oct 2022 11:08:12 +0000

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

RE: How to sychronize avatar pictures stored in DB but hidden in front end

ldj72 — Sat, 22 Oct 2022 20:24:36 +0000

Up.

Thanks

RE: How to sychronize avatar pictures stored in DB but hidden in front end

ldj72 — Thu, 20 Oct 2022 09:52:24 +0000

Hi Robert,

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

https://snipboard.io/ZoPawL.jpg

But I see all in DB backup vp_backup_wp_wpforo_profiles

https://snipboard.io/4qvwK2.jpg

How to transfer it?

Regards

RE: How to sychronize avatar pictures stored in DB but hidden in front end

Robert — Wed, 19 Oct 2022 20:06:08 +0000

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.

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

ldj72 — Wed, 19 Oct 2022 15:35:13 +0000

Hi,

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

https://snipboard.io/lXLIsG.jpg

But they are still stored in DB.

https://snipboard.io/whP03e.jpg

How do synch?

Thank you