So I upgraded to WP 5.6 recently and punched through some WPForo updates, including som paid plugins, and suddenly I see some avatars are gone - again - .
I had this issue before, it somehow fixed itself, but now it happened again, and it is not all avatars, only some, and I don't see any connection, all belong to user accounts. They are not Gravatars, they are uploaded image files whose links somehow broke.
I tried all or most of the cleanup tools and there are no issues with the database, checked several times.
The broken links point to /wp-content/uploads/gc-avatars/ and I have verified that the image is there... still it gives me a 404 when trying to open the link from the user profile.
The reasone it gives me the 404 is because somewhere there are still entries related to an old site path that was /_w0rdpre33/wp-content/uploads/gc-avatars/ and that is no longer relevant. Where can that path still exist...?
Ok, found it... in `wp_wpforo_profiles` still has te wrong path...
I need an SQL query that would update the field with the new path ...