Reviews - Updated [Support Thread]

[lat9]

Hello Cindy - my apologies - please IGNORE my posts above - I figured out the issue was to do with my template - jumped the gun too early. This plugin works great.

There is one question though :) - can the date of a review be changed after submission - date cannot be edited in admin/catalog/reviews (only review text which is strange, content can be edited but nothing else).

Because I didn't have the reviews by guests set up properly for a long, long time I have missed out on some who would have otherwise left reviews - they actually sent emails saying how happy they were with the product(s) - I want to copy the content of their positive remarks and submit a review with it but I really want to be able to change the dates otherwise I could have a number of reviews all with the same date which may look suspicious to Mr Google Bot - any ideas?

cheers Mike

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;

[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

[simon1066]

ZC v1.5.6
OPC v2.3.3
Reviews Updated v1.2.0
plus other mods

This mod is perhaps showing its age but there's a slight conflict between it and OPC's guest checkout. It's not major and a rare occurrence:

If a customer starts to checkout as a guest and does not complete, then goes to write a review (as a guest) they are taken to the homepage with the banner 'Access to that page requires a registered account, You can ...'

I think this is because the OPC session's "order_placed_by_guest" element is not cleared until post checkout. Beyond that (to quote Manuel) 'I know nothing' :)

[lat9]

ZC v1.5.6
OPC v2.3.3
Reviews Updated v1.2.0
plus other mods

This mod is perhaps showing its age but there's a slight conflict between it and OPC's guest checkout. It's not major and a rare occurrence:

If a customer starts to checkout as a guest and does not complete, then goes to write a review (as a guest) they are taken to the homepage with the banner 'Access to that page requires a registered account, You can ...'

I think this is because the OPC session's "order_placed_by_guest" element is not cleared until post checkout. Beyond that (to quote Manuel) 'I know nothing' :)

Yes, this plugin needs to be dusted off a bit; thanks for the reminder!

[rlexyd]

Just wondering if this will work on 1.5.7c on PHP 7.4.21?
Thank you once again :)

[lat9]

Just wondering if this will work on 1.5.7c on PHP 7.4.21?
Thank you once again :)

See the post above yours ... it's on my list, but paying clients come first.

[rlexyd]

Thanks Cindy, I appreciate where you are coming from :)
Until you get a chance to update it, for the time being I've commented out the login code in (/includes/modules/pages/product_reviews_write/header.php) as suggest in the link below incase anyone else is wondering.

https://www.zen-cart.com/showthread....26#post1284826