Phil.It Posted December 31, 2015 Share Posted December 31, 2015 Hello HappyPrestashoppers, 1. Je viens d'utiliser 1CU (1-Click-Upgrade) : 1.6.0.11 ===> 1.6.1.3 Pour information, j'ai l'habitude d'utiliser 1CU. 2. L'Upgrade s'est bien déroulé, à part 3+3 erreurs in SQL Voir ci-dessous : (et désolé si c'est trop long, je réduirai si nécessaire par un edit) - log: erreurs - log : mise à jour SQL complète 3. D'après la log, il semblerait que 3 tables sql temporaires n'ont pas pu être créees, pour des raisons de droits. Par conséquence, les 3 ordres d'update sur ces tables inexistantes n'ont pas pu s'effectuer. 4. Pour autant que je puisse constater le Back-office et Front-Office ont l'air normaux, mais je n'ai efectué aucune mise à jour de données, je veux comprendre avant ce qui a raté. 5. Puis-je savoir: - Ce qu'en pense la Prestashop Team? - Quelles sont les conséquences? - Est-ce de l'ordre du simple warning, ou bien est-ce un bug de 1CU? - La base de données est-elle incohérente (vérolée) maintenant? - Que devrais-je faire maintenant? __ 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 Link to comment Share on other sites More sharing options...
tuk66 Posted December 31, 2015 Share Posted December 31, 2015 Access denied for user 'watchesulike'@'localhost' to database 'watchesulike-com' Vérifiez si l'utilisateur de base de données peut créer des tableaux. Check if the database user can create tables. Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 Vérifiez si l'utilisateur de base de données peut créer des tableaux. Check if the database user can create tables. Bonjour, Félicitations pour la réponse rapide. J'ai compris votre réponse, mais je serai surpris que ce soit la vraie raison. Je veux dire que rien n'a été changé sur la DB mysql, et que j'utilise un profil superadmin depuis le BO pour le 1CU. J'utilise ce site depuis des années et toutes les opérations d'admin en BO se déroulent normalement depuis tout ce temps. Et comme aucun droit n'a été modifié sur la DB SQL, je doute que d'un seul coup, ce compte-user ait des problèmes d'un seul coup pour créer des tables, alors qu'il a déjà fait toutes les mises à jour et des upgrade depuis la version 1.4 de PS. Est-il possible que ce soit un problème de syntaxe SQL : le code SQL essaye de créer la table avec "watchulike@localhost" mais ne serait-ce pas avec le simple nom du compte "watchesulike" sans le localhost qui aurait dû être codé? __ Phil Link to comment Share on other sites More sharing options...
tuk66 Posted December 31, 2015 Share Posted December 31, 2015 "Accès refusé" parle pour lui. Il est sur les autorisations de base de données. "Access denied" speaks for itself. It is about database permissions. Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 "Accès refusé" parle pour lui. Il est sur les autorisations de base de données. "Access denied" speaks for itself. It is about database permissions. Thanks for your answer. I know what "acces denied" means - I have been working in IT for thirty years, with a lot of kind of DB, SQL or not, from DbaseII to PostgreSQL and MySQL. My point is: is it possible that using account name "watchesulike@localhost" instead of just plain and simple "watchesulike" may habe induced this denied access? I am gonna try creating tables using mysql command-line. Link to comment Share on other sites More sharing options...
tuk66 Posted December 31, 2015 Share Posted December 31, 2015 "watchesulike@localhost" means user watchesulike at server localhost. I suppose the database server is located at localhost. Link to comment Share on other sites More sharing options...
Phil.It Posted December 31, 2015 Author Share Posted December 31, 2015 "watchesulike@localhost" means user watchesulike at server localhost. I suppose the database server is located at localhost. Well, it seems that our host 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...
doekia Posted January 2, 2016 Share Posted January 2, 2016 1/ Your user does not have the rights for temporary object (sad but unfortunatly true on some hosters) Link to comment Share on other sites More sharing options...
Phil.It Posted January 2, 2016 Author Share Posted January 2, 2016 1/ Your user does not have the rights for temporary object (sad but unfortunatly true on some hosters) Yeak, Thanks Doekia, It appeared to be so. I am angry at our hoster. Bye for now, all is fine. 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