1064 error

  • Posts: 62
  • Thank you received: 0
  • Hikashop Business
5 years 3 months ago #309263

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
5 years 3 months ago #309264

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.

Please Log in or Create an account to join the conversation.

  • Posts: 62
  • Thank you received: 0
  • Hikashop Business
5 years 3 months ago #309266

Hi Nicolas,

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

regards,
Joost

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13375
  • MODERATOR
5 years 3 months ago #309267

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:

if(!isset($products[$key])) {
to;
if(count($catIds) && !isset($products[$key])) {
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.

Please Log in or Create an account to join the conversation.

  • Posts: 62
  • Thank you received: 0
  • Hikashop Business
5 years 3 months ago #309286

Hi Nicolas!

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum