Prestashop 1.7.4.2 Can't Add products -

[willswed]

Crazy... I cannot install any product.
Every time I click on "products" "+New product" goes to the Dashboad main page.
the url changes to "/index.php/product/form/index.php?controller=AdminDashboard&token="
and leave the products area.

I tried to clean cache, enable cache, disable cache, enable or disable "Force update of friendly URL", I install many times the prestashop and nothing really works...

Since it is the latest version, I have no idea what can be... I even changed the .htaccess and give more memory but... nothing changes..

And If I enable the DEBUG MODE, look what I see:

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-10-03 20:12:02', '2018-10-03 20:12:02', '3')</pre>

 

     if ($webservice_call && $errno) {            $dbg = debug_backtrace();            WebserviceRequest::getInstance()->setError(500, '

 '.$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\', \'2018-10-03 20:12:02\', \'2018-10-03 20:12:02\', \'3\')')in classes/db/Db.php (line 378)

and again at 718, 467...

 

Someone can help me to understand it?

Why I can't add any product?

 

see this logs:

 

 

Level	Channel	Message
INFO20:12:02	request	Matched route "admin_product_new".
DEBUG20:12:02	security	Read existing security token from the session.
DEBUG20:12:02	security	User was reloaded from a user provider.
DEBUG20:12:02	doctrine	SELECT name FROM ps_module WHERE active = 1
INFO20:12:02	php	User Deprecated: Implementing "Symfony\Component\HttpKernel\DataCollector\DataCollectorInterface" without the "reset()" method is deprecated since Symfony 3.4 and will be unsupported in 4.0 for class "Csa\Bundle\GuzzleBundle\DataCollector\GuzzleCollector".
CRITICAL20:12:02	php	Uncaught Exception: 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-10-03 20:12:02', '2018-10-03 20:12:02', '3')</pre>
CRITICAL20:12:02	request	Uncaught PHP Exception PrestaShopDatabaseException: "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-10-03 20:12:02', '2018-10-03 20:12:02', '3')</pre>" at /www/webvol13/ty/nohldthe16gvu3b/akksontryckreklam.se/public_html/classes/db/Db.php line 746

 

[anthea s]

Have similar issue after importing some 7000 categories. After clicking on product in the admin panel i get white screen. Tried deleting the categories, and it started working again. Is there a limit to the amount of categories in Ps 1.7? had no such problem on Ps 1.6 with the same amount of categories.  In the debug mode i get:

ContextErrorException in smarty_internal_templatebase.php(157) : eval()'d code line 580: Notice: Undefined index: category

in smarty_internal_templatebase.php(157) : eval()'d code line 580

at ErrorHandler->handleError('8', 'Undefined index: category', '/home/s/ss992mhb/p_17.ss992mhb.beget.tech/public_html/vendor/prestashop/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code', '580', array('_smarty_tpl' => object(SmartyDevTemplate), '_tpl_stack' => array(), '_from' => array())) in smarty_internal_templatebase.php(157) : eval()'d code line 580

at content_5bb66d4f796ea7_82004201(object(SmartyDevTemplate)) in smarty_internal_templatebase.php line 188

at Smarty_Internal_TemplateBase->fetch('catalog/product.tpl', null, 'layouts/layout-full-width.tpl', null, false, true, false) in SmartyDev.php line 41

at SmartyDev->fetch('catalog/product.tpl', null, 'layouts/layout-full-width.tpl') in FrontController.php line 684

at FrontControllerCore->smartyOutputContent('catalog/product.tpl') in FrontController.php line 668

at FrontControllerCore->display() in Controller.php line 273

at ControllerCore->run() in Dispatcher.php line 428

at DispatcherCore->dispatch() in index.php line 28