Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Hosting Developers Payment Shipping Accounting Templates Marketing Books

Latest News: (loading..)

Issue Information

Issue ID
#000162
Severity
2 - Fair
Status
Duplicate
Version
2.3.1
Fixed in
2.3.3

Issue Confirmations

Yes (0)No (0)

0

error in product page for reviews's button

Posted by foxp2 on 03 December 2010 - 01:35 AM

replace line 189 :

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and reviews_status = 1");

with :

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and reviews_status = 1");