lonestarbaits Posted December 11, 2005 Posted December 11, 2005 somebody leaves a review for a product, it gives them this error Warning: Division by zero in /home/lonestar/public_html/catalog/includes/classes/split_page_results.php on line 59 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 '-0, 0' at line 1 select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name from reviews r, reviews_description rd where r.products_id = '29' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' order by r.reviews_id desc limit -0, 0 [TEP STOP] the review is still set, but just a bit annoying
lonestarbaits Posted December 12, 2005 Author Posted December 12, 2005 okay, I found this fix ( http://www.oscommerce.com/community/bugs,3059/ ), but it didn't seem to fix it completely, I'm still getting Warning: Division by zero in /home/lonestar/public_html/catalog/includes/classes/split_page_results.php on line 59 when I hit back on the reviews page...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.