New Update Wiped Out Assigned Posts

Site Reviews v7.0.0 and v7.0.1 had a bug in the migration system (when a “Hard Reset” migration was run) that affected the assigned posts table. This was fixed in v7.0.2, however, there was a 2-hour window where the version with the bug was still available in the WordPress update system and it looks like you were affected by that bug.

Scenario A) Fortunately there is a way to fix your post assignments, provided that your reviews were assigned to your pages when they were created (either through the Review Form on the frontend, on using the Import Reviews tool from a CSV file).

Here is how to fix it:

1. Make a backup of your database using?Updraft Plus?(just in case).
2. Install the?Code Snippets?plugin.
3. Create a new snippet and paste in the following code: https://pastebin.com/mgRJKD2d
4. Activate the snippet and refresh the page.
5. Deactivate the snippet.

It may take a little time to refresh the page if you have thousands of reviews.

Scenario B) However, if your reviews were not automatically assigned to your pages when they were created (i.e. you manually assigned them after that were created or imported), then the only way to fix it is to manually reassign them again.

Please let me know how it goes.

What about rolling back our site to a version prior to the May 3rd update and then re-install the plugin now that the bug has been fixed?

Yes, that should work also. However, after rolling back your site, I recommend deactivating Site Reviews and then activating it again. This will ensure that the indexes on the custom database tables are restored correctly. Sometimes rollback plugins don’t account for foreign contraints in database tables.

After that, update Site Reviews as usual.

Rolling back to 5/2 fixed the issue. I updated to the most recent version and everything is working fine. I didn’t need to reactivate the plugin.