Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help with cart (odd error)


Shuey

Recommended Posts

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

Archived

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

×
×
  • Create New...