dieuduciel

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,

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.

Bonjour à tous, Je souhaiterais modifier la page 404 de mon site en faisant remonter des produits aléatoires sur cette page. Savez vous si cela est possible et si oui comment procéder ? Merci pour votre aide. Bonne journée

Merci pour tes modules OEB particulièrement le module de panier et de compte qui sont vraiment top. J'ai un problème cependant, je voudrais les intégrer dans mon theme dans la partie haute, vers le logo mais même si je choisis "top page" ou "header" comme points d'accroche ils se trouvent sous mon menu. Peux-tu m'aider? Merci par avance. Cf le screenshot ci dessous :

Bonsoir à tous, Ma question est simple : Existe-il un module qui génère un flux Google Shopping pour prestashop 1.3.0 J'en ai essayé au moins 3 ou 4 et aucuns ne fonctionnent sur cette version ( page blanche) Je n'ai pas la possibilité de migrer vers une version plus récente ( pas ma boutique) Auriez-vous quelque chose à me conseiller ? Merci pour votre aide. bonne soirée.

Bonjour à tous, Afin d'améliorer mon maillage interne, je souhaiterais proposer des produits relatifs à un thème donné, sur une page CMS. En fait, je voudrais écrire une page de texte, et proposer dessous un listing ou des blocs produits relatif à la page (au thème traité). Ces produits seraient affichés aléatoirement ( 5 max par page par exemple) en provenance d'une catégorie ou sous catégorie spécifiée. Existe-il une fonction de ce type dans prestashop ? Sinon quelqu'un l'a t-il déjà mis en place ? Je pense qu'il faut un script PHP qui aille chercher dans la base de données mais ne connaissant pas grand chose en développement je demande de l'aide ! Merci pour votre aide. Bonne après midi.

Exactement ce que je recherchais, en plus sous forme de module directement compatible, AU TOP !! Merci pour ton aide.

Bonjour à tous, Je cherche à optimiser un peu un de mes sites e-commerce sous prestashop. Le gros problème que j'ai vient principalement de la construction des URL réecrites. On est toujours sur une forme : www.monsite.com/idcategorie-cequejeveuxreecrire.html ou www.monsite.com/categorie/idproduit-cequeveuxecrire.html Le soucis c'est que l'on peut avoir de la duplication de contenu si on change les ecritures des URL, même si on a la possibilité bien sur de faire des redirections via htacces. Cependant, existe il un script php ou une regle de redirection qui puisse forcer l'affichage d'une URL dans 1 et 1 seule ecriture ? Quelque chose qui dise : " tout ce qui commence par "www.monsite.com/idcategorie" doit pointer vers cequejeveuxreecrire.html et idem pour les produits ? Merci pour votre retour. Bonne après midi.

Merci pour ton lien. Quelle version de Prestashop utilises-tu ? Je suis sur une 1.3 Quelle procédure faut-il suivre ? La procédure pour la version 1.1 ? Fonctionne-elle même avec une version 1.3 ? Merci pour ton retour. Bonne soirée.

Merci pour ton aide, je testerai ca ce soir. Autre question : Comment fais-tu pour que lorsque l'on rajoute à tes url des paramètres ou des compléments, on soit redirigé vers l'url canonique (produit ou catégorie) Ex : http://www.to-buy-art.com/2-aurelia-chapelain-je-complete-lurl?'>http://www.to-buy-art.com/2-aurelia-chapelain-je-complete-lurl? => Redirection vers http://www.to-buy-art.com/2-aurelia-chapelain Sur ma version de prestashop, je peux rajouter n'importe quoi (paramètres, compléments d'URL..) après l'id de produit ou de catégorie, et j'ai quand même accès la bonne page, sans être redirigé. De plus j'ai le module canonical qui me dit que la page sur laquelle je suis est bien l'url canonique : Par ex www.xxxx.com/4-macategorie-que-jai-complétée est considérée comme canonique, alors que www.xxxx.com/4-macategorie (vrai canonique) est elle aussi considérée comme canonique Aurais-tu une astuce ? Merci pour ton aide. Bonne journée.

Bonsoir, Sur un de mes sites, j'ai installé plusieurs langues (anglais et hollandais) en sous domaines nl.xxx.com et en.xxx.com J'ai installé le module URL canonical. Le problème c'est que l'on ne peut renseigner qu'un seul domaine ( le domaine générique www.xxx.com Pour les sous domaines j'ai donc une proposition de revenir vers les pages www.xxx.com/page.php depuis mes pages nl.xxx.com/page.php et en.xxx.com/page.php Comment-puis-je faire pour que chaque sous domaine fonctionne avec le module ? Merci pour votre aide. bonne soirée.

Bonjour à tous, Je dispose de 6 noms de domaines (.net, .fr,.com avec et sans tiret) Chez OVH j'ai demandé une redirection via le manager de mes 5 noms de domaine tiers vers mon .com avec tiret et tout fonctionne bien, mais c'est une redirection 302 qui est mise en place, et qui n'est pas terrible pour mon référencement J'aimerais donc passer toutes mes redirection via htaccess en 301. Cependant, impossible d'y arriver. Que dois-je faire ? Supprimer les redirection 302 via le manager OVH tout d'abord ? Après quel serait le script à ajouter sur mon htaccess pour que les 5 noms de domaine soient redirigés en 301 vers monsite.com ? En vous remerciant par avance pour votre réponse. Bonne après midi.

Bonsoir à tous, Je suis en train d'installer le module ATOS 1.3.5 disponible sur le forum. L'installation s'est bien passée. j'ai bien la liste d'un certain nombre de banques à choisir. Je suis au LCL (sherlocks) J'ai donc sélectionné le serveur bancaire LCL test et le code marchant correspondant : 014295303911111-Sherlocks-LCL-Demo Revenu sur ma boutique j'ai essayé d'acheter un objet, j'arrive sur cette page : http://world-dressing.com/4.jpg Puis-je essayer avec mes codes de carte bleue ou vais-je être débité ? Dans l'optique ou je ne serais pas débité, que doit-il se passer pour que je puisse vérifier que le module se comporte bien ? J'ai bien recu aujourd'hui mon certificat de cryptage que j'ai déchiffré avec le code reçu par courrier. J'ai renommé le fichier en certi.fr.mon code marchand. J'ai vu aussi que les fichiers certi.fr.XXX viennent de pair avec un fichier parcom.code marchand Pour ce parcom.code marchant, puis-modifier le parcom.014295303911111 avec mon numéro marchand ? Sinon à quoi sert le parmcom.sherlocks qui a un contenu différent des parcom.XXXXXX ? Merci pour votre aide. Bonne soirée. Topic déplacé -yoya971

Bonsoir, Merci pour ton aide et ta rapidité. Le problème est réglé. Bonne soirée.

Bonjour, Sur mon site : www.world-dressing.com, je souhaiterais modifier les liens que j'ai mis en bas en page. Lorsque j'ai développé le site j'avais modifié quelque chose dans un fichier, mais je ne me souvient plus lequel et je ne le retrouve pas. Je sais que ce n'était pas pas le module du site car j'avais rajouter des liens ( facebook, twitter...) Voici les liens dont je parle : Quelqu'un saurait me dire quel fichier (re)modifier ? Merci pour votre aide. Bonne soirée.