Phil.It Posted December 31, 2015 Share Posted December 31, 2015 (edited) Hello HappyPrestahoppers, 1. I just used 1CU (1-Click-Upgrade) : 1.6.0.11 ===> 1.6.1.3 For the record, I am used to upgrading with 1CU. 2. Upgrade went fine, apart from 3+3 errors in SQL See below : - log: errors - log : Full SQL update abstract 3. Reading error log, it seems 3 temporary sql tables were not created, because of access rights. Following update using these tables were impossible, of course, for those 3 tables didn't existed. 4. As far as I can see, Back-office and Front-Office run fine, but I have made no try to change any data. I want to check before what went wrong. 5. I'd like to know: - Does any Prestashop Team member know why this happened? - What are the consequences? - Is it just a warning or is it a 1CU bug? - Is the SQL database now in an inconsistent state? - What should I do now? __ Phil.IT === log: errors SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `image_transform` SELECT `id_product`, COUNT(*) c FROM `ps_image` WHERE `cover`=1 GROUP BY `id_product` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' SQL 1.6.1.0 1146 in UPDATE `image_transform` JOIN `ps_image` USING (`id_product`) SET `ps_image`.`cover`=NULL: Table 'watchesulike-com.image_transform' doesn't exist SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `image_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `ps_image_shop` WHERE `cover`=1 GROUP BY `id_product`, `id_shop` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' SQL 1.6.1.0 1146 in UPDATE `image_shop_transform` JOIN `ps_image_shop` USING (`id_product`, `id_shop`) SET `ps_image_shop`.`cover`=NULL: Table 'watchesulike-com.image_shop_transform' doesn't exist SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `attribute_transform` SELECT `id_product`, COUNT(*) c FROM `ps_product_attribute` WHERE `default_on`=1 GROUP BY `id_product` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' SQL 1.6.1.0 1146 in UPDATE `attribute_transform` JOIN `ps_product_attribute` USING (`id_product`) SET `ps_product_attribute`.`default_on`=NULL: Table 'watchesulike-com.attribute_transform' doesn't exist SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `attribute_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `ps_product_attribute_shop` WHERE `default_on`=1 GROUP BY `id_product`, `id_shop` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' SQL 1.6.1.0 1146 in UPDATE `attribute_shop_transform` JOIN `ps_product_attribute_shop` USING (`id_product`, `id_shop`) SET `ps_product_attribute_shop`.`default_on`=NULL: Table 'watchesulike-com.attribute_shop_transform' doesn't exist Erreur(s) détectée(s) pendant la mise à jour. === end === log : Full SQL update abstract [OK] SQL 1.6.0.12 SET NAMES 'utf8' [OK] SQL 1.6.0.12 INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CUSTOMER_NWSL', 1, NOW(), NOW()), ('PS_CUSTOMER_OPTIN', 1, NOW(), NOW()) [OK] SQL 1.6.0.12 INSERT INTO `ps_order_state` (`invoice`, `send_email`, `module_name`, `color`, `unremovable`, `hidden`, `logable`, `delivery`, `shipped`, `paid`, `deleted`) VALUES ('0', '0', 'cashondelivery', '#4169E1', '1', '0', '0', '0', '0', '0', '0') [OK] SQL 1.6.0.12 SET @id_order_state = LAST_INSERT_ID() [OK] SQL 1.6.0.12 INSERT INTO `ps_order_state_lang` (`id_order_state`, `id_lang`, `name`, `template`) (SELECT @id_order_state, id_lang, 'Waiting cod validation', '' FROM `ps_lang`) [OK] SQL 1.6.0.12 INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_OS_COD_VALIDATION', @id_order_state, NOW(), NOW()) [OK] SQL 1.6.0.12 UPDATE `ps_hook` set `position` = 1 where `name` in ('displayBanner', 'displayNav', 'displayTopColumn') [OK] SQL 1.6.0.12 ALTER TABLE `ps_product` ADD `pack_stock_type` int(11) UNSIGNED DEFAULT '3' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_shop` ADD `pack_stock_type` int(11) UNSIGNED DEFAULT '3' [OK] SQL 1.6.0.12 ALTER TABLE `ps_pack` ADD `id_product_attribute_item` int(10) UNSIGNED NOT NULL AFTER `id_product_item` [OK] SQL 1.6.0.12 ALTER TABLE `ps_pack` DROP PRIMARY KEY [OK] PHP 1.6.0.12 : /* PHP:p16012_pack_rework(); */ [OK] SQL 1.6.0.12 ALTER TABLE `ps_pack` ADD PRIMARY KEY (`id_product_pack`, `id_product_item`, `id_product_attribute_item`) [OK] SQL 1.6.0.12 ALTER TABLE `ps_order_state` ADD `pdf_delivery` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `paid` [OK] SQL 1.6.0.12 ALTER TABLE `ps_order_state` ADD `pdf_invoice` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `pdf_delivery` [OK] SQL 1.6.0.12 ALTER TABLE `ps_orders` CHANGE `shipping_number` `shipping_number` VARCHAR( 64 ) [OK] PHP 1.6.0.12 : /* PHP:ps16012_update_alias(); */ [OK] SQL 1.6.0.12 ALTER TABLE `ps_store` CHANGE `hours` `hours` TEXT [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang` [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cms`, `id_shop`, `id_lang`) [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_category_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang` [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_category_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cms_category`, `id_shop`, `id_lang`) [DROP] SQL `ps_cms_category_shop` table has been dropped. [OK] SQL 1.6.0.12 CREATE TABLE `ps_cms_category_shop` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_cms_category`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] PHP 1.6.0.12 : /* PHP:cms_multishop(); */ [OK] SQL 1.6.0.12 ALTER TABLE `ps_customization_field_lang` ADD `id_shop` INT(10) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang` [OK] SQL 1.6.0.12 ALTER TABLE `ps_customization_field_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_customization_field`, `id_shop`, `id_lang`) [OK] PHP 1.6.0.12 : /* PHP:customization_field_multishop_lang(); */ [OK] SQL 1.6.0.12 ALTER TABLE `ps_product` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_shop` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_attribute` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_attribute_shop` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_module_access` CHANGE `view` `view` TINYINT( 1 ) NOT NULL DEFAULT '0', CHANGE `configure` `configure` TINYINT( 1 ) NOT NULL DEFAULT '0', CHANGE `uninstall` `uninstall` TINYINT( 1 ) NOT NULL DEFAULT '0' [OK] SQL 1.6.1.0 SET NAMES 'utf8' [OK] SQL 1.6.1.0 UPDATE `ps_configuration` SET `value` = CONCAT('#', `value`) WHERE `name` LIKE 'PS_%_PREFIX' AND `value` NOT LIKE '#%' [OK] SQL 1.6.1.0 UPDATE `ps_configuration_lang` SET `value` = CONCAT('#', `value`) WHERE `id_configuration` IN (SELECT `id_configuration` FROM `ps_configuration` WHERE `name` LIKE 'PS_%_PREFIX') AND `value` NOT LIKE '#%' [OK] SQL 1.6.1.0 ALTER TABLE `ps_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 `ps_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' [OK] SQL 1.6.1.0 ALTER TABLE `ps_orders` ADD `round_type` TINYINT(1) NOT NULL DEFAULT '1' AFTER `round_mode` [OK] SQL 1.6.1.0 ALTER TABLE ps_product_tag ADD `id_lang` int(10) unsigned NOT NULL, ADD KEY (id_lang, id_tag) [OK] SQL 1.6.1.0 UPDATE ps_product_tag, ps_tag SET ps_product_tag.id_lang=ps_tag.id_lang WHERE ps_tag.id_tag=ps_product_tag.id_tag [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `ps_tag_count` [DROP] SQL `ps_tag_count` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_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 `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_group FROM `ps_category_group`) cg JOIN (SELECT DISTINCT id_shop FROM `ps_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `ps_category_product` cp LEFT JOIN `ps_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 `ps_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 `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_shop FROM `ps_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 `ps_shop_group` ADD KEY `deleted` (`deleted`, `name`) [WARNING] SQL 1.6.1.0 1091 in ALTER TABLE `ps_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 `ps_shop` ADD KEY `id_shop_group` (`id_shop_group`, `deleted`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_shop_url` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `ps_shop_url` ADD KEY `id_shop` (`id_shop`, `main`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_customization` ADD KEY `id_cart` (`id_cart`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_sale` ADD KEY `quantity` (`quantity`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `id_customer` (`id_customer`, `active`, `date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `group_restriction` (`group_restriction`, `active`, `date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_hook_module` ADD KEY `position` (`id_shop`, `position`) [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_cart_product` ADD PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_product` ADD KEY `id_cart_order` (`id_cart`, `date_add`, `id_product`, `id_product_attribute`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_customization` DROP KEY id_cart [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_customization` ADD KEY `id_cart_product` (`id_cart`, `id_product`, `id_product_attribute`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_category` DROP KEY nleftright, DROP KEY nleft [OK] SQL 1.6.1.0 ALTER TABLE `ps_category` ADD KEY `activenleft` (`active`,`nleft`), ADD KEY `activenright` (`active`,`nright`) [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`, `id_shop`, `cover`) [OK] SQL 1.6.1.0 ALTER TABLE ps_product_attribute_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `default_on`) [OK] SQL 1.6.1.0 UPDATE ps_product_attribute_shop, ps_product_attribute SET ps_product_attribute_shop.id_product=ps_product_attribute.id_product WHERE ps_product_attribute_shop.id_product_attribute=ps_product_attribute.id_product_attribute [OK] SQL 1.6.1.0 ALTER TABLE ps_image_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `cover`) [OK] SQL 1.6.1.0 UPDATE ps_image_shop, ps_image SET ps_image_shop.id_product=ps_image.id_product WHERE ps_image_shop.id_image=ps_image.id_image [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image_shop` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_image`, `id_shop`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_supplier` ADD KEY `id_supplier` (`id_supplier`,`id_product`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product` DROP KEY `product_manufacturer` [OK] SQL 1.6.1.0 ALTER TABLE `ps_product` ADD KEY `product_manufacturer` (`id_manufacturer`, `id_product`) [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `ps_smarty_lazy_cache` [DROP] SQL `ps_smarty_lazy_cache` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_smarty_last_flush` [DROP] SQL `ps_smarty_last_flush` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_modules_perfs` [DROP] SQL `ps_modules_perfs` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_image` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_image` SET `cover`=NULL WHERE `cover`=0 [WARNING] SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `image_transform` SELECT `id_product`, COUNT(*) c FROM `ps_image` WHERE `cover`=1 GROUP BY `id_product` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' [WARNING] SQL 1.6.1.0 1146 in UPDATE `image_transform` JOIN `ps_image` USING (`id_product`) SET `ps_image`.`cover`=NULL: Table 'watchesulike-com.image_transform' doesn't exist [OK] SQL 1.6.1.0 ALTER TABLE `ps_image` DROP KEY `id_product_cover` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image` ADD UNIQUE KEY `id_product_cover` (`id_product`,`cover`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_image_shop` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_image_shop` SET `cover`=NULL WHERE `cover`=0 [WARNING] SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `image_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `ps_image_shop` WHERE `cover`=1 GROUP BY `id_product`, `id_shop` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' [WARNING] SQL 1.6.1.0 1146 in UPDATE `image_shop_transform` JOIN `ps_image_shop` USING (`id_product`, `id_shop`) SET `ps_image_shop`.`cover`=NULL: Table 'watchesulike-com.image_shop_transform' doesn't exist [OK] SQL 1.6.1.0 ALTER TABLE `ps_image_shop` DROP KEY `id_product` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `cover`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_product_attribute` SET `default_on`=NULL WHERE `default_on`=0 [WARNING] SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `attribute_transform` SELECT `id_product`, COUNT(*) c FROM `ps_product_attribute` WHERE `default_on`=1 GROUP BY `id_product` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' [WARNING] SQL 1.6.1.0 1146 in UPDATE `attribute_transform` JOIN `ps_product_attribute` USING (`id_product`) SET `ps_product_attribute`.`default_on`=NULL: Table 'watchesulike-com.attribute_transform' doesn't exist [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute` DROP KEY `product_default` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_product_attribute` ADD UNIQUE KEY `product_default` (`id_product`,`default_on`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute_shop` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_product_attribute_shop` SET `default_on`=NULL WHERE `default_on`=0 [WARNING] SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `attribute_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `ps_product_attribute_shop` WHERE `default_on`=1 GROUP BY `id_product`, `id_shop` HAVING c>1: Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' [WARNING] SQL 1.6.1.0 1146 in UPDATE `attribute_shop_transform` JOIN `ps_product_attribute_shop` USING (`id_product`, `id_shop`) SET `ps_product_attribute_shop`.`default_on`=NULL: Table 'watchesulike-com.attribute_shop_transform' doesn't exist [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute_shop` DROP KEY `id_product` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_product_attribute_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `default_on`) [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_product_download` ADD UNIQUE KEY `id_product` (`id_product`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_customer` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `ps_customer` ADD KEY `id_shop` (`id_shop`, `date_add`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart` ADD KEY `id_shop_2` (`id_shop`,`date_upd`), ADD KEY `id_shop` (`id_shop`,`date_add`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_shop` ADD KEY `indexed` (`indexed`, `active`, `id_product`) [OK] SQL 1.6.1.0 UPDATE `ps_product_shop` SET `date_add` = NOW() WHERE `date_add` = "0000-00-00 00:00:00" [OK] SQL 1.6.1.0 INSERT IGNORE INTO `ps_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') [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `id_customer_2` (`id_customer`,`active`,`highlight`,`date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `group_restriction_2` (`group_restriction`,`active`,`highlight`,`date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_configuration_kpi` CHANGE `name` `name` varchar(64) [OK] SQL 1.6.1.0 ALTER TABLE `ps_smarty_lazy_cache` CHANGE `cache_id` `cache_id` varchar(255) NOT NULL DEFAULT '' [OK] SQL 1.6.1.0 TRUNCATE TABLE `ps_smarty_lazy_cache` [DROP] SQL `ps_cms_role` table has been dropped. [OK] SQL 1.6.1.0 /* Advanced EU Compliance tables */ CREATE TABLE IF NOT EXISTS `ps_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 `ps_cms_role_lang` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE IF NOT EXISTS `ps_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 [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `company_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl` [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `shop_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl` [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `invoice_address` TEXT DEFAULT NULL AFTER `shop_address` [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `delivery_address` TEXT DEFAULT NULL AFTER `invoice_address` [OK] SQL 1.6.1.0 INSERT INTO `ps_hook` (`name`, `title`, `description`) VALUES ('displayInvoiceLegalFreeText', 'PDF Invoice - Legal Free Text', 'This hook allows you to modify the legal free text on PDF invoices') [OK] SQL 1.6.1.0 UPDATE `ps_hook` SET position = 0 WHERE name LIKE 'action%' [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_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 `ps_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 `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_DELIVERY_ADDR_RULES', '{"avoid":["vat_number","phone","phone_mobile"]}', NOW(), NOW()) [OK] SQL 1.6.1.0 ALTER TABLE `ps_pack` ADD KEY `product_item` (`id_product_item`,`id_product_attribute_item`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_supply_order_detail` DROP KEY `id_supply_order`, DROP KEY `id_product`, ADD KEY `id_supply_order` (`id_supply_order`, `id_product`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_carrier` ADD KEY `reference` (`id_reference`, `deleted`, `active`) [OK] SQL 1.6.1.1 SET NAMES 'utf8' [OK] SQL 1.6.1.1 ALTER TABLE `ps_customer_message` CHANGE `message` `message` MEDIUMTEXT NOT NULL [OK] SQL 1.6.1.1 UPDATE `ps_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 `ps_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 IGNORE TABLE `ps_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 `ps_image_shop` ish, `ps_image` i SET ish.id_product = i.id_product WHERE i.id_image=ish.id_image [OK] SQL 1.6.1.2 REPLACE INTO `ps_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 `ps_product_tag` pt INNER JOIN `ps_product_shop` product_shop USING (id_product) JOIN (SELECT DISTINCT id_group FROM `ps_category_group`) cg WHERE product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `ps_category_product` cp LEFT JOIN `ps_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 `ps_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 `ps_product_tag` pt INNER JOIN `ps_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 `ps_smarty_last_flush` [OK] SQL 1.6.1.2 ALTER TABLE `ps_search_index` ADD INDEX(`id_product`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`id_product_attribute`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`id_shop`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`id_customer`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`from`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`to`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` DROP KEY `id_product_2` [OK] SQL 1.6.1.2 ALTER TABLE `ps_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 `ps_category_product` ADD INDEX(`id_category`, `position`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_address` CHANGE `company` `company` VARCHAR(64) NULL === end Edited December 31, 2015 by Phil.It (see edit history) Link to comment Share on other sites More sharing options...
Simonas Invertus Posted December 31, 2015 Share Posted December 31, 2015 (edited) I can answer the part of first question. versions 1.6.0.11 and 1.6.1.3 Has different tables/table formats how to store information about images. So I am guessing that product images might be displayed incorrectly after upgrade. In the future modules that support only >PS1.6.1 might not work correctly. It is not a warning nor a bug. Your SQL user does not have sufficient rights to preform one click upgrade correctly. Edited December 31, 2015 by Simonas Invertus (see edit history) Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 I can answer the part of first question. versions 1.6.0.11 and 1.6.1.3 Has different tables/table formats how to store information about images. So I am guessing that product images might be displayed incorrectly after upgrade. In the future modules that support only >PS1.6.1 might not work correctly. It is not a warning nor a bug. Your SQL user does not have sufficient rights to preform one click upgrade correctly. Hi Simonas, Congratulations for your reactivity. Well, of course, it _seems_ that the SQL user has not sufficient rights, because that is what the error log claims. But, nevertheless, it seems very odd, I would almost say "unlikely" that this user has not sufficient rights. Why? Because this PShop site has always been administered has it is now, I mean, - no specific rights have been altered on mysql DB through the years, AFAIK, - prestahop BO account I use is a superadmin, but I will double-check this. I wonder if SQL syntax of username may be wrong. It may be that it should be "'watchesulike", but not "watchesulike@localhost" but I may be wrong. __ Phil Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 I can answer the part of first question. versions 1.6.0.11 and 1.6.1.3 Has different tables/table formats how to store information about images. So I am guessing that product images might be displayed incorrectly after upgrade. In the future modules that support only >PS1.6.1 might not work correctly. It is not a warning nor a bug. Your SQL user does not have sufficient rights to preform one click upgrade correctly. Having contacted our web host vendor, it seems that our vendor has made a mistake somehow somewhere sometime and forgot to grant enough access. This is pretty disappointing towards our vendor. It must be a recent mistake, otherwise we couldn't have gone so far without those rigths. I have to rollback all the site and try a new 1CU. Then I will update this post. Thanks for you help. Link to comment Share on other sites More sharing options...
bellini13 Posted December 31, 2015 Share Posted December 31, 2015 this is why you always make a copy of your store and test the upgrade process first... Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 (edited) this is why you always make a copy of your store and test the upgrade process first... Quite right. Or at least make backup and check them. So, I restored my environment, ran 1CU again, which went fine apart 2 warnings again, but those were not presented as errors, so they may be "true" warnings only. Here they are. [WARNING] SQL 1.6.1.0 1091 in ALTER TABLE `ps_shop` DROP KEY `id_shop_group`: Can't DROP 'id_shop_group'; check that column/key exists [WARNING] SQL 1.6.1.1 1060 in ALTER TABLE `ps_order_detail` ADD `original_wholesale_price` DECIMAL( 20, 6 ) NOT NULL DEFAULT '0.000000': Duplicate column name 'original_wholesale_price' The first one might be due to the fact that my shop does not use multi-shop. I have no clue for the latter. I mean: I know what they do and why they fail: #1 : tries to drop a column which does not exists - so it fails. #2 : tries to add a column which does exists - so it fails. But I do not know the reason behind why this situation was brought: a bug or lazy coding or what else ? Here they are in context: === Full sql log [OK] SQL 1.6.0.12 SET NAMES 'utf8' [OK] SQL 1.6.0.12 INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CUSTOMER_NWSL', 1, NOW(), NOW()), ('PS_CUSTOMER_OPTIN', 1, NOW(), NOW()) [OK] SQL 1.6.0.12 INSERT INTO `ps_order_state` (`invoice`, `send_email`, `module_name`, `color`, `unremovable`, `hidden`, `logable`, `delivery`, `shipped`, `paid`, `deleted`) VALUES ('0', '0', 'cashondelivery', '#4169E1', '1', '0', '0', '0', '0', '0', '0') [OK] SQL 1.6.0.12 SET @id_order_state = LAST_INSERT_ID() [OK] SQL 1.6.0.12 INSERT INTO `ps_order_state_lang` (`id_order_state`, `id_lang`, `name`, `template`) (SELECT @id_order_state, id_lang, 'Waiting cod validation', '' FROM `ps_lang`) [OK] SQL 1.6.0.12 INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_OS_COD_VALIDATION', @id_order_state, NOW(), NOW()) [OK] SQL 1.6.0.12 UPDATE `ps_hook` set `position` = 1 where `name` in ('displayBanner', 'displayNav', 'displayTopColumn') [OK] SQL 1.6.0.12 ALTER TABLE `ps_product` ADD `pack_stock_type` int(11) UNSIGNED DEFAULT '3' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_shop` ADD `pack_stock_type` int(11) UNSIGNED DEFAULT '3' [OK] SQL 1.6.0.12 ALTER TABLE `ps_pack` ADD `id_product_attribute_item` int(10) UNSIGNED NOT NULL AFTER `id_product_item` [OK] SQL 1.6.0.12 ALTER TABLE `ps_pack` DROP PRIMARY KEY [OK] SQL 1.6.0.12 ALTER TABLE `ps_pack` ADD PRIMARY KEY (`id_product_pack`, `id_product_item`, `id_product_attribute_item`) [OK] SQL 1.6.0.12 ALTER TABLE `ps_order_state` ADD `pdf_delivery` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `paid` [OK] SQL 1.6.0.12 ALTER TABLE `ps_order_state` ADD `pdf_invoice` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `pdf_delivery` [OK] SQL 1.6.0.12 ALTER TABLE `ps_orders` CHANGE `shipping_number` `shipping_number` VARCHAR( 64 ) [OK] SQL 1.6.0.12 ALTER TABLE `ps_store` CHANGE `hours` `hours` TEXT [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang` [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cms`, `id_shop`, `id_lang`) [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_category_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang` [OK] SQL 1.6.0.12 ALTER TABLE `ps_cms_category_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cms_category`, `id_shop`, `id_lang`) [DROP] SQL `ps_cms_category_shop` table has been dropped. [OK] SQL 1.6.0.12 CREATE TABLE `ps_cms_category_shop` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_cms_category`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 [OK] SQL 1.6.0.12 ALTER TABLE `ps_customization_field_lang` ADD `id_shop` INT(10) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang` [OK] SQL 1.6.0.12 ALTER TABLE `ps_customization_field_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_customization_field`, `id_shop`, `id_lang`) [OK] SQL 1.6.0.12 ALTER TABLE `ps_product` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_shop` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_attribute` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_product_attribute_shop` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00' [OK] SQL 1.6.0.12 ALTER TABLE `ps_module_access` CHANGE `view` `view` TINYINT( 1 ) NOT NULL DEFAULT '0', CHANGE `configure` `configure` TINYINT( 1 ) NOT NULL DEFAULT '0', CHANGE `uninstall` `uninstall` TINYINT( 1 ) NOT NULL DEFAULT '0' [OK] SQL 1.6.1.0 SET NAMES 'utf8' [OK] SQL 1.6.1.0 UPDATE `ps_configuration` SET `value` = CONCAT('#', `value`) WHERE `name` LIKE 'PS_%_PREFIX' AND `value` NOT LIKE '#%' [OK] SQL 1.6.1.0 UPDATE `ps_configuration_lang` SET `value` = CONCAT('#', `value`) WHERE `id_configuration` IN (SELECT `id_configuration` FROM `ps_configuration` WHERE `name` LIKE 'PS_%_PREFIX') AND `value` NOT LIKE '#%' [OK] SQL 1.6.1.0 ALTER TABLE `ps_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 `ps_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' [OK] SQL 1.6.1.0 ALTER TABLE `ps_orders` ADD `round_type` TINYINT(1) NOT NULL DEFAULT '1' AFTER `round_mode` [OK] SQL 1.6.1.0 ALTER TABLE ps_product_tag ADD `id_lang` int(10) unsigned NOT NULL, ADD KEY (id_lang, id_tag) [OK] SQL 1.6.1.0 UPDATE ps_product_tag, ps_tag SET ps_product_tag.id_lang=ps_tag.id_lang WHERE ps_tag.id_tag=ps_product_tag.id_tag [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `ps_tag_count` [DROP] SQL `ps_tag_count` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_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 `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_group FROM `ps_category_group`) cg JOIN (SELECT DISTINCT id_shop FROM `ps_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `ps_category_product` cp LEFT JOIN `ps_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 `ps_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 `ps_product_tag` pt LEFT JOIN `ps_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `ps_product` p ON (p.id_product = pt.id_product) INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_shop FROM `ps_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] SQL 1.6.1.0 ALTER TABLE `ps_shop_group` ADD KEY `deleted` (`deleted`, `name`) [WARNING] SQL 1.6.1.0 1091 in ALTER TABLE `ps_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 `ps_shop` ADD KEY `id_shop_group` (`id_shop_group`, `deleted`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_shop_url` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `ps_shop_url` ADD KEY `id_shop` (`id_shop`, `main`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_customization` ADD KEY `id_cart` (`id_cart`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_sale` ADD KEY `quantity` (`quantity`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `id_customer` (`id_customer`, `active`, `date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `group_restriction` (`group_restriction`, `active`, `date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_hook_module` ADD KEY `position` (`id_shop`, `position`) [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_cart_product` ADD PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_product` ADD KEY `id_cart_order` (`id_cart`, `date_add`, `id_product`, `id_product_attribute`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_customization` DROP KEY id_cart [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_customization` ADD KEY `id_cart_product` (`id_cart`, `id_product`, `id_product_attribute`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_category` DROP KEY nleftright, DROP KEY nleft [OK] SQL 1.6.1.0 ALTER TABLE `ps_category` ADD KEY `activenleft` (`active`,`nleft`), ADD KEY `activenright` (`active`,`nright`) [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`, `id_shop`, `cover`) [OK] SQL 1.6.1.0 ALTER TABLE ps_product_attribute_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `default_on`) [OK] SQL 1.6.1.0 UPDATE ps_product_attribute_shop, ps_product_attribute SET ps_product_attribute_shop.id_product=ps_product_attribute.id_product WHERE ps_product_attribute_shop.id_product_attribute=ps_product_attribute.id_product_attribute [OK] SQL 1.6.1.0 ALTER TABLE ps_image_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `cover`) [OK] SQL 1.6.1.0 UPDATE ps_image_shop, ps_image SET ps_image_shop.id_product=ps_image.id_product WHERE ps_image_shop.id_image=ps_image.id_image [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image_shop` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_image`, `id_shop`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_supplier` ADD KEY `id_supplier` (`id_supplier`,`id_product`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product` DROP KEY `product_manufacturer` [OK] SQL 1.6.1.0 ALTER TABLE `ps_product` ADD KEY `product_manufacturer` (`id_manufacturer`, `id_product`) [OK] SQL 1.6.1.0 DROP TABLE IF EXISTS `ps_smarty_lazy_cache` [DROP] SQL `ps_smarty_lazy_cache` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_smarty_last_flush` [DROP] SQL `ps_smarty_last_flush` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_modules_perfs` [DROP] SQL `ps_modules_perfs` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE `ps_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 `ps_image` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_image` SET `cover`=NULL WHERE `cover`=0 [OK] SQL 1.6.1.0 CREATE TEMPORARY TABLE `image_transform` SELECT `id_product`, COUNT(*) c FROM `ps_image` WHERE `cover`=1 GROUP BY `id_product` HAVING c>1 [OK] SQL 1.6.1.0 UPDATE `image_transform` JOIN `ps_image` USING (`id_product`) SET `ps_image`.`cover`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `ps_image` DROP KEY `id_product_cover` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image` ADD UNIQUE KEY `id_product_cover` (`id_product`,`cover`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_image_shop` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_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 `ps_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 `ps_image_shop` USING (`id_product`, `id_shop`) SET `ps_image_shop`.`cover`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `ps_image_shop` DROP KEY `id_product` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_image_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `cover`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_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 `ps_product_attribute` WHERE `default_on`=1 GROUP BY `id_product` HAVING c>1 [OK] SQL 1.6.1.0 UPDATE `attribute_transform` JOIN `ps_product_attribute` USING (`id_product`) SET `ps_product_attribute`.`default_on`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute` DROP KEY `product_default` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_product_attribute` ADD UNIQUE KEY `product_default` (`id_product`,`default_on`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute_shop` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL [OK] SQL 1.6.1.0 UPDATE `ps_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 `ps_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 `ps_product_attribute_shop` USING (`id_product`, `id_shop`) SET `ps_product_attribute_shop`.`default_on`=NULL [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_attribute_shop` DROP KEY `id_product` [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_product_attribute_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `default_on`) [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_product_download` ADD UNIQUE KEY `id_product` (`id_product`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_customer` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `ps_customer` ADD KEY `id_shop` (`id_shop`, `date_add`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart` DROP KEY `id_shop` [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart` ADD KEY `id_shop_2` (`id_shop`,`date_upd`), ADD KEY `id_shop` (`id_shop`,`date_add`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_product_shop` ADD KEY `indexed` (`indexed`, `active`, `id_product`) [OK] SQL 1.6.1.0 UPDATE `ps_product_shop` SET `date_add` = NOW() WHERE `date_add` = "0000-00-00 00:00:00" [OK] SQL 1.6.1.0 INSERT IGNORE INTO `ps_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') [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `id_customer_2` (`id_customer`,`active`,`highlight`,`date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_cart_rule` ADD KEY `group_restriction_2` (`group_restriction`,`active`,`highlight`,`date_to`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_configuration_kpi` CHANGE `name` `name` varchar(64) [OK] SQL 1.6.1.0 ALTER TABLE `ps_smarty_lazy_cache` CHANGE `cache_id` `cache_id` varchar(255) NOT NULL DEFAULT '' [OK] SQL 1.6.1.0 TRUNCATE TABLE `ps_smarty_lazy_cache` [DROP] SQL `ps_cms_role` table has been dropped. [OK] SQL 1.6.1.0 /* Advanced EU Compliance tables */ CREATE TABLE IF NOT EXISTS `ps_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 `ps_cms_role_lang` table has been dropped. [OK] SQL 1.6.1.0 CREATE TABLE IF NOT EXISTS `ps_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 [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `company_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl` [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `shop_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl` [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `invoice_address` TEXT DEFAULT NULL AFTER `shop_address` [OK] SQL 1.6.1.0 ALTER TABLE `ps_order_invoice` ADD `delivery_address` TEXT DEFAULT NULL AFTER `invoice_address` [OK] SQL 1.6.1.0 INSERT INTO `ps_hook` (`name`, `title`, `description`) VALUES ('displayInvoiceLegalFreeText', 'PDF Invoice - Legal Free Text', 'This hook allows you to modify the legal free text on PDF invoices') [OK] SQL 1.6.1.0 UPDATE `ps_hook` SET position = 0 WHERE name LIKE 'action%' [OK] SQL 1.6.1.0 ALTER IGNORE TABLE `ps_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 `ps_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 `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_DELIVERY_ADDR_RULES', '{"avoid":["vat_number","phone","phone_mobile"]}', NOW(), NOW()) [OK] SQL 1.6.1.0 ALTER TABLE `ps_pack` ADD KEY `product_item` (`id_product_item`,`id_product_attribute_item`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_supply_order_detail` DROP KEY `id_supply_order`, DROP KEY `id_product`, ADD KEY `id_supply_order` (`id_supply_order`, `id_product`) [OK] SQL 1.6.1.0 ALTER TABLE `ps_carrier` ADD KEY `reference` (`id_reference`, `deleted`, `active`) [OK] SQL 1.6.1.1 SET NAMES 'utf8' [OK] SQL 1.6.1.1 ALTER TABLE `ps_customer_message` CHANGE `message` `message` MEDIUMTEXT NOT NULL [OK] SQL 1.6.1.1 UPDATE `ps_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 `ps_order_detail` ADD `original_wholesale_price` DECIMAL( 20, 6 ) NOT NULL DEFAULT '0.000000': Duplicate column name 'original_wholesale_price' [OK] SQL 1.6.1.1 ALTER IGNORE TABLE `ps_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 `ps_image_shop` ish, `ps_image` i SET ish.id_product = i.id_product WHERE i.id_image=ish.id_image [OK] SQL 1.6.1.2 REPLACE INTO `ps_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 `ps_product_tag` pt INNER JOIN `ps_product_shop` product_shop USING (id_product) JOIN (SELECT DISTINCT id_group FROM `ps_category_group`) cg WHERE product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `ps_category_product` cp LEFT JOIN `ps_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 `ps_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 `ps_product_tag` pt INNER JOIN `ps_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 `ps_smarty_last_flush` [OK] SQL 1.6.1.2 ALTER TABLE `ps_search_index` ADD INDEX(`id_product`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`id_product_attribute`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`id_shop`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`id_customer`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`from`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` ADD INDEX(`to`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_specific_price` DROP KEY `id_product_2` [OK] SQL 1.6.1.2 ALTER TABLE `ps_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 `ps_category_product` ADD INDEX(`id_category`, `position`) [OK] SQL 1.6.1.2 ALTER TABLE `ps_address` CHANGE `company` `company` VARCHAR(64) NULL === end __ Phil Edited December 31, 2015 by Phil.It (see edit history) Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 Some news. I have been digging around. Warning #1 : [WARNING] SQL 1.6.1.0 1091 in ALTER TABLE `ps_shop` DROP KEY `id_shop_group`: Can't DROP 'id_shop_group'; check that column/key exists Firstly, yes, it is about a key, not a column. Secondly, it seems strange to me, but I noticed that regarding the DB _before_ upgrading, in 6 different tables, which posess a "id_shop_group" column, the key on that column was reversed, that is, the key on column 'id_shop_group' was named 'id_group_shop' (exchanging the position of the 2 words group and shop) I think this upgrade contains a fixup to correct key name, that is to rename key 'id_group_shop' to id_shop_group' So the resulting warning may be a true warning, when trying to first clear the key and then add the right named one. Warning #2 [WARNING] SQL 1.6.1.1 1060 in ALTER TABLE `ps_order_detail` ADD `original_wholesale_price` DECIMAL( 20, 6 ) NOT NULL DEFAULT '0.000000': Duplicate column name 'original_wholesale_price' I have checked in the current DB, this column is already defined as this sql instruction tries to make it. So, this is not a problem, I think. End of the story. Thanks for your input to all. __ Phil.It Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 So, to sum up, these two remaining warnings doesnot seem to indicate a problem. I marked it solved. Unless someone would want to add a comment? Bye for now and thanks for your time and help. __ Phil.IT Link to comment Share on other sites More sharing options...
Simonas Invertus Posted January 4, 2016 Share Posted January 4, 2016 At this point I am guessing, but from errors it looks like that when you did a rollback, database for some reasons did not rolled back and was left at the state it was after upgrade. Then you click upgrade again it does not expect to find these things so it throws warnings. Good luck. Link to comment Share on other sites More sharing options...
Phil.It Posted January 4, 2016 Author Share Posted January 4, 2016 At this point I am guessing, but from errors it looks like that when you did a rollback, database for some reasons did not rolled back and was left at the state it was after upgrade. Then you click upgrade again it does not expect to find these things so it throws warnings. Good luck. If this was the case, I would need more than luck! That db would be a total mess. No, I think your guess is not accurate, db was cleared and loaded again, not trying a simple "rollback". Thanks anyway and Happy new year. 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