error 1064 after uploading a csv file

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.6
-- PHP version -- : 5.4.43
-- Browser(s) name and version -- : chrome...firefox..all
-- Error-message(debug-mod must be tuned on) -- : 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 ') GROUP BY b.product_id LIMIT 0,25' at line 4 SQL=SELECT DISTINCT b.product_id AS id, a.category_id AS catid, b.product_name AS name, b.product_description AS descr, b.product_alias AS alias, b.product_tax_id AS tax FROM bwi1n_hikashop_product_category AS a LEFT JOIN bwi1n_hikashop_product AS b ON a.product_id = b.product_id WHERE product_published = 1 AND a.category_id IN () GROUP BY b.product_id LIMIT 0,25

Hello,

we tried to upload our csv files to sync our products with hikashop database, we had istantly in the main page of the shop the error reported in the topic description above, ERROR 1064.

We tried to remove products, variants and categories from the db to erase everything, but we're missing something because the problem is still there, how can we fix the situation? do you need more informations about the problem?

Waiting for your reply, all the best.

Hi nicolas!!!
we discovered that the problem was about another module that was not-working in the hikashop category page.. Thanks a lot for the suggestion!