Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 error please help


mouthrax

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)

 

[TEP STOP]

 

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.

 

Jack

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

Archived

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

×
×
  • Create New...