Jump to content
Sign in to follow this  
bhbilbao

XSELL CART

Recommended Posts

http://addons.oscommerce.com/info/1808

 

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 '{6}17{8}36{7}26 AND px.xsell_id = p.products_id AND p.products_id > '100' AND xp' at line 1

 

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 = 10{6}17{8}36{7}26 AND px.xsell_id = p.products_id AND p.products_id > '100' AND xp.xsell_id > '100' AND px.xsell_id = pd.products_id AND p.products_status = '1' AND pd.language_id = '3' ORDER BY p.products_ordered DESC

 

[TEP STOP]

 

i tried to delimiting the query to non-atributed products but nothing.

 

This contribution needs some fix like "if tep not null --- px.products_id"

 

some suggest-

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×