mucide Posted September 25, 2018 Share Posted September 25, 2018 (edited) Bonjour à tous, J'ai un gros soucis sur mon BO . Je ne peux plus ajouter , modifier , dupliquer les produits. (Je suis sous presta 1.7.3.3 , j'ai tenté de mettre à jour mon prestashop avec 1-Click Upgrade mais cela bug et ne fonctionne pas, la mise à jour s'arrête en plein milieu, bref) Ce bug est survenu après m'être aventuré à vouloir ajouter un onglet de description sur la fiche produit (en vain), j'ai pourtant réinitialisé les fichiers telle qu'ils étaient avant ces modifs. Je ne sais pas si cela vient de cette manip du coup. Voici ce que le débug montre en cliquant sur "AJOUTER UN PRODUIT" Qu'en pensez vous ? Une piste ? merci infiniment pour votre aide Quote PrestaShopDatabaseException in Db.php line 746:Unknown column 'custom_field' 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`, `custom_field`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '1', NULL, '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2018-09-25 23:46:45', '2018-09-25 23:46:45', '3', '')</pre> in Db.php line 746 at 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`, `custom_field`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '1', NULL, '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2018-09-25 23:46:45', '2018-09-25 23:46:45', '3', '')') in Db.php line 378 at 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`, `custom_field`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '1', NULL, '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2018-09-25 23:46:45', '2018-09-25 23:46:45', '3', '')') in Db.php line 718 at 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`, `custom_field`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '', '0', '0', '0', '0', '1', '2', '0', '0', '0', '0', '1', NULL, '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '1', '0000-00-00', '0', 'new', '1', '0', 'both', '0', '0', '2018-09-25 23:46:45', '2018-09-25 23:46:45', '3', '')', true) in Db.php line 467 at DbCore->insert('ps_product', array(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' => '0', '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' => '0', '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-09-25 23:46:45', 'date_upd' => '2018-09-25 23:46:45', 'pack_stock_type' => '3', 'custom_field' => '')), false) in ObjectModel.php line 529 at ObjectModelCore->add(true, false) in Product.php line 596 at ProductCore->add(true, false) in ObjectModel.php line 487 at ObjectModelCore->save() in ProductController.php line 372 at ProductController->newAction() at call_user_func_array(array(object(ProductController), 'newAction'), array()) in bootstrap.php.cache line 3253 at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3212 at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3366 at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2566 at Kernel->handle(object(Request), '1', false) in index.php line 86 Expand Edited September 25, 2018 by mucide (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now