I just noticed that none of my reviews are showing on either one of my two websites since updating to v7.8.0

Every product shows there are reviews but when you click on the Reviews Tab nothing is there.


Please help.

Patrick

ECT v7.8.0
PHP 8.3.10

After looking back on prior updates the problem lies from the flowing change in the incproddetail.php file.

Old Version: $sSQL="SELECT rtID,rtRating,rtPosterName,rtHeader,rtDate,rtComments FROM ratings WHERE rtApproved<>0 AND rtProdID='" . escape_string($prodid) . "'";


New Version: $sSQL="SELECT rtID,rtRating,rtPosterName,rtHeader,rtDate,rtComments FROM ratings WHERE " . $GLOBALS['reviewsearchsql'];


**UPDATE** I rolled back the incproddetail.php file to the older version listed above and the reviews show correctly.

Hi Patrick
Do you mind if I update your site to the new incproddetail.php and then I can fix the problem if it's still causing an issue. If that's ok could you let me know (by email if you like) which of your sites has the problem and an example URL of a product with reviews (to save me hunting)?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Email sent

Thanks for looking

Patrick

Hi Patrick
That's fixed now.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Perfect...

Thank you

Patrick