johanv Posted January 29, 2011 Share Posted January 29, 2011 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 More sharing options...
♥kymation Posted January 29, 2011 Share Posted January 29, 2011 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 More sharing options...
johanv Posted January 30, 2011 Author Share Posted January 30, 2011 Thanks for your help Jim, I found the error in the query in includes/classes/order.php. I was going mad trying to find where that error was. Johan Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.