5009 error when duplicating a product
Exception thrown when trying to duplicate a product.
Debug gives these details
PrestaShopDatabaseException:
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 'INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `re...' at line 1<br /><br /><pre>INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 4, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 5, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;</pre>
at classes/db/Db.php:769
at DbCore->displayError('INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 4, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 5, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;')
(classes/db/Db.php:385)
at DbCore->query('INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 4, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 5, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;')
(classes/db/Db.php:566)
at DbCore->execute('INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 4, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;INSERT INTO `pr_product_group_reduction_cache` (`id_product`, `id_group`, `reduction`) VALUES (821, 5, 0.05) ON DUPLICATE KEY UPDATE `reduction` = 0.05;')
(classes/GroupReduction.php:276)
at GroupReductionCore::duplicateReduction(23, '821')
(src/Adapter/Product/AdminProductDataUpdater.php:215)
at PrestaShop\PrestaShop\Adapter\Product\AdminProductDataUpdater->duplicateProduct('23')
(src/PrestaShopBundle/Controller/Admin/ProductController.php:1084)
at PrestaShopBundle\Controller\Admin\ProductController->unitAction('duplicate', '23')
(vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, false)
(vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request), 1, false)
Fix is to edit config/defines.inc.php
define('PS_ALLOW_MULTI_STATEMENTS_QUERIES', false); FALSE change to TRUE
- Hits: 8