theinkjetmarket Posted October 2, 2008 Posted October 2, 2008 I am lost with this one. When a customer checks his order history the following is displayed: My Order History 0 - select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '17' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' order by orders_id DESC limit -0, 0 [TEP STOP] In the address bar it reads: www.mydomain.co.uk/account_history.php The following may give more clues to someone - When I tried it on my development machine I got the following which is basically the same but with more indication to the cause: My Order History Warning: Division by zero in C:\Web\WebServer\Apache2\htdocs\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 o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' order by orders_id DESC limit -0, 0 [TEP STOP]
♥FWR Media Posted October 2, 2008 Posted October 2, 2008 I am lost with this one. When a customer checks his order history the following is displayed: My Order History 0 - select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '17' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' order by orders_id DESC limit -0, 0 [TEP STOP] In the address bar it reads: www.mydomain.co.uk/account_history.php The following may give more clues to someone - When I tried it on my development machine I got the following which is basically the same but with more indication to the cause: My Order History Warning: Division by zero in C:\Web\WebServer\Apache2\htdocs\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 o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' order by orders_id DESC limit -0, 0 [TEP STOP] Please don't post until you have at least made a minor attempt at searching it is most annoying. Google search .. site:oscommerce.com Warning: Division by zero Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.