Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

The 1064 Error on Orders.php


muzicman82

Recommended Posts

Alright, I'm having this 1064 Error on my Admin section Orders.php page. The fix that's been posted and discussed isn't working and is still implemented in my split_page_results.php file. Any ideas?

 

There were no orders, but I just created one for testing.

 

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 s.orders_status_id = '0' and ot.class = 'ot_total' order by limit 0, 20

 

Thanks!

Link to comment
Share on other sites

Alright, I'm having this 1064 Error on my Admin section Orders.php page. The fix that's been posted and discussed isn't working
It is, but you have installed a contribution (can't remember the name) that is flawed.

 

The problem is with the order by missing field limit

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...