hgevet Posted March 1, 2018 Share Posted March 1, 2018 bonjour depuis la dernière mise à jour, j'ai été obligé de supprimer les caches dans app/cache (prod et dev) sinon, c'était page blanche. maintenant, j'arrive à rentrer dans le back office, mais impossible de créer un produit : la création d'un produit provoque le retour sur le tableau de bord. la mise à jour produit: je rentre mais impossible d'enregistrer, message "impossible de mettre à jour les paramètres". que faire ? merci hervé Link to comment Share on other sites More sharing options...
hgevet Posted March 2, 2018 Author Share Posted March 2, 2018 bonjour en mode debug, j'ai ca: PrestaShopDatabaseException in Db.php line 746: Unknown column 'additional_delivery_times' in 'field list'<br /><br /><pre>INSERT INTO `mod887_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', '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-03-02 17:04:12', '2018-03-02 17:04:12', '3')</pre> Link to comment Share on other sites More sharing options...
hgevet Posted March 10, 2018 Author Share Posted March 10, 2018 il a fallu passer par phpmyadmin et ajouter tous les champs 1 par 1 d Link to comment Share on other sites More sharing options...
hgevet Posted March 10, 2018 Author Share Posted March 10, 2018 il a fallu passer en mode debug, noter toutes les erreurs sur les champs manquants et passer par phpmyadmin pour les ajouter tous les champs 1 par 1 dans toutes les tables modifiées depuis l'ancienne version. fastidieux mais ca marche. hervé Link to comment Share on other sites More sharing options...
Bousquet777 Posted March 11, 2018 Share Posted March 11, 2018 (edited) Merci pour votre retour. Cela peut bien dépanner, mais ne donne pas vraiment envie de faire la maj, surtout quand on lit aussi les autres témoignages des fichiers qui ne dézippent pas etc. Si ce n'est pas indiscret, sur quel type d'hébergement/serveur êtes vous? Edited March 11, 2018 by Bousquet777 (see edit history) Link to comment Share on other sites More sharing options...
Studio Little Dreams Posted April 22, 2018 Share Posted April 22, 2018 Bonjour, je met en dispo. la requête pour remédier au problème ( 1.7.2 => 1.7.3 réussie & fonctionnelle). UPDATE `ps_tab` SET `position` = 0 WHERE `class_name` = 'AdminZones' AND `position` = '1'; UPDATE `ps_tab` SET `position` = 1 WHERE `class_name` = 'AdminCountries' AND `position` = '0'; /* PHP:ps_1730_add_quick_access_evaluation_catalog(); */; /* PHP:ps_1730_move_some_aeuc_configuration_to_core(); */; ALTER TABLE `ps_product` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`; ALTER TABLE `ps_product` ADD `additional_delivery_times` tinyint(1) unsigned NOT NULL DEFAULT '1' AFTER `out_of_stock`; ALTER TABLE `ps_product_lang` ADD `delivery_in_stock` varchar(255) DEFAULT NULL; ALTER TABLE `ps_product_lang` ADD `delivery_out_stock` varchar(255) DEFAULT NULL; ALTER TABLE `ps_product_shop` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`; ALTER TABLE `ps_product_attribute` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`; ALTER TABLE `ps_product_attribute_shop` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`; ALTER TABLE `ps_product` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`; ALTER TABLE `ps_product_shop` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`; ALTER TABLE `ps_product_attribute` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`; ALTER TABLE `ps_product_attribute_shop` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`; CREATE TABLE IF NOT EXISTS `ps_store_lang` ( `id_store` int(11) unsigned NOT NULL, `id_lang` int(11) unsigned NOT NULL, `name` varchar(255) NOT NULL, `address1` varchar(255) NOT NULL, `address2` varchar(255) DEFAULT NULL, `hours` text, `note` text, PRIMARY KEY (`id_store`, `id_lang`) ) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8; /* PHP:ps_1730_migrate_data_from_store_to_store_lang_and_clean_store(); */; ALTER TABLE `ps_store` DROP `name`, DROP `address1`, DROP `address2`, DROP `hours`, DROP `note`; ALTER TABLE `ps_feature_product` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_feature`, `id_product`, `id_feature_value`); ALTER TABLE `ps_customization_field` ADD `is_deleted` TINYINT(1) NOT NULL DEFAULT '0'; INSERT IGNORE INTO `ps_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES (NULL, 'displayAdminCustomersAddressesItemAction', 'Display new elements in the Back Office, tab AdminCustomers, Addresses actions', 'This hook launches modules when the Addresses list into the AdminCustomers tab is displayed in the Back Office', '1'), (NULL, 'displayDashboardToolbarTopMenu', 'Display new elements in back office page with a dashboard, on top Menu', 'This hook launches modules when a page with a dashboard is displayed', '1'), (NULL, 'displayDashboardToolbarIcons', 'Display new elements in back office page with dashboard, on icons list', 'This hook launches modules when the back office with dashboard is displayed', '1'); INSERT IGNORE INTO `ps_authorization_role` (`slug`) VALUES ('ROLE_MOD_TAB_DEFAULT_CREATE'), ('ROLE_MOD_TAB_DEFAULT_READ'), ('ROLE_MOD_TAB_DEFAULT_UPDATE'), ('ROLE_MOD_TAB_DEFAULT_DELETE'); Bonne journée. 1 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