Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Order Page - error in sql syntax


Recommended Posts

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



Link to comment
Share on other sites

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


This topic is now archived and is closed to further replies.

  • Create New...