Cross Sell

[Woodymon]

I'm also observing error when running the last sql statement in products_xsell.sql

I tried this below and it works....

UPDATE: Not so fast with my sql statemnt fix.

Admin > Config >Product Info

Cross-Sell - Display prices?
Cross-Sell -- Do you want to display the product prices too?
Default: false

Appears correctly except that no radio buttons are rendered to allow change from true to false.

Looks like sql statment it is missing an matching closing parens. And will possibly need to escaping the apostrophes in the sql statment. First need to investigate how params are being passed to the function. Best to look at another True/False sql patch example. In the meantime if anyone has a quicker fix to the SQL code please post.

Woody

[mcpisik]

Wah...and ....boohoo

I have done all renames as suggested (i think), etc
But still come up with

Warning:  main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main on line ]: failed to open stream: No such file or directory in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17

Warning:  main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main on line ]: failed to open stream: No such file or directory in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17

Warning:  main() [function.include on line ]: Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/share/pear') in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17 

Mod works fine in Admin, but just doesn't show on my site.
Somebody save me!

[jacque427]

When a customer places more than 12 items in their shopping cart the "Also Purchased" box at the bottom disappears and the following error message appears...

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)' at line 1
in:

[(select p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '265' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '268' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '270' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '283' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '292' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '521' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '307' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '314' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '363' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '367' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '365' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '344' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '1229' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit -1)]

What's causing this?

ZC 1.3.7

Jacque