Ultimate Cross Sell Error

[atemp]

Please help. I have the following error on my checkout screen. I have seen similar but not this one.

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 ultimate_cross_sell_1 xp, produ' at line 7
in:
[(select p.products_id, p.products_image from ultimate_cross_sell_1 xp, products p, products_description pd where xp.products_id = '341' 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 ultimate_cross_sell_1 xp, products p, products_description pd where xp.products_id = '341' 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)]

[ultimate_zc]

It would help if you do a little research in order to find answers to your questions. Creating new threads for issues that are already addressed is frown upon.

The thread for Ultimate Cross Sell for Zen Cart is located here. Your exact problem has been addressed and answered before. Click here for Post #2 and Post #4 of the Ultimate Cross Sell thread for the question and the answer respectively.

[atemp]

Managed to sort it out. Checked the changes made to the files as instructed and noticed I somehow had doubled up the change. Removed the repeat and hey presto worked.