Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 Mysql problem in orders section of OsCommerce


Recommended Posts

Hello all,


We are trying desperately to understand why this is happening. We have a mysql database on a server with an isp called powweb. I have tried looking around in the mysql admin section to see if i can make any sense of it but i'm totally stuck. Is there any suggestions that anyone could make or does anyone know of anywhere we could go to get this problem fixed quickly and cheaply we just trying to get the website off the ground at the mo so have very very little money.



This message is coming up in os commerce when i click on orders!



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


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

  • Create New...