Skip to main content

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