Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 - You have an error in your SQL syntax


Guest

Recommended Posts

When checking my order history as a customer I get this error,

 

"My Order History"

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 '-10, 10' at line 1

 

select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by orders_id DESC limit -10, 10

 

[TEP STOP]

 

Any Ideas?

Link to comment
Share on other sites

If you download the latest oscommerce update, there is an update file included with it. Find the fix for split_page_results and apply it to your site. That will fix the problem.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

If you download the latest oscommerce update, there is an update file included with it. Find the fix for split_page_results and apply it to your site. That will fix the problem.

 

Jack

 

Hello Jack,

 

I have same problem too. and I also installed Chinese Big5 language.

Would that be Ok just update latest version of oscommerce?

should I need to do anything with language chinese big 5 OSC?

 

Thanks!!

 

Rose

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...