al_fernandes Posted April 12, 2005 Share 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 Link to comment Share on other sites More sharing options...
Simplyeasier Posted April 12, 2005 Share 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!" Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.