Jump to content

Mise à jour 1.7.3 => 1.7.5 (accès BO interdit et en anglais)

dieuduciel
 Share

Recommended Posts

dieuduciel Newbie

dieuduciel

Posted
Posted

Bonjour,

J'ai essayé de mettre à jour mon prestashop 1.7.3 vers la version 1.7.5
Serveur LightSpeed (PHP 7.0)
La mise à jour se fait, avec quelques Warnings et l'erreur suivante :
[INTERNAL] /home/xxxxx/public_html/xxxx/autoupgrade/latest/install/upgrade/php/ps1700_stores.php line 35 - Invalid argument supplied for foreach()
[OK] PHP 1.7.0.0 : /* PHP:ps1700_stores(); */

Lorsque je me reconnecte au Back office après la mise à jour, j'arrive sur l'accès du backoffce mais en anglais (alors que mon store est configuré en Français) et avec l'impossibilité d'accéder aux items (j'ai accès interdit en rouge) partout...

Avez-vous des idées sur la provenance de cette erreur.
Voici le log de la mise à jour : 

Migrating old setting file...
parameters file already exists!
Finished...
[OK] SQL 1.7.0.0 SET NAMES 'utf8'
[OK] SQL 1.7.0.0 INSERT INTO `rcso_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_SMARTY_LOCAL', '0', NOW(), NOW()), ('PS_PASSWD_RESET_VALIDITY', '1440', NOW(), NOW()), ('PS_CUSTOMER_BIRTHDATE', '1', NOW(), NOW()), ('PS_ACTIVE_CRONJOB_EXCHANGE_RATE', '0', NOW(), NOW()), ('PS_ORDER_RECALCULATE_SHIPPING', '1', NOW(), NOW()), ('PS_MAINTENANCE_TEXT', 'We are currently updating our shop and will be back really soon.<br>Thanks for your patience.', NOW(), NOW())
[WARNING] SQL 1.7.0.0 1062 in INSERT INTO `rcso_configuration_lang` (`id_configuration`, `id_lang`, `value`, `date_upd`) SELECT c.`id_configuration`, l.`id_lang`, c.`value`, NOW() FROM `rcso_configuration` c, `rcso_lang` l WHERE c.`name` = 'PS_MAINTENANCE_TEXT': Duplicate entry '1160-5' for key 'PRIMARY'
[WARNING] SQL 1.7.0.0 1062 in INSERT INTO `rcso_hook_alias` (`name`, `alias`) VALUES ('actionCartUpdateQuantityBefore', 'actionBeforeCartUpdateQty'), ('actionAjaxDieBefore', 'actionBeforeAjaxDie'), ('actionAuthenticationBefore', 'actionBeforeAuthentication'), ('actionSubmitAccountBefore', 'actionBeforeSubmitAccount'), ('actionDeleteProductInCartAfter', 'actionAfterDeleteProductInCart'): Duplicate entry 'actionBeforeCartUpdateQty' for key 'alias'
[WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `rcso_currency` DROP `iso_code_num` , DROP `sign` , DROP `blank` , DROP `format` , DROP `decimals`: Can't DROP 'iso_code_num'; check that column/key exists
[WARNING] SQL 1.7.0.0 1060 in /* Password reset token for new "Forgot my password screen */ ALTER TABLE `rcso_customer` ADD `reset_password_token` varchar(40) DEFAULT NULL: Duplicate column name 'reset_password_token'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_customer` ADD `reset_password_validity` datetime DEFAULT NULL: Duplicate column name 'reset_password_validity'
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_employee` CHANGE `last_connection_date` `last_connection_date` DATE NULL DEFAULT NULL
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_employee` ADD `reset_password_token` varchar(40) DEFAULT NULL: Duplicate column name 'reset_password_token'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_employee` ADD `reset_password_validity` datetime DEFAULT NULL: Duplicate column name 'reset_password_validity'
[OK] SQL 1.7.0.0 /* Need to set the date to null before manipulate the table if the strict mode is enabled on MySQL */ UPDATE `rcso_customer` SET `newsletter_date_add` = NULL WHERE YEAR(newsletter_date_add) = "0000"
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_customer` CHANGE COLUMN `passwd` `passwd` varchar(60) NOT NULL
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_employee` CHANGE COLUMN `passwd` `passwd` varchar(60) NOT NULL
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_customer` CHANGE COLUMN `firstname` `firstname` varchar(255) NOT NULL
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_customer` CHANGE COLUMN `lastname` `lastname` varchar(255) NOT NULL
[WARNING] SQL 1.7.0.0 1061 in /* Changes regarding modules */ ALTER TABLE `rcso_module` ADD UNIQUE INDEX `name_UNIQUE` (`name` ASC): Duplicate key name 'name_UNIQUE'
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_modules_perfs`
[DROP] SQL `rcso_module_carrier` table has been dropped.
[OK] SQL 1.7.0.0 CREATE TABLE `rcso_module_carrier` ( `id_module`INT(10) unsigned NOT NULL, `id_shop`INT(11) unsigned NOT NULL DEFAULT '1', `id_reference` INT(11) NOT NULL, PRIMARY KEY (`id_module`,`id_shop`, `id_reference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
[OK] PHP 1.7.0.0 : /* PHP:select_current_payment_modules(); */
[OK] PHP 1.7.0.0 : /* Add Payment Preferences tab. SuperAdmin profile is the only one to access it. */ /* PHP:ps_1700_add_payment_preferences_tab(); */
[WARNING] SQL 1.7.0.0 1054 in UPDATE `rcso_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `rcso_tab` t WHERE t.`class_name` = 'AdminPaymentPreferences' LIMIT 1) AND `id_profile` > 1: Unknown column 'id_tab' in 'where clause'
[OK] SQL 1.7.0.0 UPDATE `rcso_quick_access` SET `link` = "index.php/product/new" WHERE `link` = "index.php?controller=AdminProducts&addproduct"
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_product` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_product` ADD `show_condition` TINYINT(1) NOT NULL DEFAULT '0' AFTER `available_date`: Duplicate column name 'show_condition'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_product` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn'
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_product_shop` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_product_shop` ADD `show_condition` TINYINT(1) NOT NULL DEFAULT '0' AFTER `available_date`: Duplicate column name 'show_condition'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_order_detail` ADD `product_isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'product_isbn'
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_product_attribute` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_product_attribute` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn'
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_product_attribute_shop` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_stock` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_supply_order_detail` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn'
[WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `rcso_order_invoice` DROP COLUMN `invoice_address`, DROP COLUMN `delivery_address`: Can't DROP 'invoice_address'; check that column/key exists
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_cart_product` CHANGE `id_product_attribute` `id_product_attribute` int(10) unsigned DEFAULT '0'
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_product_lang` ADD `social_sharing_title` VARCHAR( 255 ) NOT NULL
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_product_lang` ADD `social_sharing_description` VARCHAR( 255 ) NOT NULL
[INTERNAL] /home/xxxxx/public_html/xxxx/autoupgrade/latest/install/upgrade/php/ps1700_stores.php line 35 - Invalid argument supplied for foreach()
[OK] PHP 1.7.0.0 : /* PHP:ps1700_stores(); */
[WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `rcso_hook` DROP `live_edit`: Can't DROP 'live_edit'; check that column/key exists
[OK] SQL 1.7.0.0 /* Remove comparator feature */ DELETE FROM `rcso_hook_alias` WHERE `name` = 'displayProductComparison'
[OK] SQL 1.7.0.0 DELETE FROM `rcso_hook` WHERE `name` = 'displayProductComparison'
[OK] SQL 1.7.0.0 DELETE FROM `rcso_meta` WHERE `page` = 'products-comparison'
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_compare`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_compare_product`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_theme`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_theme_meta`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_theme_specific`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_scene`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_scene_category`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_scene_lang`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_scene_products`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_scene_shop`
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_shop` ADD COLUMN `theme_name` VARCHAR(255) AFTER `id_category`: Duplicate column name 'theme_name'
[OK] SQL 1.7.0.0 UPDATE `rcso_shop` SET `theme_name` = 'classic'
[OK] SQL 1.7.0.0 UPDATE `rcso_configuration` SET value=0 WHERE name='PS_TAX_DISPLAY'
[WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `rcso_image_type` DROP `scenes`: Can't DROP 'scenes'; check that column/key exists
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_cart` ADD `checkout_session_data` MEDIUMTEXT NULL: Duplicate column name 'checkout_session_data'
[WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `rcso_shop` DROP COLUMN `id_theme`: Can't DROP 'id_theme'; check that column/key exists
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_cart_product` ADD `id_customization` INT(10) NOT NULL DEFAULT '0' AFTER `id_product_attribute`: Duplicate column name 'id_customization'
[OK] SQL 1.7.0.0 ALTER TABLE `rcso_cart_product` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cart`, `id_product`, `id_product_attribute`, `id_customization`, `id_address_delivery`)
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_order_detail` ADD `id_customization` INT(10) NULL DEFAULT '0' AFTER `product_attribute_id`: Duplicate column name 'id_customization'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_customized_data` ADD `id_module` INT(10) NOT NULL DEFAULT '0', ADD `price` DECIMAL(20,6) NOT NULL DEFAULT '0', ADD `weight` DECIMAL(20,6) NOT NULL DEFAULT '0': Duplicate column name 'id_module'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_customization_field` ADD `is_module` TINYINT(1) NOT NULL DEFAULT '0': Duplicate column name 'is_module'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_cart_rule` ADD `reduction_exclude_special` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `reduction_percent`: Duplicate column name 'reduction_exclude_special'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_product` ADD `state` INT UNSIGNED NOT NULL DEFAULT '1': Duplicate column name 'state'
[WARNING] SQL 1.7.0.0 1061 in ALTER TABLE `rcso_product` ADD KEY `state` (`state`, `date_upd`): Duplicate key name 'state'
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_lang` ADD `locale` varchar(5) COLLATE utf8_unicode_ci NOT NULL: Duplicate column name 'locale'
[OK] PHP 1.7.0.0 : /* PHP:ps_1700_add_locale(); */
[DROP] SQL `rcso_authorization_role` table has been dropped.
[OK] SQL 1.7.0.0 /* Right management */ CREATE TABLE `rcso_authorization_role` ( `id_authorization_role` int(10) unsigned NOT NULL auto_increment, `slug` VARCHAR(255) NOT NULL, PRIMARY KEY (`id_authorization_role`), UNIQUE KEY (`slug`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
[WARNING] SQL 1.7.0.0 1050 in /* Create a copy without indexes to make ID updates without conflict. */ CREATE TABLE `rcso_access_old` AS SELECT * FROM `rcso_access`: Table 'rcso_access_old' already exists
[OK] SQL 1.7.0.0 DROP TABLE `rcso_access`
[WARNING] SQL 1.7.0.0 1050 in RENAME TABLE `rcso_module_access` TO `rcso_module_access_old`: Table 'rcso_module_access_old' already exists
[DROP] SQL `rcso_tab_transit` table has been dropped.
[OK] SQL 1.7.0.0 CREATE TABLE `rcso_tab_transit` ( `id_old_tab` int(11), `id_new_tab` int(11), `key` VARCHAR(128) /* class_name and module concatenation */ ) ENGINE=InnoDB DEFAULT CHARSET=utf8
[OK] SQL 1.7.0.0 /* Save the old IDs */ INSERT INTO `rcso_tab_transit` (`id_old_tab`, `key`) SELECT `id_tab`, CONCAT(`class_name`, COALESCE(`module`, '')) FROM `rcso_tab`
[DROP] SQL `rcso_access` table has been dropped.
[OK] SQL 1.7.0.0 CREATE TABLE `rcso_access` ( `id_profile` int(10) unsigned NOT NULL, `id_authorization_role` int(10) unsigned NOT NULL, PRIMARY KEY (`id_profile`,`id_authorization_role`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
[DROP] SQL `rcso_module_access` table has been dropped.
[OK] SQL 1.7.0.0 CREATE TABLE `rcso_module_access` ( `id_profile` int(10) unsigned NOT NULL, `id_authorization_role` int(10) unsigned NOT NULL, PRIMARY KEY (`id_profile`,`id_authorization_role`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
[OK] PHP 1.7.0.0 : /* PHP:add_quick_access_tab(); */
[WARNING] SQL 1.7.0.0 1062 in INSERT INTO `rcso_hook` (`name`, `title`, `description`, `position`) VALUES ('actionValidateCustomerAddressForm', 'Customer address form validation', 'This hook is called when a customer submit its address form', '1'), ('displayAfterCarrier', 'After carriers list', 'This hook is displayed after the carrier list in Front Office', '1'), ('displayCarrierExtraContent', 'Display additional content for a carrier (e.g pickup points)', 'This hook calls only the module related to the carrier, in order to add options when needed.', '1'), ('validateCustomerFormFields', 'Customer registration form validation', 'This hook is called to a module when it has sent additional fields with additionalCustomerFormFields', '1'), ('displayProductExtraContent', 'Display extra content on the product page', 'This hook expects ProductExtraContent instances, which will be properly displayed by the template on the product page.', '1'), ('displayNavFullWidth', 'Navigation', 'This hook displays full width navigation menu at the top of your pages', '1'), ('displayAfterBodyOpeningTag', 'Very top of pages', 'Use this hook for advertisement or modals you want to load first.', '1'), ('displayBeforeBodyClosingTag', 'Very bottom of pages', 'Use this hook for your modals or any content you want to load at the very end.', '1'): Duplicate entry 'actionValidateCustomerAddressForm' for key 'hook_name'
[OK] SQL 1.7.0.0 DELETE FROM `rcso_hook` WHERE `name` IN ( 'displayProductTab', 'displayProductTabContent', 'displayBeforePayment', 'actionBeforeAuthentication', 'actionOrderDetail', 'actionProductListOverride', 'actionSearch', 'displayCustomerIdentityForm', 'displayHomeTab', 'displayHomeTabContent', 'displayPayment')
[OK] SQL 1.7.0.0 DELETE FROM `rcso_hook_alias` WHERE `name` IN ( 'beforeAuthentication', 'displayProductTab', 'displayProductTabContent', 'displayBeforePayment', 'orderDetail', 'payment', 'productListAssign', 'search')
[OK] SQL 1.7.0.0 DELETE FROM `rcso_configuration` WHERE `name` IN ( '_MEDIA_SERVER_2_', '_MEDIA_SERVER_3_', 'PS_ORDER_PROCESS_TYPE', 'PS_ADVANCED_PAYMENT_API', 'PS_ONE_PHONE_AT_LEAST', 'PS_SCENE_FEATURE_ACTIVE', 'PS_ADMINREFRESH_NOTIFICATION', 'PS_CUSTOMER_NWSL', 'PS_CACHEFS_DIRECTORY_DEPTH', 'PS_CART_REDIRECT', 'PS_COMPARATOR_MAX_ITEM', 'PS_STORES_DISPLAY_FOOTER', 'PS_STORES_SIMPLIFIED', 'PS_STORES_CENTER_LAT', 'PS_STORES_CENTER_LONG', 'PS_STORES_DISPLAY_SITEMAP', 'PS_CIPHER_ALGORITHM', 'PS_HTML_THEME_COMPRESSION', 'PS_JS_HTML_THEME_COMPRESSION', 'PS_LOGO_MOBILE', 'SHOP_LOGO_MOBILE_HEIGHT', 'SHOP_LOGO_MOBILE_WIDTH')
[WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `rcso_tab` ADD `icon` varchar(32) DEFAULT '': Duplicate column name 'icon'
[OK] PHP 1.7.0.0 : /* PHP:migrate_tabs_17(); */
[OK] SQL 1.7.0.0 /* Save the new IDs */ UPDATE `rcso_tab_transit` tt SET `id_new_tab` = ( SELECT `id_tab` FROM `rcso_tab` WHERE CONCAT(`class_name`, COALESCE(`module`, '')) = tt.`key` LIMIT 1 )
[OK] SQL 1.7.0.0 /* Update default tab IDs for employees */ UPDATE `rcso_employee` e SET `default_tab` = ( SELECT IFNULL(`id_new_tab`, /* If the tab does not exist anymore, fallback to the dashboard. */ (SELECT `id_tab` FROM `rcso_tab` WHERE `class_name` = 'AdminDashboard' AND `module` IS NULL) ) FROM `rcso_tab_transit` WHERE `id_old_tab` = e.`default_tab` )
[WARNING] SQL 1.7.0.0 1054 in /* Update access tab IDs */ UPDATE `rcso_access_old` ao SET `id_tab` = ( /* Update tab ID if possible, leave as is if the tab does not exist anymore */ SELECT IFNULL(`id_new_tab`, ao.`id_tab`) FROM `rcso_tab_transit` WHERE `id_old_tab` = ao.`id_tab` ): Unknown column 'id_tab' in 'field list'
[OK] PHP 1.7.0.0 : /* Properly migrate the rights associated with each tabs */ /* PHP:ps_1700_right_management(); */
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_access_old`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_module_access_old`
[OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `rcso_tab_transit`
[OK] PHP 1.7.0.5 : /* PHP:ps_update_tabs(); */
[OK] SQL 1.7.0.5 ALTER TABLE `rcso_currency` MODIFY `name` varchar(64) NOT NULL
[OK] SQL 1.7.1.0 SET SESSION sql_mode = ''
[OK] SQL 1.7.1.0 SET NAMES 'utf8'
[OK] SQL 1.7.1.0 UPDATE `rcso_address_format` SET `format` = 'firstname lastname company vat_number address1 address2 city postcode State:name Country:name phone' WHERE `id_country` = (SELECT `id_country` FROM `rcso_country` WHERE `iso_code` = 'IN')
[OK] SQL 1.7.1.0 UPDATE `rcso_hook` SET `name` = 'displayProductAdditionalInfo' WHERE `name` = 'displayProductButtons'
[WARNING] SQL 1.7.1.0 1062 in INSERT INTO `rcso_hook_alias` (`name`, `alias`) VALUES ('displayProductAdditionalInfo', 'displayProductButtons'): Duplicate entry 'displayProductButtons' for key 'alias'
[OK] SQL 1.7.1.0 -- Need old value before updating ALTER TABLE `rcso_product` CHANGE `redirect_type` `redirect_type` ENUM('','404', '301', '302', '301-product','302-product','301-category','302-category') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_product_shop` CHANGE `redirect_type` `redirect_type` ENUM('','404', '301', '302', '301-product','302-product','301-category','302-category') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
[OK] SQL 1.7.1.0 UPDATE `rcso_product` SET redirect_type = '301-product' WHERE redirect_type = '301'
[OK] SQL 1.7.1.0 UPDATE `rcso_product` SET redirect_type = '302-product' WHERE redirect_type = '302'
[OK] SQL 1.7.1.0 UPDATE `rcso_product_shop` SET redirect_type = '301-product' WHERE redirect_type = '301'
[OK] SQL 1.7.1.0 UPDATE `rcso_product_shop` SET redirect_type = '302-product' WHERE redirect_type = '302'
[OK] SQL 1.7.1.0 -- Can now remove old value ALTER TABLE `rcso_product` CHANGE `redirect_type` `redirect_type` ENUM('','404','301-product','302-product','301-category','302-category') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_product_shop` CHANGE `redirect_type` `redirect_type` ENUM('','404','301-product','302-product','301-category','302-category') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
[WARNING] SQL 1.7.1.0 1054 in ALTER TABLE `rcso_product` CHANGE `id_product_redirected` `id_type_redirected` INT(10) NOT NULL DEFAULT '0': Unknown column 'id_product_redirected' in 'rcso_product'
[WARNING] SQL 1.7.1.0 1054 in ALTER TABLE `rcso_product_shop` CHANGE `id_product_redirected` `id_type_redirected` INT(10) NOT NULL DEFAULT '0': Unknown column 'id_product_redirected' in 'rcso_product_shop'
[OK] SQL 1.7.1.0 INSERT IGNORE INTO `rcso_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES (NULL, 'filterCmsContent', 'Filter the content page', 'This hook is called just before fetching content page', '1'), (NULL, 'filterCmsCategoryContent', 'Filter the content page category', 'This hook is called just before fetching content page category', '1'), (NULL, 'filterProductContent', 'Filter the content page product', 'This hook is called just before fetching content page product', '1'), (NULL, 'filterCategoryContent', 'Filter the content page category', 'This hook is called just before fetching content page category', '1'), (NULL, 'filterManufacturerContent', 'Filter the content page manufacturer', 'This hook is called just before fetching content page manufacturer', '1'), (NULL, 'filterSupplierContent', 'Filter the content page supplier', 'This hook is called just before fetching content page supplier', '1'), (NULL, 'filterHtmlContent', 'Filter HTML field before rending a page', 'This hook is called just before fetching a page on HTML field', '1'), (NULL, 'displayDashboardTop', 'Dashboard Top', 'Displays the content in the dashboard''s top area', '1'), (NULL, 'actionObjectProductInCartDeleteBefore', 'Cart product removal', 'This hook is called before a product is removed from a cart', '1'), (NULL, 'actionObjectProductInCartDeleteAfter', 'Cart product removal', 'This hook is called after a product is removed from a cart', '1'), (NULL, 'actionUpdateLangAfter', 'Update "lang" tables', 'Update "lang" tables after adding or updating a language', '1'), (NULL, 'actionOutputHTMLBefore', 'Filter the whole HTML page', 'This hook is used to filter the whole HTML page before it is rendered (only front)', '1'), (NULL, 'displayAfterProductThumbs', 'Display extra content below product thumbs', 'This hook displays new elements below product images ex. additional media', '1'), (NULL, 'actionDispatcherBefore', 'Before dispatch', 'This hook is called at the beginning of the dispatch method of the Dispatcher', '1'), (NULL, 'actionDispatcherAfter', 'After dispatch', 'This hook is called at the end of the dispatch method of the Dispatcher', '1'), (NULL, 'actionClearCache', 'Clear smarty cache', 'This hook is called when the cache of the theme is cleared', '1'), (NULL, 'actionClearCompileCache', 'Clear smarty compile cache', 'This hook is called when smarty''s compile cache is cleared', '1'), (NULL, 'actionClearSf2Cache', 'Clear Sf2 cache', 'This hook is called when the Symfony cache is cleared', '1'), (NULL, 'filterProductSearch', 'Filter search products result', 'This hook is called in order to allow to modify search product result', '1'), (NULL, 'actionProductSearchAfter', 'Event triggered after search product completed', 'This hook is called after the product search. Parameters are already filtered', '1'), (NULL, 'actionEmailSendBefore', 'Before sending an email', 'This hook is used to filter the content or the metadata of an email before sending it or even prevent its sending', '1'), (NULL, 'displayProductPageDrawer', 'Product Page Drawer', 'This hook displays content in the right sidebar of the product page', '1')
[OK] SQL 1.7.1.0 DELETE FROM `rcso_configuration` WHERE `name` IN ('PS_META_KEYWORDS')
[OK] SQL 1.7.1.0 INSERT INTO `rcso_operating_system` (`name`) VALUES ('Windows 8.1'), ('Windows 10')
[OK] SQL 1.7.1.0 /* UPDATE TO DOCTRINE */ ALTER TABLE `rcso_attribute` CHANGE `id_attribute` `id_attribute` INT(11) NOT NULL AUTO_INCREMENT
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_group` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL AUTO_INCREMENT
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_group_lang` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_group_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_group_shop` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_group_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_lang` CHANGE `id_attribute` `id_attribute` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_shop` CHANGE `id_attribute` `id_attribute` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_attribute_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL AUTO_INCREMENT
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_lang_shop` CHANGE `id_lang` `id_lang` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_lang_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL AUTO_INCREMENT
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_shop` CHANGE `id_shop_group` `id_shop_group` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_shop_group` CHANGE `id_shop_group` `id_shop_group` INT(11) NOT NULL AUTO_INCREMENT
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_tab` CHANGE `id_tab` `id_tab` INT(11) NOT NULL AUTO_INCREMENT
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_tab_lang` CHANGE `id_tab` `id_tab` INT(11) NOT NULL
[OK] SQL 1.7.1.0 ALTER TABLE `rcso_tab_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL
[OK] SQL 1.7.1.1 SET NAMES 'utf8'
[OK] SQL 1.7.1.1 ALTER TABLE `rcso_address` CHANGE `company` `company` VARCHAR(255) DEFAULT NULL
[OK] SQL 1.7.2.0 SET SESSION sql_mode = ''
[OK] SQL 1.7.2.0 SET NAMES 'utf8'
[WARNING] SQL 1.7.2.0 1054 in ALTER TABLE `rcso_store` MODIFY `hours` text: Unknown column 'hours' in 'rcso_store'
[OK] SQL 1.7.2.0 INSERT IGNORE INTO `rcso_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES (NULL, 'displayAdminProductsMainStepLeftColumnMiddle', 'Display new elements in back office product page, left column of the Basic settings tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsMainStepLeftColumnBottom', 'Display new elements in back office product page, left column of the Basic settings tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsMainStepRightColumnBottom', 'Display new elements in back office product page, right column of the Basic settings tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsQuantitiesStepBottom', 'Display new elements in back office product page, Quantities/Combinations tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsPriceStepBottom', 'Display new elements in back office product page, Price tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsOptionsStepTop', 'Display new elements in back office product page, Options tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsOptionsStepBottom', 'Display new elements in back office product page, Options tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsSeoStepBottom', 'Display new elements in back office product page, SEO tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsShippingStepBottom', 'Display new elements in back office product page, Shipping tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayAdminProductsCombinationBottom', 'Display new elements in back office product page, Combination tab', 'This hook launches modules when the back office product page is displayed', '1'), (NULL, 'displayWrapperTop', 'Main wrapper section (top)', 'This hook displays new elements in the top of the main wrapper', '1'), (NULL, 'displayWrapperBottom', 'Main wrapper section (bottom)', 'This hook displays new elements in the bottom of the main wrapper', '1'), (NULL, 'displayContentWrapperTop', 'Content wrapper section (top)', 'This hook displays new elements in the top of the content wrapper', '1'), (NULL, 'displayContentWrapperBottom', 'Content wrapper section (bottom)', 'This hook displays new elements in the bottom of the content wrapper', '1')
[OK] PHP 1.7.2.0 : /* PHP:drop_column_from_product_lang_if_exists(); */
[OK] SQL 1.7.2.0 ALTER TABLE `rcso_product` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL
[OK] SQL 1.7.2.0 ALTER TABLE `rcso_order_detail` CHANGE `product_isbn` `product_isbn` VARCHAR(32) NULL DEFAULT NULL
[OK] SQL 1.7.2.0 ALTER TABLE `rcso_product_attribute` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL
[OK] SQL 1.7.2.0 ALTER TABLE `rcso_stock` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL
[OK] SQL 1.7.2.0 ALTER TABLE `rcso_supply_order_detail` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL
[WARNING] SQL 1.7.2.0 1060 in ALTER TABLE `rcso_stock_available` ADD `physical_quantity` INT NOT NULL DEFAULT '0' AFTER `quantity`: Duplicate column name 'physical_quantity'
[WARNING] SQL 1.7.2.0 1060 in ALTER TABLE `rcso_stock_available` ADD `reserved_quantity` INT NOT NULL DEFAULT '0' AFTER `physical_quantity`: Duplicate column name 'reserved_quantity'
[OK] SQL 1.7.2.0 ALTER TABLE `rcso_stock_mvt` CHANGE `id_stock` `id_stock` INT(11) UNSIGNED NOT NULL COMMENT 'since ps 1.7 corresponding to id_stock_available'
[OK] SQL 1.7.2.0 UPDATE `rcso_configuration` SET `value` = 0 WHERE `name` = "PS_ADVANCED_STOCK_MANAGEMENT"
[OK] PHP 1.7.2.0 : /* PHP:add_new_status_stock(); */
[OK] SQL 1.7.2.1 SET SESSION sql_mode = ''
[OK] SQL 1.7.2.1 SET NAMES 'utf8'
[OK] SQL 1.7.2.1 ALTER TABLE `rcso_search_index` DROP KEY `id_product`
[OK] SQL 1.7.2.1 ALTER TABLE `rcso_search_index` ADD KEY `id_product` (`id_product`,`weight`)
[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 `rcso_tab` SET `position` = 0 WHERE `class_name` = 'AdminZones' AND `position` = '1'
[OK] SQL 1.7.3.0 UPDATE `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_store_lang` table has been dropped.
[OK] SQL 1.7.3.0 CREATE TABLE IF NOT EXISTS `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_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 `rcso_order_detail` DROP KEY product_id, ADD KEY product_id (product_id, product_attribute_id)
[OK] SQL 1.7.4.0 INSERT IGNORE INTO `rcso_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 `rcso_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 `rcso_employee` SET `bo_css` = "theme.css"
[OK] SQL 1.7.5.0 SET SESSION sql_mode=''
[OK] SQL 1.7.5.0 SET NAMES 'utf8'
[OK] PHP 1.7.5.0 : /* PHP:add_supplier_manufacturer_routes(); */
[OK] PHP 1.7.5.0 : /* PHP:ps_1750_update_module_tabs(); */
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_cms_lang` ADD `head_seo_title` varchar(255) DEFAULT NULL AFTER `meta_title`, CHANGE `meta_title` `meta_title` VARCHAR(255) NOT NULL, CHANGE `meta_description` `meta_description` VARCHAR(512) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_stock_available` ADD `location` VARCHAR(255) NOT NULL DEFAULT '' AFTER `out_of_stock`
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_store` CHANGE `email` `email` VARCHAR(255) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_contact` CHANGE `email` `email` VARCHAR(255) NOT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_contact_lang` CHANGE `name` `name` varchar(255) NOT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_category_lang` CHANGE `meta_title` `meta_title` VARCHAR(255) DEFAULT NULL, CHANGE `meta_description` `meta_description` VARCHAR(512) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_cms_category_lang` CHANGE `meta_title` `meta_title` VARCHAR(255) DEFAULT NULL, CHANGE `meta_description` `meta_description` VARCHAR(512) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_customer` CHANGE `company` `company` VARCHAR(255), CHANGE `email` `email` VARCHAR(255) NOT NULL, CHANGE `passwd` `passwd` VARCHAR(255) NOT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_manufacturer_lang` CHANGE `meta_title` `meta_title` VARCHAR(255) NOT NULL, CHANGE `meta_description` `meta_description` VARCHAR(512) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_employee` CHANGE `firstname` `firstname` VARCHAR(255) NOT NULL, CHANGE `email` `email` VARCHAR(255) NOT NULL, CHANGE `passwd` `passwd` VARCHAR(255) NOT NULL, CHANGE `lastname` `lastname` VARCHAR(255) NOT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_referrer` CHANGE `passwd` `passwd` VARCHAR(255) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_supply_order_history` CHANGE `employee_lastname` `employee_lastname` VARCHAR(255) DEFAULT '', CHANGE `employee_firstname` `employee_firstname` VARCHAR(255) DEFAULT ''
[WARNING] SQL 1.7.5.0 1060 in ALTER TABLE `rcso_supply_order_receipt_history` CHANGE `employee_firstname` `employee_firstname` VARCHAR(255) DEFAULT '', CHANGE `employee_lastname` `employee_firstname` VARCHAR(255) DEFAULT '': Duplicate column name 'employee_firstname'
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_supplier_lang` CHANGE `meta_description` `meta_description` VARCHAR(512) DEFAULT NULL, CHANGE `meta_title` `meta_title` VARCHAR(255) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_order_detail` CHANGE `product_reference` `product_reference` varchar(64) DEFAULT NULL
[WARNING] SQL 1.7.5.0 1060 in ALTER TABLE `rcso_product` CHANGE `reference` `supplier_reference` varchar(64) DEFAULT NULL, CHANGE `supplier_reference` `supplier_reference` varchar(64) DEFAULT NULL: Duplicate column name 'supplier_reference'
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_product_attribute` CHANGE `reference` `reference` varchar(64) DEFAULT NULL, CHANGE `supplier_reference` `supplier_reference` varchar(64) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_warehouse` CHANGE `reference` `reference` varchar(64) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_stock` CHANGE `reference` `reference` varchar(64) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_supply_order_detail` CHANGE `reference` `reference` varchar(64) NOT NULL, CHANGE `supplier_reference` `supplier_reference` varchar(64) NOT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_product_supplier` CHANGE `product_supplier_reference` `product_supplier_reference` varchar(64) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_product_lang` CHANGE `meta_description` `meta_description` varchar(512) DEFAULT NULL, CHANGE `meta_keywords` `meta_keywords` varchar(255) DEFAULT NULL
[OK] SQL 1.7.5.0 ALTER TABLE `rcso_customer_thread` CHANGE `email` `email` varchar(255) NOT NULL
[WARNING] SQL 1.7.5.0 1060 in ALTER TABLE `rcso_stock_available` ADD `location` VARCHAR(255) NOT NULL DEFAULT '' AFTER `out_of_stock`: Duplicate column name 'location'
Database upgrade OK
[SKIP] directory "/app/cache/" does not exist and cannot be emptied.
[SKIP] directory "/themes/classic/cache/" does not exist and cannot be emptied.
Erreur(s) détectée(s) pendant la mise à jour.

 

Link to comment
Share on other sites
ksaan Newbie

ksaan

Posted
Posted

Vous êtes sûr que c'est un prestashop 1.7.3 🤔 ? Parce que dans le log on voit des étapes exécutés pour migrer Prestashop 1.7.0, 1.7.1 puis 1.7.2, 1.7.3 et enfin 1.7.4

Si pour une raison X ou Y votre PS 1.7.3 a été confondu par le module avec un PS 1.7.0 le processus d'upgrade a peut-être exécuté des trucs non prévus

Votre PrestaShop est standard ou bien des customisations ont été effectuées dessus ?

Link to comment
Share on other sites
dieuduciel Newbie

dieuduciel

Posted
  • Author
Posted

Bonjour,

Merci pour votre réponse.
C'est bien une version 1.7.3 que j'ai mise à jour l'année dernière depuis une version 1.6.X (4 je crois de mémoire)
Je ne suis jamais passé par une version inférieure à la 1.7.3 (du moins pas de mon choix)
C'est une configuration assez standard, je n'ai aucun développement ou module spécifique.
Mon problème ressemble à ca


Mais j'ai essayé de réuploader le fichier sql dont il est mention, sans succès....


Bien cordialement,

Link to comment
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
 Share
Go to topic listing
×
×
  • Create New...