beecharmer
I hope this helps with your version
I'm running 6.4.1 B2B and I was receiving "MySQL error: 1064" but after copying product_info_tabs.tpl.php into /templates/"mytemplate"/content
I had to modify the line
$reviews_query = tep_db_query("select r.reviews_id, rd.reviews_text as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and rd.languages_id = '" . (int)$languages_id . "' order by rand(), r.reviews_id DESC limit " . PRODUCT_INFO_TAB_NUM_REVIEWS);
the problem is that the value "PRODUCT_INFO_TAB_NUM_REVIEWS" which is set in
"admin / configuration / Product Info Page / Number of Reviews to Show in Product Info Reviews Tab" was blank so the query failed
there are two ways to fix this I did both
1. Go into Admin and set the value a value 0 thru --- ( Not sure what the practical limit is )
2. Add "(int)" just before "PRODUCT_INFO_TAB_NUM_REVIEWS" in the query line shown above so it will not fail even if it is blank
remember not to use the quotes it should look like this
(int)PRODUCT_INFO_TAB_NUM_REVIEWS
Good Luck
