franky.martin Posted November 6, 2018 Share Posted November 6, 2018 Hola, he intentado actualizar de 1.7.3.2 a 1.7.4.2 mediante el módulo 1-click upgrade y todo iba bien hasta que apareció error:Error during database upgrade. You may need to restore your database.Error upgrading Doctrine schemaPara más detalles os pego lo siguiente:Migrating old setting file...parameters file already exists!Finished... [OK] SQL 1.7.3.0 SET SESSION sql_mode = ''[OK] SQL 1.7.3.0 SET NAMES 'utf8'[OK] SQL 1.7.3.0 UPDATE `sps_tab` SET `position` = 0 WHERE `class_name` = 'AdminZones' AND `position` = '1'[OK] SQL 1.7.3.0 UPDATE `sps_tab` SET `position` = 1 WHERE `class_name` = 'AdminCountries' AND `position` = '0'[OK] PHP 1.7.3.0 : /* PHP:ps_1730_add_quick_access_evaluation_catalog(); */[OK] PHP 1.7.3.0 : /* PHP:ps_1730_move_some_aeuc_configuration_to_core(); */[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`: Duplicate column name 'low_stock_threshold'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product` ADD `additional_delivery_times` tinyint(1) unsigned NOT NULL DEFAULT '1' AFTER `out_of_stock`: Duplicate column name 'additional_delivery_times'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_lang` ADD `delivery_in_stock` varchar(255) DEFAULT NULL: Duplicate column name 'delivery_in_stock'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_lang` ADD `delivery_out_stock` varchar(255) DEFAULT NULL: Duplicate column name 'delivery_out_stock'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_shop` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`: Duplicate column name 'low_stock_threshold'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_attribute` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`: Duplicate column name 'low_stock_threshold'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_attribute_shop` ADD `low_stock_threshold` INT(10) NULL DEFAULT NULL AFTER `minimal_quantity`: Duplicate column name 'low_stock_threshold'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`: Duplicate column name 'low_stock_alert'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_shop` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`: Duplicate column name 'low_stock_alert'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_attribute` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`: Duplicate column name 'low_stock_alert'[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_product_attribute_shop` ADD `low_stock_alert` TINYINT(1) NOT NULL DEFAULT 0 AFTER `low_stock_threshold`: Duplicate column name 'low_stock_alert'[DROP] SQL `sps_store_lang` table has been dropped.[OK] SQL 1.7.3.0 CREATE TABLE IF NOT EXISTS `sps_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=InnoDB DEFAULT CHARSET=utf8[OK] PHP 1.7.3.0 : /* PHP:ps_1730_migrate_data_from_store_to_store_lang_and_clean_store(); */[WARNING] SQL 1.7.3.0 1091 in ALTER TABLE `sps_store` DROP `name`, DROP `address1`, DROP `address2`, DROP `hours`, DROP `note`: Can't DROP 'name'; check that column/key exists[OK] SQL 1.7.3.0 ALTER TABLE `sps_feature_product` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_feature`, `id_product`, `id_feature_value`)[WARNING] SQL 1.7.3.0 1060 in ALTER TABLE `sps_customization_field` ADD `is_deleted` TINYINT(1) NOT NULL DEFAULT '0': Duplicate column name 'is_deleted'[OK] SQL 1.7.3.0 INSERT IGNORE INTO `sps_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')[OK] SQL 1.7.3.0 INSERT IGNORE INTO `sps_authorization_role` (`slug`) VALUES ('ROLE_MOD_TAB_DEFAULT_CREATE'), ('ROLE_MOD_TAB_DEFAULT_READ'), ('ROLE_MOD_TAB_DEFAULT_UPDATE'), ('ROLE_MOD_TAB_DEFAULT_DELETE')[OK] SQL 1.7.4.0 SET SESSION sql_mode = ''[OK] SQL 1.7.4.0 SET NAMES 'utf8'[OK] SQL 1.7.4.0 ALTER TABLE `sps_order_detail` DROP KEY product_id, ADD KEY product_id (product_id, product_attribute_id)[OK] SQL 1.7.4.0 INSERT IGNORE INTO `sps_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES (NULL, 'actionAdministrationPageForm', 'Manage Administration Page form fields', 'This hook adds, update or remove fields of the Administration Page form', '1'), (NULL, 'actionAdministrationPageFormSave', 'Processing Administration page form', 'This hook is called when the Administration Page form is processed', '1'), (NULL, 'actionPerformancePageForm', 'Manage Performance Page form fields', 'This hook adds, update or remove fields of the Performance Page form', '1'), (NULL, 'actionPerformancePageFormSave', 'Processing Performance page form', 'This hook is called when the Performance Page form is processed', '1'), (NULL, 'actionMaintenancePageForm', 'Manage Maintenance Page form fields', 'This hook adds, update or remove fields of the Maintenance Page form', '1'), (NULL, 'actionMaintenancePageFormSave', 'Processing Maintenance page form', 'This hook is called when the Maintenance Page form is processed', '1'), (NULL, 'displayAdminEndContent', 'Administration end of content', 'This hook is displayed at the end of the main content, before the footer', '1')[OK] PHP 1.7.4.0 : /* PHP:ps_1740_update_module_tabs(); */[OK] SQL 1.7.4.1 SET SESSION sql_mode = ''[OK] SQL 1.7.4.1 SET NAMES 'utf8'[OK] SQL 1.7.4.1 ALTER TABLE `sps_cart_rule` ADD KEY `date_from` (`date_from`), ADD KEY `date_to` (`date_to`)[OK] SQL 1.7.4.2 SET SESSION sql_mode = ''[OK] SQL 1.7.4.2 SET NAMES 'utf8'[OK] SQL 1.7.4.2 UPDATE `sps_employee` SET `bo_css` = "theme.css"Updating database schema...16:32:27 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign". Message: "Unknown database type bit requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it." ["exception" => Doctrine\DBAL\DBALException { …},"command" => "prestashop:schema:update-without-foreign","message" => "Unknown database type bit requested, Doctrine\DBAL\Platforms\MySqlPlatform may not support it."] []In AbstractPlatform.php line 423:Unknown database type bit requested, Doctrine\DBAL\Platforms\MySqlPlatformmay not support it.prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--] Link to comment Share on other sites More sharing options...
franky.martin Posted November 6, 2018 Author Share Posted November 6, 2018 He encontrado algo de información en el foro https://www.prestashop.com/forums/topic/873841-actualización-con-1-click-upgrade-desde-17-a-1742/ 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