Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

help with cart (odd error)


Shuey

Recommended Posts

Posted

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

Archived

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

×
×
  • Create New...