Error when Click on "New Product" on Prestashop Backoffice

[prestalinks]

Hi All , 

I migrated prestashop 1.7.4 to 1.7.6. everything works fine.

when I click on "New Product" on the catalog, it redirects me to the backoffice home page.

I activated the debug mode, and I get the following message :

 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

PrestaShopDatabaseException                                  HTTP 500 Internal Server Error

Out of range value for column 'id_product' at row 1<br /><br /><pre>INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '1', '2', '1', '0', '0', '0', '1', NULL, '0', '0', '0', '', '0', '0', '0', '0', '0', '1', '', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2019-11-30 12:51:51', '2019-11-30 12:51:51', '3')</pre>

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

PrestaShopDatabaseException

in classes/db/Db.php (line 769)

        if ($webservice_call && $errno) {

            $dbg = debug_backtrace();

            WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);

        } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {

            if ($sql) {

                throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');

            }

            throw new PrestaShopDatabaseException($this->getMsgError());

        }

    }

DbCore->displayError('INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES (\'1\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'1\', \'2\', \'1\', \'0\', \'0\', \'0\', \'1\', NULL, \'0\', \'0\', \'0\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'1\', \'\', \'0\', \'1\', \'0000-00-00\', \'0\', \'new\', \'1\', \'0\', \'both\', \'0\', \'0\', \'2019-11-30 12:51:51\', \'2019-11-30 12:51:51\', \'3\')')in classes/db/Db.php (line 385)

DbCore->query('INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES (\'1\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'1\', \'2\', \'1\', \'0\', \'0\', \'0\', \'1\', NULL, \'0\', \'0\', \'0\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'1\', \'\', \'0\', \'1\', \'0000-00-00\', \'0\', \'new\', \'1\', \'0\', \'both\', \'0\', \'0\', \'2019-11-30 12:51:51\', \'2019-11-30 12:51:51\', \'3\')')in classes/db/Db.php (line 740)

DbCore->q('INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `isbn`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `state`, `additional_delivery_times`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `low_stock_threshold`, `low_stock_alert`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_type_redirected`, `available_for_order`, `available_date`, `show_condition`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `pack_stock_type`) VALUES (\'1\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'\', \'\', \'\', \'0\', \'0\', \'0\', \'0\', \'1\', \'2\', \'1\', \'0\', \'0\', \'0\', \'1\', NULL, \'0\', \'0\', \'0\', \'\', \'0\', \'0\', \'0\', \'0\', \'0\', \'1\', \'\', \'0\', \'1\', \'0000-00-00\', \'0\', \'new\', \'1\', \'0\', \'both\', \'0\', \'0\', \'2019-11-30 12:51:51\', \'2019-11-30 12:51:51\', \'3\')', true)in classes/db/Db.php (line 476)

DbCore->insert('product', array('id_shop_default' => 1, 'id_manufacturer' => 0, 'id_supplier' => 0, 'reference' => '', 'supplier_reference' => '', 'location' => '', 'width' => 0, 'height' => 0, 'depth' => 0, 'weight' => 0, 'quantity_discount' => 0, 'ean13' => '', 'isbn' => '', 'upc' => '', 'cache_is_pack' => 0, 'cache_has_attachments' => 0, 'is_virtual' => 0, 'state' => 0, 'additional_delivery_times' => 1, 'id_category_default' => 2, 'id_tax_rules_group' => 1, 'on_sale' => 0, 'online_only' => 0, 'ecotax' => 0, 'minimal_quantity' => 1, 'low_stock_threshold' => array('type' => 'sql', 'value' => 'NULL'), 'low_stock_alert' => 0, 'price' => 0, 'wholesale_price' => 0, 'unity' => '', 'unit_price_ratio' => 0, 'additional_shipping_cost' => 0, 'customizable' => 0, 'text_fields' => 0, 'uploadable_files' => 0, 'active' => 1, 'redirect_type' => '', 'id_type_redirected' => 0, 'available_for_order' => 1, 'available_date' => '0000-00-00', 'show_condition' => 0, 'condition' => 'new', 'show_price' => 1, 'indexed' => 0, 'visibility' => 'both', 'cache_default_attribute' => 0, 'advanced_stock_management' => 0, 'date_add' => '2019-11-30 12:51:51', 'date_upd' => '2019-11-30 12:51:51', 'pack_stock_type' => 3), false)in classes/ObjectModel.php (line 561)

ObjectModelCore->add(true, false)in classes/Product.php (line 603)

ProductCore->add(true, false)in classes/ObjectModel.php (line 516)

ObjectModelCore->save()in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 407)

ProductController->newAction()

call_user_func_array(array(object(ProductController), 'newAction'), array())in var/cache/dev/classes.php (line 4581)

HttpKernel->handleRaw(object(Request), 1)in var/cache/dev/classes.php (line 4536)

HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)

Kernel->handle(object(Request), 1, false)in administration-bo/index.php (line 86)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Version de PrestaShop : 1.7.6.1

Version de MySQL : 5.5.64-MariaDB

Version du logiciel serveur : Apache/2.4.6

Version de PHP : 5.6.40

Limite de mémoire : 256M

Temps maximal d'exécution : 300

 

I hope someone can help me to fix the problem :(.

Thank you for any help.

[prestalinks]

Hi All , 

 

Can you help me plz ?

Thanks