RicRey Posted November 4, 2018 Share Posted November 4, 2018 hola a todos al finalizar la actualización me da un error y al volver a cargar me da acceso denegado, ahora me di cuenta que en la base de datos aparece en ps_access no hay nada de información, dicha información la relleno de mi respaldo de la base de datos y puedo acceder, pero veo que la plataforma queda con errores, quisiera que me ayuden a resolverlos.. aqui muestro lo que me manda al momento de terminar la actualización Finished... [OK] SQL 1.6.1.0 SET NAMES 'utf8' [OK] SQL 1.6.1.0 UPDATE `os_configuration` SET `value` = CONCAT('#', `value`) WHERE `name` LIKE 'PS_%_PREFIX' AND `value` NOT LIKE '#%' [OK] SQL 1.6.1.0 UPDATE `os_configuration_lang` SET `value` = CONCAT('#', `value`) WHERE `id_configuration` IN (SELECT `id_configuration` FROM `os_configuration` WHERE `name` LIKE 'PS_%_PREFIX') AND `value` NOT LIKE '#%' [OK] SQL 1.6.1.0 ALTER TABLE `os_orders` CHANGE `invoice_number` `invoice_number` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0', CHANGE `delivery_number` `delivery_number` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' [OK] SQL 1.6.1.0 /* taxes-patch */ ALTER TABLE `os_order_invoice` CHANGE COLUMN `total_discount_tax_excl` `total_discount_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_discount_tax_incl` `total_discount_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid_tax_excl` `total_paid_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid_tax_incl` `total_paid_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_products` `total_products` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_products_wt` `total_products_wt` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_shipping_tax_excl` `total_shipping_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_shipping_tax_incl` `total_shipping_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_wrapping_tax_excl` `total_wrapping_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_wrapping_tax_incl` `total_wrapping_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' [WARNING] SQL 1.6.1.0 1060 in ALTER TABLE `os_orders` ADD `round_type` TINYINT(1) NOT NULL DEFAULT '1' AFTER `round_mode`: Duplicate column name 'round_type' [WARNING] SQL 1.6.1.0 1060 in ALTER TABLE os_product_tag ADD `id_lang` int(10) unsigned NOT NULL, ADD KEY (id_lang, id_tag): Duplicate column name 'id_lang' [OK] SQL 1.6.1.0 UPDATE os_product_tag, os_tag SET os_product_tag.id_lang=os_tag.id_lang WHERE os_tag.id_tag=os_product_tag.id_tag [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `os_tag_count` [DROP] SQL `os_tag_count` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `os_tag_count` ( `id_group` int(10) unsigned NOT NULL DEFAULT 0, `id_tag` int(10) unsigned NOT NULL DEFAULT 0, `id_lang` int(10) unsigned NOT NULL DEFAULT 0, `id_shop` int(11) unsigned NOT NULL DEFAULT 0, `counter` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id_group`, `id_tag`), KEY (`id_group`, `id_lang`, `id_shop`, `counter`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] SQL 1.6.1.0 REPLACE INTO `os_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `os_product_tag` pt LEFT JOIN `os_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `os_product` p ON (p.id_product = pt.id_product) INNER JOIN `os_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_group FROM `os_category_group`) cg JOIN (SELECT DISTINCT id_shop FROM `os_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `os_category_product` cp LEFT JOIN `os_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND p.`id_product` = cp.`id_product`) AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag, cg.id_group [OK] SQL 1.6.1.0 REPLACE INTO `os_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `os_product_tag` pt LEFT JOIN `os_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `os_product` p ON (p.id_product = pt.id_product) INNER JOIN `os_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_shop FROM `os_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag [OK] PHP 1.6.1.0 : /* PHP:alter_ignore_drop_key(shop, id_group_shop); */ [OK] PHP 1.6.1.0 : /* PHP:alter_ignore_drop_key(specific_price, id_product_2); */ [OK] PHP 1.6.1.0 : /* PHP:alter_ignore_drop_key(hook_module, position); */ [OK] PHP 1.6.1.0 : /* PHP:alter_ignore_drop_key(cart_product, PRIMARY); */ [OK] PHP 1.6.1.0 : /* PHP:alter_ignore_drop_key(cart_product, cart_product_index); */ [OK] SQL 1.6.1.0 ALTER TABLE `os_shop_group` ADD KEY `deleted` (`deleted`, `name`) [WARNING] SQL 1.6.1.0 1091 in ALTER TABLE `os_shop` DROP KEY `id_shop_group`: Can't DROP 'id_shop_group'; check that column/key exists [OK] SQL 1.6.1.0 ALTER TABLE `os_shop` ADD KEY `id_shop_group` (`id_shop_group`, `deleted`) [OK] SQL 1.6.1.0 ALTER TABLE `os_shop_url` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `os_shop_url` ADD KEY `id_shop` (`id_shop`, `main`) [OK] SQL 1.6.1.0 ALTER TABLE `os_customization` ADD KEY `id_cart` (`id_cart`) [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_product_sale` ADD KEY `quantity` (`quantity`): Duplicate key name 'quantity' [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_cart_rule` ADD KEY `id_customer` (`id_customer`, `active`, `date_to`): Duplicate key name 'id_customer' [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_cart_rule` ADD KEY `group_restriction` (`group_restriction`, `active`, `date_to`): Duplicate key name 'group_restriction' [OK] SQL 1.6.1.0 ALTER TABLE `os_hook_module` ADD KEY `position` (`id_shop`, `position`) [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `os_cart_product` ADD PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`) [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_cart_product` ADD KEY `id_cart_order` (`id_cart`, `date_add`, `id_product`, `id_product_attribute`): Duplicate key name 'id_cart_order' [OK] SQL 1.6.1.0 ALTER TABLE `os_customization` DROP KEY id_cart [WARNING] SQL 1.6.1.0 1061 in ALTER IGNORE TABLE `os_customization` ADD KEY `id_cart_product` (`id_cart`, `id_product`, `id_product_attribute`): Duplicate key name 'id_cart_product' [WARNING] SQL 1.6.1.0 1091 in ALTER TABLE `os_category` DROP KEY nleftright, DROP KEY nleft: Can't DROP 'nleftright'; check that column/key exists [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_category` ADD KEY `activenleft` (`active`,`nleft`), ADD KEY `activenright` (`active`,`nright`): Duplicate key name 'activenleft' [WARNING] SQL 1.6.1.0 1091 in ALTER IGNORE TABLE `os_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`, `id_shop`, `cover`): Can't DROP 'id_image'; check that column/key exists [WARNING] SQL 1.6.1.0 1060 in ALTER TABLE os_product_attribute_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `default_on`): Duplicate column name 'id_product' [OK] SQL 1.6.1.0 UPDATE os_product_attribute_shop, os_product_attribute SET os_product_attribute_shop.id_product=os_product_attribute.id_product WHERE os_product_attribute_shop.id_product_attribute=os_product_attribute.id_product_attribute [WARNING] SQL 1.6.1.0 1060 in ALTER TABLE os_image_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `cover`): Duplicate column name 'id_product' [OK] SQL 1.6.1.0 UPDATE os_image_shop, os_image SET os_image_shop.id_product=os_image.id_product WHERE os_image_shop.id_image=os_image.id_image [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `os_image_shop` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_image`, `id_shop`) [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_product_supplier` ADD KEY `id_supplier` (`id_supplier`,`id_product`): Duplicate key name 'id_supplier' [OK] SQL 1.6.1.0 ALTER TABLE `os_product` DROP KEY `product_manufacturer` [OK] SQL 1.6.1.0 ALTER TABLE `os_product` ADD KEY `product_manufacturer` (`id_manufacturer`, `id_product`) [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `os_smarty_lazy_cache` [DROP] SQL `os_smarty_lazy_cache` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `os_smarty_lazy_cache` ( `template_hash` varchar(32) NOT NULL DEFAULT '', `cache_id` varchar(255) NOT NULL DEFAULT '', `compile_id` varchar(32) NOT NULL DEFAULT '', `filepath` varchar(255) NOT NULL DEFAULT '', `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`template_hash`, `cache_id`, `compile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `os_smarty_last_flush` [DROP] SQL `os_smarty_last_flush` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `os_smarty_last_flush` ( `type` ENUM('compile', 'template'), `last_flush` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `os_modules_perfs` [DROP] SQL `os_modules_perfs` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `os_modules_perfs` ( `id_modules_perfs` int(11) unsigned NOT NULL AUTO_INCREMENT, `session` int(11) unsigned NOT NULL, `module` varchar(62) NOT NULL, `method` varchar(126) NOT NULL, `time_start` double unsigned NOT NULL, `time_end` double unsigned NOT NULL, `memory_start` int unsigned NOT NULL, `memory_end` int unsigned NOT NULL, PRIMARY KEY (`id_modules_perfs`), KEY (`session`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] SQL 1.6.1.0 ALTER TABLE `os_image` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `os_image` SET `cover`=NULL WHERE `cover`=0 [OK] SQL 1.6.1.0 CREATE TEMPORARY TABLE `image_transform` SELECT `id_product`, COUNT(*) c FROM `os_image` WHERE `cover`=1 GROUP BY `id_product` HAVING c>1 [OK] SQL 1.6.1.0 UPDATE `image_transform` JOIN `os_image` USING (`id_product`) SET `os_image`.`cover`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `os_image` DROP KEY `id_product_cover` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `os_image` ADD UNIQUE KEY `id_product_cover` (`id_product`,`cover`) [OK] SQL 1.6.1.0 ALTER TABLE `os_image_shop` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `os_image_shop` SET `cover`=NULL WHERE `cover`=0 [OK] SQL 1.6.1.0 CREATE TEMPORARY TABLE `image_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `os_image_shop` WHERE `cover`=1 GROUP BY `id_product`, `id_shop` HAVING c>1 [OK] SQL 1.6.1.0 UPDATE `image_shop_transform` JOIN `os_image_shop` USING (`id_product`, `id_shop`) SET `os_image_shop`.`cover`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `os_image_shop` DROP KEY `id_product` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `os_image_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `cover`) [OK] SQL 1.6.1.0 ALTER TABLE `os_product_attribute` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `os_product_attribute` SET `default_on`=NULL WHERE `default_on`=0 [OK] SQL 1.6.1.0 CREATE TEMPORARY TABLE `attribute_transform` SELECT `id_product`, COUNT(*) c FROM `os_product_attribute` WHERE `default_on`=1 GROUP BY `id_product` HAVING c>1 [OK] SQL 1.6.1.0 UPDATE `attribute_transform` JOIN `os_product_attribute` USING (`id_product`) SET `os_product_attribute`.`default_on`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `os_product_attribute` DROP KEY `product_default` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `os_product_attribute` ADD UNIQUE KEY `product_default` (`id_product`,`default_on`) [OK] SQL 1.6.1.0 ALTER TABLE `os_product_attribute_shop` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `os_product_attribute_shop` SET `default_on`=NULL WHERE `default_on`=0 [OK] SQL 1.6.1.0 CREATE TEMPORARY TABLE `attribute_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `os_product_attribute_shop` WHERE `default_on`=1 GROUP BY `id_product`, `id_shop` HAVING c>1 [OK] SQL 1.6.1.0 UPDATE `attribute_shop_transform` JOIN `os_product_attribute_shop` USING (`id_product`, `id_shop`) SET `os_product_attribute_shop`.`default_on`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `os_product_attribute_shop` DROP KEY `id_product` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `os_product_attribute_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `default_on`) [WARNING] SQL 1.6.1.0 1061 in ALTER IGNORE TABLE `os_product_download` ADD UNIQUE KEY `id_product` (`id_product`): Duplicate key name 'id_product' [OK] SQL 1.6.1.0 ALTER TABLE `os_customer` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `os_customer` ADD KEY `id_shop` (`id_shop`, `date_add`) [OK] SQL 1.6.1.0 ALTER TABLE `os_cart` DROP KEY `id_shop` [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_cart` ADD KEY `id_shop_2` (`id_shop`,`date_upd`), ADD KEY `id_shop` (`id_shop`,`date_add`): Duplicate key name 'id_shop_2' [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_product_shop` ADD KEY `indexed` (`indexed`, `active`, `id_product`): Duplicate key name 'indexed' [OK] SQL 1.6.1.0 UPDATE `os_product_shop` SET `date_add` = NOW() WHERE `date_add` = "0000-00-00 00:00:00" [WARNING] SQL 1.6.1.0 1054 in INSERT IGNORE INTO `os_hook` (`id_hook`, `name`, `title`, `description`, `position`, `live_edit`) VALUES (NULL, 'actionAdminLoginControllerSetMedia', 'Set media on admin login page header', 'This hook is called after adding media to admin login page header', '1', '0'), (NULL, 'actionOrderEdited', 'Order edited', 'This hook is called when an order is edited.', '1', '0'), (NULL, 'displayAdminNavBarBeforeEnd', 'Admin Nav-bar before end', 'Called before the end of the nav-bar.', '1', '0'), (NULL, 'displayAdminAfterHeader', 'Admin after header', 'Hook called just after the header of the backoffice.', '1', '0'), (NULL, 'displayAdminLogin', 'Admin login', 'Hook called just after login of the backoffice.', '1', '0'): Unknown column 'live_edit' in 'field list' [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_cart_rule` ADD KEY `id_customer_2` (`id_customer`,`active`,`highlight`,`date_to`): Duplicate key name 'id_customer_2' [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_cart_rule` ADD KEY `group_restriction_2` (`group_restriction`,`active`,`highlight`,`date_to`): Duplicate key name 'group_restriction_2' [OK] SQL 1.6.1.0 ALTER TABLE `os_configuration_kpi` CHANGE `name` `name` varchar(64) [OK] SQL 1.6.1.0 ALTER TABLE `os_smarty_lazy_cache` CHANGE `cache_id` `cache_id` varchar(255) NOT NULL DEFAULT '' [OK] SQL 1.6.1.0 TRUNCATE TABLE `os_smarty_lazy_cache` [DROP] SQL `os_cms_role` table has been dropped. [OK] SQL 1.6.1.0 /* Advanced EU Compliance tables */ CREATE TABLE IF NOT EXISTS `os_cms_role` ( `id_cms_role` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `id_cms` int(11) unsigned NOT NULL, PRIMARY KEY (`id_cms_role`, `id_cms`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [DROP] SQL `os_cms_role_lang` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE IF NOT EXISTS `os_cms_role_lang` ( `id_cms_role` int(11) unsigned NOT NULL, `id_lang` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, PRIMARY KEY (`id_cms_role`,`id_lang`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [WARNING] SQL 1.6.1.0 1060 in ALTER TABLE `os_order_invoice` ADD `company_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl`: Duplicate column name 'company_address' [WARNING] SQL 1.6.1.0 1060 in ALTER TABLE `os_order_invoice` ADD `shop_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl`: Duplicate column name 'shop_address' [OK] SQL 1.6.1.0 ALTER TABLE `os_order_invoice` ADD `invoice_address` TEXT DEFAULT NULL AFTER `shop_address` [OK] SQL 1.6.1.0 ALTER TABLE `os_order_invoice` ADD `delivery_address` TEXT DEFAULT NULL AFTER `invoice_address` [WARNING] SQL 1.6.1.0 1062 in INSERT INTO `os_hook` (`name`, `title`, `description`) VALUES ('displayInvoiceLegalFreeText', 'PDF Invoice - Legal Free Text', 'This hook allows you to modify the legal free text on PDF invoices'): Duplicate entry 'displayInvoiceLegalFreeText' for key 'hook_name' [OK] SQL 1.6.1.0 UPDATE `os_hook` SET position = 0 WHERE name LIKE 'action%' [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `os_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`) [OK] SQL 1.6.1.0 INSERT INTO `os_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_INVOICE_ADDR_RULES', '{"avoid":["vat_number","phone","phone_mobile"]}', NOW(), NOW()) [OK] SQL 1.6.1.0 INSERT INTO `os_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_DELIVERY_ADDR_RULES', '{"avoid":["vat_number","phone","phone_mobile"]}', NOW(), NOW()) [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_pack` ADD KEY `product_item` (`id_product_item`,`id_product_attribute_item`): Duplicate key name 'product_item' [WARNING] SQL 1.6.1.0 1091 in ALTER TABLE `os_supply_order_detail` DROP KEY `id_supply_order`, DROP KEY `id_product`, ADD KEY `id_supply_order` (`id_supply_order`, `id_product`): Can't DROP 'id_product'; check that column/key exists [WARNING] SQL 1.6.1.0 1061 in ALTER TABLE `os_carrier` ADD KEY `reference` (`id_reference`, `deleted`, `active`): Duplicate key name 'reference' [OK] SQL 1.6.1.1 SET NAMES 'utf8' [OK] SQL 1.6.1.1 ALTER TABLE `os_customer_message` CHANGE `message` `message` MEDIUMTEXT NOT NULL [OK] SQL 1.6.1.1 UPDATE `os_tax_rules_group` SET `date_add` = NOW(), `date_upd` = NOW() WHERE `date_add` = '0000-00-00 00:00:00' [WARNING] SQL 1.6.1.1 1060 in ALTER TABLE `os_order_detail` ADD `original_wholesale_price` DECIMAL( 20, 6 ) NOT NULL DEFAULT '0.000000': Duplicate column name 'original_wholesale_price' [OK] PHP 1.6.1.1 : /* PHP:alter_ignore_drop_key(specific_price, id_product_2); */ [OK] SQL 1.6.1.1 ALTER TABLE `os_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`) [OK] SQL 1.6.1.2 SET NAMES 'utf8' [OK] SQL 1.6.1.2 UPDATE `os_image_shop` ish, `os_image` i SET ish.id_product = i.id_product WHERE i.id_image=ish.id_image [OK] SQL 1.6.1.2 REPLACE INTO `os_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `os_product_tag` pt INNER JOIN `os_product_shop` product_shop USING (id_product) JOIN (SELECT DISTINCT id_group FROM `os_category_group`) cg WHERE product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `os_category_product` cp LEFT JOIN `os_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND product_shop.`id_product` = cp.`id_product`) GROUP BY pt.id_tag, pt.id_lang, cg.id_group, id_shop ORDER BY NULL [OK] SQL 1.6.1.2 REPLACE INTO `os_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `os_product_tag` pt INNER JOIN `os_product_shop` product_shop USING (id_product) WHERE product_shop.`active` = 1 GROUP BY pt.id_tag, pt.id_lang, id_shop ORDER BY NULL [OK] SQL 1.6.1.2 TRUNCATE TABLE `os_smarty_last_flush` [OK] SQL 1.6.1.2 ALTER TABLE `os_search_index` ADD INDEX(`id_product`) [OK] SQL 1.6.1.2 ALTER TABLE `os_specific_price` ADD INDEX(`id_product_attribute`) [OK] SQL 1.6.1.2 ALTER TABLE `os_specific_price` ADD INDEX(`id_shop`) [OK] SQL 1.6.1.2 ALTER TABLE `os_specific_price` ADD INDEX(`id_customer`) [OK] SQL 1.6.1.2 ALTER TABLE `os_specific_price` ADD INDEX(`from`) [OK] SQL 1.6.1.2 ALTER TABLE `os_specific_price` ADD INDEX(`to`) [OK] SQL 1.6.1.2 ALTER TABLE `os_specific_price` DROP KEY `id_product_2` [OK] SQL 1.6.1.2 ALTER TABLE `os_specific_price` ADD UNIQUE KEY `id_product_2` (`id_product`,`id_product_attribute`,`id_customer`,`id_cart`,`from`,`to`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`id_specific_price_rule`) [OK] SQL 1.6.1.2 ALTER TABLE `os_category_product` ADD INDEX(`id_category`, `position`) [OK] SQL 1.6.1.2 ALTER TABLE `os_address` CHANGE `company` `company` VARCHAR(64) NULL [OK] SQL 1.6.1.5 SET NAMES 'utf8' [OK] SQL 1.6.1.5 UPDATE `os_configuration` c SET `value` = '{"avoid":[]}' WHERE `name` IN ('PS_INVCE_INVOICE_ADDR_RULES', 'PS_INVCE_DELIVERY_ADDR_RULES') [OK] SQL 1.6.1.6 SET NAMES 'utf8' [OK] SQL 1.6.1.6 ALTER TABLE `os_cart_product` CHANGE `id_product_attribute` `id_product_attribute` int(10) unsigned NOT NULL DEFAULT '0' [OK] SQL 1.6.1.7 SET NAMES 'utf8' [WARNING] SQL 1.6.1.7 1062 in INSERT INTO `os_hook` (`name`, `title`, `description`, `position`) VALUES ('displayCartExtraProductActions', 'Extra buttons in shopping cart', 'This hook adds extra buttons to the product lines, in the shopping cart', 0): Duplicate entry 'displayCartExtraProductActions' for key 'hook_name' [OK] SQL 1.6.1.14 SET NAMES 'utf8' [OK] SQL 1.6.1.14 ALTER TABLE `os_carrier_lang` CHANGE `delay` `delay` VARCHAR(512) NULL [OK] SQL 1.7.0.0 SET NAMES 'utf8' [OK] SQL 1.7.0.0 INSERT INTO `os_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 `os_configuration_lang` (`id_configuration`, `id_lang`, `value`, `date_upd`) SELECT c.`id_configuration`, l.`id_lang`, c.`value`, NOW() FROM `os_configuration` c, `os_lang` l WHERE c.`name` = 'PS_MAINTENANCE_TEXT': Duplicate entry '4677-3' for key 'PRIMARY' [WARNING] SQL 1.7.0.0 1062 in INSERT INTO `os_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 `os_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 `os_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 `os_customer` ADD `reset_password_validity` datetime DEFAULT NULL: Duplicate column name 'reset_password_validity' [OK] SQL 1.7.0.0 ALTER TABLE `os_employee` CHANGE `last_connection_date` `last_connection_date` DATE NULL DEFAULT NULL [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_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 `os_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 `os_customer` SET `newsletter_date_add` = NULL WHERE YEAR(newsletter_date_add) = "0000" [OK] SQL 1.7.0.0 ALTER TABLE `os_customer` CHANGE COLUMN `passwd` `passwd` varchar(60) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `os_employee` CHANGE COLUMN `passwd` `passwd` varchar(60) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `os_customer` CHANGE COLUMN `firstname` `firstname` varchar(255) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `os_customer` CHANGE COLUMN `lastname` `lastname` varchar(255) NOT NULL [WARNING] SQL 1.7.0.0 1061 in /* Changes regarding modules */ ALTER TABLE `os_module` ADD UNIQUE INDEX `name_UNIQUE` (`name` ASC): Duplicate key name 'name_UNIQUE' [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_modules_perfs` [DROP] SQL `os_module_carrier` table has been dropped. [OK] SQL 1.7.0.0 CREATE TABLE `os_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 `os_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `os_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 `os_quick_access` SET `link` = "index.php/product/new" WHERE `link` = "index.php?controller=AdminProducts&addproduct" [OK] SQL 1.7.0.0 ALTER TABLE `os_product` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_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 `os_product` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn' [OK] SQL 1.7.0.0 ALTER TABLE `os_product_shop` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_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 `os_order_detail` ADD `product_isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'product_isbn' [OK] SQL 1.7.0.0 ALTER TABLE `os_product_attribute` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_product_attribute` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn' [OK] SQL 1.7.0.0 ALTER TABLE `os_product_attribute_shop` CHANGE `available_date` `available_date` DATE NULL DEFAULT NULL [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_stock` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn' [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_supply_order_detail` ADD `isbn` VARCHAR( 13 ) NULL DEFAULT NULL: Duplicate column name 'isbn' [OK] SQL 1.7.0.0 ALTER TABLE `os_order_invoice` DROP COLUMN `invoice_address`, DROP COLUMN `delivery_address` [OK] SQL 1.7.0.0 ALTER TABLE `os_cart_product` CHANGE `id_product_attribute` `id_product_attribute` int(10) unsigned DEFAULT '0' [OK] SQL 1.7.0.0 ALTER TABLE `os_product_lang` ADD `social_sharing_title` VARCHAR( 255 ) NOT NULL [OK] SQL 1.7.0.0 ALTER TABLE `os_product_lang` ADD `social_sharing_description` VARCHAR( 255 ) NOT NULL [INTERNAL] /home/sistegra/public_html/sisteprog/autoupgrade/latest/install/upgrade/php/ps1700_stores.php line 35 - Invalid argument supplied for foreach() [WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `os_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 `os_hook_alias` WHERE `name` = 'displayProductComparison' [OK] SQL 1.7.0.0 DELETE FROM `os_hook` WHERE `name` = 'displayProductComparison' [OK] SQL 1.7.0.0 DELETE FROM `os_meta` WHERE `page` = 'products-comparison' [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_compare` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_compare_product` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_theme` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_theme_meta` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_theme_specific` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_scene` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_scene_category` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_scene_lang` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_scene_products` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_scene_shop` [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_shop` ADD COLUMN `theme_name` VARCHAR(255) AFTER `id_category`: Duplicate column name 'theme_name' [OK] SQL 1.7.0.0 UPDATE `os_shop` SET `theme_name` = 'classic' [OK] SQL 1.7.0.0 UPDATE `os_configuration` SET value=0 WHERE name='PS_TAX_DISPLAY' [WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `os_image_type` DROP `scenes`: Can't DROP 'scenes'; check that column/key exists [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_cart` ADD `checkout_session_data` MEDIUMTEXT NULL: Duplicate column name 'checkout_session_data' [WARNING] SQL 1.7.0.0 1091 in ALTER TABLE `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_product` ADD `state` INT UNSIGNED NOT NULL DEFAULT '1': Duplicate column name 'state' [WARNING] SQL 1.7.0.0 1061 in ALTER TABLE `os_product` ADD KEY `state` (`state`, `date_upd`): Duplicate key name 'state' [WARNING] SQL 1.7.0.0 1060 in ALTER TABLE `os_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 `os_authorization_role` table has been dropped. [OK] SQL 1.7.0.0 /* Right management */ CREATE TABLE `os_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 [OK] SQL 1.7.0.0 /* Create a copy without indexes to make ID updates without conflict. */ CREATE TABLE `os_access_old` AS SELECT * FROM `os_access` [OK] SQL 1.7.0.0 DROP TABLE `os_access` [OK] SQL 1.7.0.0 RENAME TABLE `os_module_access` TO `os_module_access_old` [DROP] SQL `os_tab_transit` table has been dropped. [OK] SQL 1.7.0.0 CREATE TABLE `os_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 `os_tab_transit` (`id_old_tab`, `key`) SELECT `id_tab`, CONCAT(`class_name`, COALESCE(`module`, '')) FROM `os_tab` [DROP] SQL `os_access` table has been dropped. [OK] SQL 1.7.0.0 CREATE TABLE `os_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 `os_module_access` table has been dropped. [OK] SQL 1.7.0.0 CREATE TABLE `os_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 `os_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 `os_hook` WHERE `name` IN ( 'displayProductTab', 'displayProductTabContent', 'displayBeforePayment', 'actionBeforeAuthentication', 'actionOrderDetail', 'actionProductListOverride', 'actionSearch', 'displayCustomerIdentityForm', 'displayHomeTab', 'displayHomeTabContent', 'displayPayment') [OK] SQL 1.7.0.0 DELETE FROM `os_hook_alias` WHERE `name` IN ( 'beforeAuthentication', 'displayProductTab', 'displayProductTabContent', 'displayBeforePayment', 'orderDetail', 'payment', 'productListAssign', 'search') [OK] SQL 1.7.0.0 DELETE FROM `os_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 `os_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 `os_tab_transit` tt SET `id_new_tab` = ( SELECT `id_tab` FROM `os_tab` WHERE CONCAT(`class_name`, COALESCE(`module`, '')) = tt.`key` LIMIT 1 ) [OK] SQL 1.7.0.0 /* Update default tab IDs for employees */ UPDATE `os_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 `os_tab` WHERE `class_name` = 'AdminDashboard' AND `module` IS NULL) ) FROM `os_tab_transit` WHERE `id_old_tab` = e.`default_tab` ) [WARNING] SQL 1.7.0.0 1054 in /* Update access tab IDs */ UPDATE `os_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 `os_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 `os_access_old` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_module_access_old` [OK] SQL 1.7.0.0 DROP TABLE IF EXISTS `os_tab_transit` [OK] PHP 1.7.0.5 : /* PHP:ps_update_tabs(); */ [OK] SQL 1.7.0.5 ALTER TABLE `os_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 `os_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 `os_country` WHERE `iso_code` = 'IN') [WARNING] SQL 1.7.1.0 1062 in UPDATE `os_hook` SET `name` = 'displayProductAdditionalInfo' WHERE `name` = 'displayProductButtons': Duplicate entry 'displayProductAdditionalInfo' for key 'hook_name' [WARNING] SQL 1.7.1.0 1062 in INSERT INTO `os_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 `os_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 `os_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 `os_product` SET redirect_type = '301-product' WHERE redirect_type = '301' [OK] SQL 1.7.1.0 UPDATE `os_product` SET redirect_type = '302-product' WHERE redirect_type = '302' [OK] SQL 1.7.1.0 UPDATE `os_product_shop` SET redirect_type = '301-product' WHERE redirect_type = '301' [OK] SQL 1.7.1.0 UPDATE `os_product_shop` SET redirect_type = '302-product' WHERE redirect_type = '302' [OK] SQL 1.7.1.0 -- Can now remove old value ALTER TABLE `os_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 `os_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 `os_product` CHANGE `id_product_redirected` `id_type_redirected` INT(10) NOT NULL DEFAULT '0': Unknown column 'id_product_redirected' in 'os_product' [WARNING] SQL 1.7.1.0 1054 in ALTER TABLE `os_product_shop` CHANGE `id_product_redirected` `id_type_redirected` INT(10) NOT NULL DEFAULT '0': Unknown column 'id_product_redirected' in 'os_product_shop' [OK] SQL 1.7.1.0 INSERT IGNORE INTO `os_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 `os_configuration` WHERE `name` IN ('PS_META_KEYWORDS') [OK] SQL 1.7.1.0 INSERT INTO `os_operating_system` (`name`) VALUES ('Windows 8.1'), ('Windows 10') [OK] SQL 1.7.1.0 /* UPDATE TO DOCTRINE */ ALTER TABLE `os_attribute` CHANGE `id_attribute` `id_attribute` INT(11) NOT NULL AUTO_INCREMENT [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_group` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL AUTO_INCREMENT [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_group_lang` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_group_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_group_shop` CHANGE `id_attribute_group` `id_attribute_group` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_group_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_lang` CHANGE `id_attribute` `id_attribute` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_shop` CHANGE `id_attribute` `id_attribute` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_attribute_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_lang` CHANGE `id_lang` `id_lang` INT(11) NOT NULL AUTO_INCREMENT [OK] SQL 1.7.1.0 ALTER TABLE `os_lang_shop` CHANGE `id_lang` `id_lang` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_lang_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_shop` CHANGE `id_shop` `id_shop` INT(11) NOT NULL AUTO_INCREMENT [OK] SQL 1.7.1.0 ALTER TABLE `os_shop` CHANGE `id_shop_group` `id_shop_group` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_shop_group` CHANGE `id_shop_group` `id_shop_group` INT(11) NOT NULL AUTO_INCREMENT [OK] SQL 1.7.1.0 ALTER TABLE `os_tab` CHANGE `id_tab` `id_tab` INT(11) NOT NULL AUTO_INCREMENT [OK] SQL 1.7.1.0 ALTER TABLE `os_tab_lang` CHANGE `id_tab` `id_tab` INT(11) NOT NULL [OK] SQL 1.7.1.0 ALTER TABLE `os_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 `os_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 `os_store` MODIFY `hours` text: Unknown column 'hours' in 'os_store' [OK] SQL 1.7.2.0 INSERT IGNORE INTO `os_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 `os_product` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL [OK] SQL 1.7.2.0 ALTER TABLE `os_order_detail` CHANGE `product_isbn` `product_isbn` VARCHAR(32) NULL DEFAULT NULL [OK] SQL 1.7.2.0 ALTER TABLE `os_product_attribute` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL [OK] SQL 1.7.2.0 ALTER TABLE `os_stock` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL [OK] SQL 1.7.2.0 ALTER TABLE `os_supply_order_detail` CHANGE `isbn` `isbn` VARCHAR(32) NULL DEFAULT NULL [WARNING] SQL 1.7.2.0 1060 in ALTER TABLE `os_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 `os_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 `os_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 `os_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 `os_search_index` DROP KEY `id_product` [OK] SQL 1.7.2.1 ALTER TABLE `os_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 `os_tab` SET `position` = 0 WHERE `class_name` = 'AdminZones' AND `position` = '1' [OK] SQL 1.7.3.0 UPDATE `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_store_lang` table has been dropped. [OK] SQL 1.7.3.0 CREATE TABLE IF NOT EXISTS `os_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 `os_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 `os_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 `os_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 `os_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 `os_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 `os_order_detail` DROP KEY product_id, ADD KEY product_id (product_id, product_attribute_id) [OK] SQL 1.7.4.0 INSERT IGNORE INTO `os_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 `os_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 `os_employee` SET `bo_css` = "theme.css" Database upgrade OK [SKIP] directory "/app/cache/" does not exist and cannot be emptied. Alerta detectada durante la actualización. Quote [ERROR] PHP 1.7.0.0 /* PHP:ps1700_stores(); */ espero me puedan guiar. 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