Crosssell In Cart ERROR

[duncanjones]

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 '{1}1 AND px.xsell_id = p.products_id AND px.xsell_id = pd.produ

 

SELECT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id FROM products AS p, products_description AS pd, products_xsell AS px WHERE px.products_id = 1{1}1 AND px.xsell_id = p.products_id AND px.xsell_id = pd.products_id AND p.products_status = '1' AND pd.language_id = '1' ORDER BY p.products_ordered DESC

 

[TEP STOP]

 

 

==========

 

What does that mean? Im using cross sell in the shopping cart.

[duncanjones]

Boost

[Guest]

seems like the xsell module you're using missed the tep_get_prid for the query. Look into the source code of the contribution where it does the query and apply the function to the products_id parameter to get back just the products id.