Hello,
I installed your mod, the admin part works perfectly, but when I go to view what's in my shopping cart, this is what I get
Code:
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 '(select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, ' at line 13
in:
[(select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '79' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6) UNION (select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '81' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6)(select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '79' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6) UNION (select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '81' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6)]
Bookmarks