Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL syntax error 1064


Recommended Posts

I just installed the Text Options Mod. The problem occurs when I try to remove an item from my shopping cart that uses the text option. I get the error message. Then I can use my browsers back button and the item is removed from my cart, all is well. But until I actually delete from the database, all other attempts to remove and update from shopping cart get the same error. Any ideas?


here is the 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 '{15}150{14}178{2}176 and session_id = '31b04ad84d4a34eb44529f95


delete from customers_basket_text_attributes where products_id = 390{15}150{14}178{2}176 and session_id = '31b04ad84d4a34eb44529f95d6ec084b'




Thanks for any help.

Link to comment
Share on other sites

It's not MySQL...it's the osCommerce function which is located in includes/functions/general.php and extracts the products_id from one that has attributes (like the one above).


I can't tell you how to fix it since I have no idea what contribution you are using. However, you can find their support thread in the contribution support channel and describe your issue. Also, tell them that it needs to be run through tep_get_prid() to extract the products_id properly.



Link to comment
Share on other sites


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

  • Create New...