Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

database error on CUSTOMER > ORDERS


nchingcu

Recommended Posts

Hello everyone,

 

Hope everyone is doing ok.

 

Anyway, I am getting a database error when I click on Customer > Orders from the admin panel.

Needless to say, I can't process orders. :-(

 

The store is fine, the orders go through. I just can't process it.

 

This is the error message

 

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 '-20, 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 o.orders_id DESC limit -20, 20

 

This happened after I swtich hosting account with the same hosting provider.

 

I've checked and re-checkc all my config file and everything is ok there. So, I'm at a lost as to whatt to do. The error message tells me to look at my SQL table but that's all greek to me.

 

Any ideas? Ayy help would be appreciated.

Link to comment
Share on other sites

If you do a Google search (site:www.oscommerce.com/forums 1064) you should find the solution.

 

(I'm not sure of the exact fix but I've seen this issue posted a few times).

 

Good luck. :)

Link to comment
Share on other sites

If you do a Google search (site:www.oscommerce.com/forums 1064) you should find the solution.

 

(I'm not sure of the exact fix but I've seen this issue posted a few times).

 

Good luck. :)

 

 

I found that topic but non of the solutions they discussed worked for me. However, it did point me to the right direction.

 

I downloaded osCommerce and just replaced my catalog/admin/includes/classes/split_page_results.php from this one and it worked

 

Apparently, there's a difference in that file and the one I have. Although, I know, I have not touched mine. So I'm assuming theres a change in the one I downloaded.

 

Anyway, Thanks

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...