Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL Syntax Error When Opening Orders.php in Admin


parmenio

Recommended Posts

About a week ago, my client informed me that he was no longer able to display orders of the pending or processed status, but is still able to view orders that are shipped. Clicking on "pending" or "processed" show a MySQL syntax error:

 

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 '-15, 15' 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 s.orders_status_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -15, 15

 

Obviously, you can't use a negative integer in limit, but I'm unsure as to how it's coming up with -15. Changing the max search results to 17 makes the first number -17. I have not touched the php script in a while, so I'm also unsure as to why the problem even came up. This problem does not seem to happen when viewing "shipped" orders.

 

Can anybody help me solve this problem, or have any ideas why it happened to begin with?

 

Sincerely,

William Peterson

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...