Reviews - Updated [Support Thread]

[shags38]

Mike, the plugin affects only the storefront "offering" and acceptance of reviews by guests; it doesn't have any admin-level component. That address-change can be performed in the admin, through a kind of convoluted process, though.

Log into the admin, go to Catalog->Reviews and view the review whose date should be updated. You'll see a link similar to the following:

http://localhost/site/admin/reviews.php?page=1&rID=16&action=edit

That rID value identifies the reviews_id associated with that review.

Armed with that information, go to Tools->Install SQL Patches and enter the following to change that review's date-added to a specific date:

UPDATE reviews SET date_added = '2019-09-18 00:00:00' WHERE reviews_id = 16 LIMIT 1;

Alternatively, you could set the date_added to today's date:

UPDATE reviews SET date_added = now() WHERE reviews_id = 16 LIMIT 1;

Thank you very much Cindy .... again you have come to the fore or as we would say in Australia "your blood is worth bottling" :)

Very much appreciated.

cheers, Mike