zpe Posted February 27, 2007 Share Posted February 27, 2007 Hello, I installed the Product Extra Fields Contribution, it works great! no SQL syntax errors when I have Force Cookie Use set for true, but I have trouble adding product to the cart and checking out with it set to true. If I set Force Cookie Use to False I get this error below when I click a product. 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 '?osCsid=4cd22569d397c3223f019e05505893e8 and ptf.products_extra_fields_value<>''' at line 5 SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value ,pef.products_extra_fields_status as status FROM products_extra_fields pef LEFT JOIN products_to_products_extra_fields ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=44?osCsid=4cd22569d397c3223f019e05505893e8 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order [TEP STOP] I have no clue. Any help would be greatly appreciated. Tom Link to comment Share on other sites More sharing options...
zpe Posted February 28, 2007 Author Share Posted February 28, 2007 I was using extra_fields_v2_0i so I upgraded to extra_fields_v2_0j. That fixed it! Force Cookies can now be turned off without SQL syntax errors . I had to do a lil editing to make everything look right. Thanks to the oscommerce team, and everyone that has worked on Product Extra Fields Contribution. I love it! Tom Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.