Shuey Posted January 12, 2006 Share Posted January 12, 2006 I am getting a weird error when I try to click on an item that is in the shopping cart. For example, when I have an item in my cart and i move my mouse over the item in the cart, the hyperlink is: http://www.inveniotechnology.com/product_info.php?products_id=126{17}27{txt_16} If I try to click on the item in the cart I receive the following error: 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 '{17}27{txt_16} and ptf.products_extra_fields_value<>'' and (pef SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value 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=126{17}27{txt_16} and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order [TEP STOP] Ok, the link to the item iteself is http://www.inveniotechnology.com/product_info.php?cPath=3_42_47&products_id=126 Anyone have any idea what would be causing that error? Thanks! Shuey Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.