Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Attribute Quantity Mod


johanv

Recommended Posts

Hello,

 

I am using OSC 2.2, and I am trying to integrate the Attribute Quantity Mod Contribution 3302

 

Everytime I try to checkout with a product that has an attribute I will get this 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 'from products_options popt, products_options_values poval, products_attributes p' at line 1

 

select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, products_options_id, products_options_values_id, from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = '##' and pa.options_id = '#' and pa.options_id = popt.products_options_id and pa.options_values_id = '#' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '#' and poval.language_id = '#'

"

 

Replace the # signs with actual numbers. Any help would be greatly appreciated.

 

Johan

Link to comment
Share on other sites

The error message says to look at the part starting with from products_options popt. I see an extra comma just before that string.

 

Regards

Jim

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...