Fatal error: Uncaught PrestaShopDatabaseException: 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 ')
AND mgrp.not_purchasable = 1
) AS combined LIMIT 1' at line 20<br /><br /><pre>
SELECT COUNT(*) AS cnt
FROM (
SELECT mgrp.id_mdgift_rule_product
FROM `aednu_mdgift_rule_product` mgrp
INNER JOIN `aednu_mdgift_rule` mgr
ON mgrp.id_mdgift_rule = mgr.id_mdgift_rule
WHERE mgr.active = 1
AND mgrp.gift_criteria_filter = "products"
AND mgrp.id_product = 1413
AND mgrp.not_purchasable = 1
UNION ALL
SELECT mgrp.id_mdgift_rule_product
FROM `aednu_mdgift_rule_product` mgrp
INNER JOIN `aednu_mdgift_rule` mgr
ON mgrp.id_mdgift_rule = mgr.id_mdgift_rule
WHERE mgr.active = 1
AND mgrp.gift_criteria_filter = "categories"
AND mgrp.id_product IN ()
AND mgrp.not_purchasable = 1
) AS combined LIMIT 1</pre> in /var/www/wereco.kudela.dev/www/classes/db/Db.php:757
Stack trace:
#0 /var/www/wereco.kudela.dev/www/classes/db/Db.php(369): DbCore->displayError()
#1 /var/www/wereco.kudela.dev/www/classes/db/Db.php(648): DbCore->query()
#2 /var/www/wereco.kudela.dev/www/classes/db/Db.php(682): DbCore->getRow()
#3 /var/www/wereco.kudela.dev/www/modules/mdgiftproduct/mdgiftproduct.php(823): DbCore->getValue()
#4 /var/www/wereco.kudela.dev/www/modules/mdgiftproduct/mdgiftproduct.php(168): Mdgiftproduct->isGiftNotPurchasable()
#5 /var/www/wereco.kudela.dev/www/classes/Hook.php(1234): Mdgiftproduct->hookDisplayHeader()
#6 /var/www/wereco.kudela.dev/www/classes/Hook.php(447): HookCore::coreCallHook()
#7 /var/www/wereco.kudela.dev/www/classes/Hook.php(1125): HookCore::callHookOn()
#8 /var/www/wereco.kudela.dev/www/classes/controller/FrontController.php(627): HookCore::exec()
#9 /var/www/wereco.kudela.dev/www/controllers/front/ProductController.php(396): FrontControllerCore->initContent()
#10 /var/www/wereco.kudela.dev/www/classes/controller/Controller.php(308): ProductControllerCore->initContent()
#11 /var/www/wereco.kudela.dev/www/classes/Dispatcher.php(468): ControllerCore->run()
#12 /var/www/wereco.kudela.dev/www/index.php(66): DispatcherCore->dispatch()
#13 {main}
Next PrestaShop\PrestaShop\Core\Exception\CoreException: 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 ')
AND mgrp.not_purchasable = 1
) AS combined LIMIT 1' at line 20<br /><br /><pre>
SELECT COUNT(*) AS cnt
FROM (
SELECT mgrp.id_mdgift_rule_product
FROM `aednu_mdgift_rule_product` mgrp
INNER JOIN `aednu_mdgift_rule` mgr
ON mgrp.id_mdgift_rule = mgr.id_mdgift_rule
WHERE mgr.active = 1
AND mgrp.gift_criteria_filter = "products"
AND mgrp.id_product = 1413
AND mgrp.not_purchasable = 1
UNION ALL
SELECT mgrp.id_mdgift_rule_product
FROM `aednu_mdgift_rule_product` mgrp
INNER JOIN `aednu_mdgift_rule` mgr
ON mgrp.id_mdgift_rule = mgr.id_mdgift_rule
WHERE mgr.active = 1
AND mgrp.gift_criteria_filter = "categories"
AND mgrp.id_product IN ()
AND mgrp.not_purchasable = 1
) AS combined LIMIT 1</pre> in /var/www/wereco.kudela.dev/www/classes/Hook.php:469
Stack trace:
#0 /var/www/wereco.kudela.dev/www/classes/Hook.php(1125): HookCore::callHookOn()
#1 /var/www/wereco.kudela.dev/www/classes/controller/FrontController.php(627): HookCore::exec()
#2 /var/www/wereco.kudela.dev/www/controllers/front/ProductController.php(396): FrontControllerCore->initContent()
#3 /var/www/wereco.kudela.dev/www/classes/controller/Controller.php(308): ProductControllerCore->initContent()
#4 /var/www/wereco.kudela.dev/www/classes/Dispatcher.php(468): ControllerCore->run()
#5 /var/www/wereco.kudela.dev/www/index.php(66): DispatcherCore->dispatch()
#6 {main}
thrown in /var/www/wereco.kudela.dev/www/classes/Hook.php on line 469