1064 error

-- HikaShop version -- : 4.2.1
-- Joomla version -- : 3.9.10
-- PHP version -- : 7.2.20
-- Error-message(debug-mod must be tuned on) -- : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 SELECT product_id FROM saqj9_hikashop_product_category WHERE category_id IN ()

Hi,

I have in a specific category of my shop an error when I try to enter the price of a product or when I try to add some variants to it. I got this error message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 SELECT product_id FROM saqj9_hikashop_product_category WHERE category_id IN ()

You can see it in live here: www.mijnkinderkamer.nl/nl/producten/hout...etters-12-cm-meisjes

I have tried a lot and search for same errors but no result till now.

Any idea what can be wrong?

regards,
Joost

Hi,

Could you activate the "debug mode" and the "error reporting" settings of the Joomla configuration and try again ?
That error page should then contain much more information on the issue which will help us provide a solution.

Hi Nicolas,

Thanks for the quick reply!
That is activated. Do you want me to send you the errorpage?

regards,
Joost

Hi,

This indicates that there is an issue with the "categories" restriction setting of one or several of your discounts. Like for example if you deleted a category that was selected in a discount.
Change the line: to; in the file administrator/components/com_hikashop/classes/currency.php and that will fix the error.
We'll add the patch on our end too.

Hi Nicolas!

Thanks for the quick and great support!
Everything is working again! Thanks!