Guest Posted January 6, 2005 Posted January 6, 2005 I put an item in the cart, then tries to remove the item with the checkbox then update, and all I get is this message; 1064 - You have an error in your SQL syntax near '{1}4 and session_id = 'ab98bd9d328843f61a326efdec61167f'' at line 1 delete from customers_basket_text_attributes where products_id = 28{1}4 and session_id = 'ab98bd9d328843f61a326efdec61167f' [TEP STOP] I click on back, then the item (or items if more than one) is removed from the cart. I get somewhat the same error when clickin on the shopping cart on the right side; 1064 - You have an error in your SQL syntax near '{1}4' at line 1 select pta.* from products_text_attributes as pta, products_text_attributes_enabled as ptae where ptae.products_text_attributes_id = pta.products_text_attributes_id and ptae.products_id = 28{1}4 [TEP STOP] In MySQL on customers_basket_text_attributes I read session_id products_id products_text_attributes_id products_text_attributes_text Edit Delete ab98bd9d328843f61a326efdec61167f 28 8 Edit Delete ab98bd9d328843f61a326efdec61167f 28 7 Edit Delete ab98bd9d328843f61a326efdec61167f 28 6 Edit Delete ab98bd9d328843f61a326efdec61167f 28 5 Edit Delete ab98bd9d328843f61a326efdec61167f 28 4 Edit Delete ab98bd9d328843f61a326efdec61167f 28 3 Edit Delete ab98bd9d328843f61a326efdec61167f 28 2 Edit Delete ab98bd9d328843f61a326efdec61167f 28 1 I have the Text Option Mod by Denuz installed, but could someone verify that theese eight instances are correct?
Guest Posted January 6, 2005 Posted January 6, 2005 Since I haven't gotten the correct rights to edit my post, let me add; I've looked through instructions for the mods I've installed, and checked the Knowledge Base. If anyone has some info, hints, or someone could perhaps point me in the right direction, it would be greatly appreciated.. Pretty please...? :'(
Guest Posted April 23, 2005 Posted April 23, 2005 for future use: find in includes/application_top.php tep_db_query("delete from customers_basket_text_attributes where products_id = " . tep_get_uprid($HTTP_POST_VARS['products_id'][$i]) . " and session_id = '" . $osCsid . "'"); and change $HTTP_POST_VARS['products_id'][$i] to tep_get_uprid($HTTP_POST_VARS['products_id'][$i]) that's it
Recommended Posts
Archived
This topic is now archived and is closed to further replies.