al_fernandes Posted April 12, 2005 Posted April 12, 2005 Hi In the admin area (cstumer order) I found the following error: 1064 - You have an sintax error in your SQL near to '-20, 20' line 1: select o.orders_id, o.customers_name, 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 = '4' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 How can fix it in the install directory so I dont have to fix every time after beeing instaled? Many thanks
Simplyeasier Posted April 12, 2005 Posted April 12, 2005 Hi In the admin area (cstumer order) I found the following error: 1064 - You have an sintax error in your SQL near to '-20, 20' line 1: select o.orders_id, o.customers_name, 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 = '4' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 How can fix it in the install directory so I dont have to fix every time after beeing instaled? Many thanks <{POST_SNAPBACK}> read this http://www.oscommerce.com/forums/index.php?showtopic=144095 Charles A kite flies highest AGAINST the wind ! "Life should NOT be a journey to the grave with the intention of arriving safely in an attractive and well preserved body, but rather to skid in sideways, a lover in one hand, martini in the other, body thoroughly used up, totally worn out and screaming ~ WOO HOO!! What a ride!"
Recommended Posts
Archived
This topic is now archived and is closed to further replies.