Guest Posted February 25, 2005 Share Posted February 25, 2005 This is what i get when i go to Orders in my admin control panel.. where should i look to fix this? Thanks! (FYI i have paypal IPN v.1 and pm2checkout installed) 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 'limit 0, 20' at 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 = '1' and ot.class = 'ot_total' order by limit 0, 20 [TEP STOP] Link to comment Share on other sites More sharing options...
OceanRanch Posted February 25, 2005 Share Posted February 25, 2005 This bug report should have some alternative fixes for you. http://www.oscommerce.com/community/bugs,1605 HTH Tom Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2005 Share Posted February 25, 2005 Hi ocean, thanks for your help! Actually i did all the fixes as prescribed in the bug reports page but that didn't fix it. Then i found another thread in the IPN Paypal thread and it said in there sombody had a problem with catalog/admin/orders.php I just re upped a fresh orders.php and it worked! Thanks for the help. 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.