exupawi Posted July 4, 2007 Share Posted July 4, 2007 Hi, I have the following message on my site when I click to view new products after logging on as a customer. Warning: Division by zero in /home/staymyba/public_html/osCommerce/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 p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name limit -0, 0 [TEP STOP] I saw some similar errors posted but not sure how to fix this. Any help is appreciated. I looked on line 59 of split_page but am unsure about the "division by zero statement. Thanks for your help! Link to comment Share on other sites More sharing options...
Guest Posted July 4, 2007 Share Posted July 4, 2007 look here: http://www.oscommerce.com/forums/index.php?showtopic=268415 Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.