Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

About SQL error


Qvomos

Recommended Posts

Under the Admin/Customers/Orders I get an error:

1064 - You have an error in your SQL syntax near 'limit 0, 5' at line 1

The table is completely scrambled and impossible to read and asses the customer's orders. Wondering if anyone knows how can that be fixed as I confess to know nothing about SQL.

Thanks in advance for any input

Jayme

Link to comment
Share on other sites

Syntax is usually just a matter of a comma or something out of place. Have you just installed your shop? Did you make any modifications? Did it work before? Be as specific as you can.

Link to comment
Share on other sites

Syntax is usually just a matter of a comma or something out of place. Have you just installed your shop? Did you make any modifications? Did it work before? Be as specific as you can.

The store has been running for a while with no problems at all but since I had to do a manual reinstall (and not thru my web hosting control panel) due to the Downloado Controller 5.2 not working properly, the error began to appear and never did go away even after 2 or 3 reinstalls after that. I am sure you are right about being something very simple like a comma or some other "symbol". I just don't know absolutely nothing about databases lol, shame...

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...