Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 error please help


Recommended Posts

Hi all,


Please help I have searched for a fix for this and tried lots but nothing helps.


The error occurs when clicking on checkout


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 ') and products_id in (74)' at line 1


select * from products_to_categories where categories_id not in () and products_id in (74)




I hope someone can help

Link to comment
Share on other sites

It's missing the category id. That code appears to be from a contribution so you should ask in the support thread for that contribution for more in-depth help.



Support Links:

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

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

search on the forum for the 1064 error & you will find the topic.

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites


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

  • Create New...