coolcl Posted November 25, 2004 Posted November 25, 2004 This is my second post about this problem. I need help to solve this issue. I don't know what happened but my product_reviews_info.php page is not showing the content of the reviewed items anymore, (no texte, no image). click on this link Reviews to see what it does. If anyone could send me a lead on where to look, it would be greatly appreciated. Many thanks to all the genius out there for this great software. ccl >_<
gscreations Posted November 25, 2004 Posted November 25, 2004 looks to be a problem within the reviews box, its trying to show the stars img twice, post your includes/boxes/reviews.php code or pm it to me
coolcl Posted November 25, 2004 Author Posted November 25, 2004 looks to be a problem within the reviews box, its trying to show the stars img twice, post your includes/boxes/reviews.php code or pm it to me <{POST_SNAPBACK}> Ihave reload the bosx twice with a fresh file, and non joy! Here's the code; /* $Id: reviews.php,v 1.37 2003/06/09 22:20:28 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ ?> <!-- reviews //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_REVIEWS); new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_REVIEWS)); $random_select = "select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_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 = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"; if (isset($HTTP_GET_VARS['products_id'])) { $random_select .= " and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"; } $random_select .= " order by r.reviews_id desc limit " . MAX_RANDOM_SELECT_REVIEWS; $random_product = tep_random_select($random_select); $info_box_contents = array(); if ($random_product) { // display random review box $review_query = tep_db_query("select substring(reviews_text, 1, 60) as reviews_text from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . (int)$random_product['reviews_id'] . "' and languages_id = '" . (int)$languages_id . "'"); $review = tep_db_fetch_array($review_query); $review = tep_break_string(tep_output_string_protected($review['reviews_text']), 15, '-<br>'); $info_box_contents[] = array('text' => '<div align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . $review . ' ..</a><br><div align="center">' . tep_image(DIR_WS_IMAGES . 'stars_' . $random_product['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $random_product['reviews_rating'])) . '</div>'); } elseif (isset($HTTP_GET_VARS['products_id'])) { // display 'write a review' box $info_box_contents[] = array('text' => '<table border="0" cellspacing="0" cellpadding="2"><tr><td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'box_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW) . '</a></td><td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . BOX_REVIEWS_WRITE_REVIEW .'</a></td></tr></table>'); } else { // display 'no reviews' box $info_box_contents[] = array('text' => BOX_REVIEWS_NO_REVIEWS); } new infoBox($info_box_contents); ?> </td> </tr> <!-- reviews_eof //--> I have a clone version of this site for my US customers and the reviews works normally. I thank you very much for your help. ccl
coolcl Posted November 25, 2004 Author Posted November 25, 2004 Ihave reload the bosx twice with a fresh file, and non joy! Here's the code; /* $Id: reviews.php,v 1.37 2003/06/09 22:20:28 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright ? 2003 osCommerce Released under the GNU General Public License */ ?> <!-- reviews //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_REVIEWS); new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_REVIEWS)); $random_select = "select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_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 = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"; if (isset($HTTP_GET_VARS['products_id'])) { $random_select .= " and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"; } $random_select .= " order by r.reviews_id desc limit " . MAX_RANDOM_SELECT_REVIEWS; $random_product = tep_random_select($random_select); $info_box_contents = array(); if ($random_product) { // display random review box $review_query = tep_db_query("select substring(reviews_text, 1, 60) as reviews_text from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . (int)$random_product['reviews_id'] . "' and languages_id = '" . (int)$languages_id . "'"); $review = tep_db_fetch_array($review_query); $review = tep_break_string(tep_output_string_protected($review['reviews_text']), 15, '-<br>'); $info_box_contents[] = array('text' => '<div align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . $review . ' ..</a><br><div align="center">' . tep_image(DIR_WS_IMAGES . 'stars_' . $random_product['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $random_product['reviews_rating'])) . '</div>'); } elseif (isset($HTTP_GET_VARS['products_id'])) { // display 'write a review' box $info_box_contents[] = array('text' => '<table border="0" cellspacing="0" cellpadding="2"><tr><td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'box_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW) . '</a></td><td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, 'products_id=' . $HTTP_GET_VARS['products_id']) . '">' . BOX_REVIEWS_WRITE_REVIEW .'</a></td></tr></table>'); } else { // display 'no reviews' box $info_box_contents[] = array('text' => BOX_REVIEWS_NO_REVIEWS); } new infoBox($info_box_contents); ?> </td> </tr> <!-- reviews_eof //--> I have a clone version of this site for my US customers and the reviews works normally. I thank you very much for your help. ccl <{POST_SNAPBACK}> I just found the problem, I have moved the box from right_column.php to left_column.php a few weeks ago and that cause the problem. I just changed it back to where it use to be and it is now working fine. I will try to see why the box doesn't like to be changed from the right to the left! Thank you again, ccl
Guest Posted December 5, 2004 Posted December 5, 2004 I just found the problem, I have moved the box from right_column.php to left_column.php a few weeks ago and that cause the problem. I just changed it back to where it use to be and it is now working fine. I will try to see why the box doesn't like to be changed from the right to the left! Thank you again, ccl <{POST_SNAPBACK}> Any feedback or more info on this one? I have the same issue, using column_left also, but my site doesn't use a column_right, so I would like to fix the actual problem. It's got me stumped.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.