Jump to content
mucide

Création / modification Produit impossible

Recommended Posts

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>

  1. in Db.php line 746
  2. 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
  3. 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
  4. 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
  5. 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
  6. at ObjectModelCore->add(true, false) in Product.php line 596
  7. at ProductCore->add(true, false) in ObjectModel.php line 487
  8. at ObjectModelCore->save() in ProductController.php line 372
  9. at ProductController->newAction()
  10. at call_user_func_array(array(object(ProductController), 'newAction'), array()) in bootstrap.php.cache line 3253
  11. at HttpKernel->handleRaw(object(Request), '1') in bootstrap.php.cache line 3212
  12. at HttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 3366
  13. at ContainerAwareHttpKernel->handle(object(Request), '1', false) in bootstrap.php.cache line 2566
  14. at Kernel->handle(object(Request), '1', false) in index.php line 86

 

Edited by mucide (see edit history)

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

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