Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

TEP STOP when removing items from cart


Guest

Recommended Posts

Posted

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?

Posted

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...? :'(

  • 3 months later...
Posted

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

Archived

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

×
×
  • Create New...