Here's the complete error text. I associated it with cross sell because of some of the text.
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 '-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)]
I am using ZC 1.3.7
jacque
Bookmarks