create product does not work after 1-click upgrade

[ifs]

Hi,

 

I upgraded with 1-click from 1.7.2.x to 1.7.4.2

Now create new product or editing products are impossible...

How can I fix that pls ?

 

enpopi.com

 

[fitgura]

you should post your server's information and maybe check out folder and file permissions as 755 for folders and 644 for files, but sometimes upgrade change them to 777 and 666

[ksaan]

Try the "debug mode" to see if you can analyze the errors
https://zemez.io/prestashop/support/how-to/prestashop-1-7-enable-debug-mode-display-errors/

[ifs]

Under debug mode I got these errors below but it is quite impossible for me to understand 

 

 

 

Symfony Exception

SymfonyDocs

SymfonySupport

PrestaShopDatabaseException

HTTP 500 Internal Server Error

Unknown column 'additional_delivery_times' in 'field list'<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', '2018-08-24 19:14:11', '2018-08-24 19:14:11', '3')</pre>

 

• Exception
• Logs2
• Stack Trace

PrestaShopDatabaseException

inclasses/db/Db.php(line 746)

741.         if ($webservice_call && $errno) {
742.             $dbg = debug_backtrace();
743.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745.             if ($sql) {
746.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747.             }
749.             throw new PrestaShopDatabaseException($this->getMsgError());
750.         }
751.     }

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\', \'2018-08-24 19:14:11\', \'2018-08-24 19:14:11\', \'3\')')inclasses/db/Db.php(line 378)

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\', \'2018-08-24 19:14:11\', \'2018-08-24 19:14:11\', \'3\')')inclasses/db/Db.php(line 718)

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\', \'2018-08-24 19:14:11\', \'2018-08-24 19:14:11\', \'3\')', true)inclasses/db/Db.php(line 467)

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' => '2018-08-24 19:14:11', 'date_upd' => '2018-08-24 19:14:11', 'pack_stock_type' => 3), false)inclasses/ObjectModel.php(line 529)

ObjectModelCore->add(true, false)inclasses/Product.php(line 596)

ProductCore->add(true, false)inclasses/ObjectModel.php(line 487)

ObjectModelCore->save()insrc/PrestaShopBundle/Controller/Admin/ProductController.php(line 423)

ProductController->newAction()

call_user_func_array(array(object(ProductController), 'newAction'), array())invar/cache/dev/classes.php(line 4646)

HttpKernel->handleRaw(object(Request), 1)invar/cache/dev/classes.php(line 4601)

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

Kernel->handle(object(Request), 1, false)inadminpanel/index.php(line 88)

 

500@admin_product_new

1704ms

51.0MB

2

18in4.28ms

[email protected]

734ms

1in0.36ms

Hooks (0)

0

1.7.4.2

[ifs]

Hello Prestashop Team 

I need help please.

How can fix that error ?

 

I found a new error:

This not possible to select size or color at the product page 

 

 

Need help pls 

Edited August 25, 2018 by ifs (see edit history)