Arien Posted August 11, 2003 Share Posted August 11, 2003 Heya Peeps, I recently installed the Review Approval system contribution but when i go into my admin area to the review part i get this error. Fatal error: Call to undefined function: tep_array_merge() in /home/m00ie/public_html/store/admin/reviews.php on line 225 Can anyone help me out? I haven't modified any of the files that came with the Contribution zip.. Kind Regards, Robin Hawkes. Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 11, 2003 Share Posted August 11, 2003 hi you need to change all instances of tep_array_merge( to array_merge( the contributiong was probably written for an earlier version of osCommerce and the function was renamed in later versions. Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_ select count(select r.reviews_id, rd.reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from reviews r, reviews_description rd, products p, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' 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 = '1' and rd.languages_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and r.approved=1 order by r.reviews_id DESC) as total [TEP STOP] I'm now getting that error on the the page where the reviews are shown to the public.. any ideas? Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 try finding the actual code and pasting that line Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 $reviews_query_raw = "select r.reviews_id, rd.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, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' 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 = '" . $languages_id . "' and rd.languages_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and r.approved=1 order by r.reviews_id DESC"; I think thats the line.. didn't actually give an exact line error. Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 Try $reviews_query_raw = "select r.reviews_id, rd.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, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' 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 = '" . $languages_id . "' and rd.languages_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and r.approved= '1' order by r.reviews_id DESC"; Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 nope.. still gives the same error. Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 Try :) $reviews_query_raw = "select r.reviews_id, rd.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, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' 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 = '" . $languages_id . "' and rd.languages_id = '" . $languages_id . "' and p2c.categories_id = c.categories_id and r.approved = '1' order by r.reviews_id DESC"; Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 still giving the error :(. Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 ok revert back to your version of that line, i suspect you've pasted the wrond lin anyway, it should contain select count somewhere in the line we need to fix! So look for that and paste me the line that includes that somewhere in there! :) Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 i think its in catalog/product_reviews_info.php Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 I can't find select count anywhere in that file.. any suggestions? Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 Yup catalog/product_reviews_info.php Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 $review_check_query = tep_db_query("select count(*) as total from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.reviews_id = '" . (int)$HTTP_GET_VARS['reviews_id'] . "' and r.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "'"); Found it but it was in a file i didn't edit when installing the modification. Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 Ok last try!!! :D That other line in product_reviews.php try $reviews_query_raw = "select r.reviews_id, rd.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 = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and rd.languages_id = '" . $languages_id . "' and r.approved='1' order by r.reviews_id DESC"; Last try im all out of suggestions!? Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 If you meant reviews.php it didn't work.. if you meant product_reviews.php there is no such line i can find in there. Quote Link to comment Share on other sites More sharing options...
Rumble Posted August 12, 2003 Share Posted August 12, 2003 I'm sorry im all out of ideas! Quote Reddy to Rumble Thank you osCommerce and all who Contribute to her! Link to comment Share on other sites More sharing options...
Arien Posted August 12, 2003 Author Share Posted August 12, 2003 ah thanks anyways, i guess if no one can figure it out i'll just have to remove the review system totally from my site unless a different/new contrubution is made to to the same as this one. :( Quote Link to comment Share on other sites More sharing options...
Warp Posted September 26, 2003 Share Posted September 26, 2003 mmm same problem here.... Quote luke Link to comment Share on other sites More sharing options...
jonah Posted November 1, 2003 Share Posted November 1, 2003 I have submitted an update to this contribution. It should now work with MS2. You can download it here: http://www.oscommerce.com/community/contributions,76 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.