Jump to content

prestalinks

Members
  • Posts

    5
  • Joined

  • Last visited

Profile Information

  • First Name
    Mohamed
  • Last Name
    ELALAMI

prestalinks's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hello, I migrated prestashop 1.7.4 to 1.7.6. everything works fine. But, 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 : Out of range value for column 'id_product' at row 1 I hope someone can help me to fix the problem :(. Thank you for any help
  2. 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.
  3. 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.
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More