Kelkoo Contribution

[dreammediauk]

Hi,

 

I've installed the following contribution: http://www.oscommerce.com/community/contributions,2220/. Everything's been backed up, so I'm not panicking (yet!).

 

In the Tools section of the Admin Panel, under Kelkoo, I'm receiving the following SQL error:

 

1064 - You have an error in your SQL syntax near '(select p.products_id, p.products_compare_status, p.products_quant' at line 1

(select p.products_id, p.products_compare_status, p.products_quantity, p.products_price, p.products_tax_class_id, pd.products_name, cd.categories_name from products p, products_description pd, products_to_categories p2c, categories c, categories_description cd WHERE p.products_id = pd.products_id AND cd.categories_id = c.parent_id AND p.products_id = p2c.products_id AND c.categories_id = p2c.categories_id AND p.products_status = 1 AND p.products_price <> 0 AND pd.language_id = '1' AND cd.language_id = '1' AND pd.products_name like '%%' group by p.products_id, cd.categories_id)

 

Has anyone else used this contribution and had the same error? I'm not even sure where to start looking!!

 

Any suggestions would be gratefully received - thanks.

 

John.