danthman Posted September 13, 2005 Share Posted September 13, 2005 I installed Total B2B v 1.4 in a fresh install and I get this error in several areas of the admin section. How can i correct this? I am very new to Mysql 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.customers_groups_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 [TEP STOP] Quote Link to comment Share on other sites More sharing options...
Guest Posted September 13, 2005 Share Posted September 13, 2005 bug report & fix here: http://www.oscommerce.com/community/bugs,1605 Quote Link to comment Share on other sites More sharing options...
danthman Posted September 15, 2005 Author Share Posted September 15, 2005 bug report & fix here:http://www.oscommerce.com/community/bugs,1605 <{POST_SNAPBACK}> Thanks ! I found an easy fix at that link! 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.