cyril84 Posted December 20, 2011 Share Posted December 20, 2011 Bonjour Lors du passage de la boutique de la v1.4.5.1 vers v1.4.6.2 en local je me retoruve avec l'erreur suivante: Malheureusement, 1 erreurs SQL sont apparues. dont voici la liste SET NAMES 'utf8' /* PHP:update_order_canada(); */ CREATE TABLE IF NOT EXISTS `compare` ( `id_compare` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_customer` int(10) unsigned NOT NULL, PRIMARY KEY (`id_compare`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ALTER TABLE `compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer` ALTER TABLE `compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY( `id_compare`, `id_product`) (1062) Duplicate entry '0-1' for key 'PRIMARY' ALTER TABLE `store` CHANGE `latitude` `latitude` DECIMAL(11, 8) NULL DEFAULT NULL ALTER TABLE `store` CHANGE `longitude` `longitude` DECIMAL(11, 8) NULL DEFAULT NULL ALTER TABLE `address_format` ADD PRIMARY KEY (`id_country`) ALTER TABLE `address_format` DROP INDEX `country` /* PHP:hook_blocksearch_on_header(); */ SET NAMES 'utf8' SET NAMES 'utf8' INSERT IGNORE INTO `configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LIMIT_UPLOAD_IMAGE_VALUE', '2', NOW(), NOW()), ('PS_LIMIT_UPLOAD_FILE_VALUE', '2', NOW(), NOW()) Auriez vous une idée, car la boutique m'a l'air de fonctionner ? Est-ce grave docteur Amicalement Link to comment Share on other sites More sharing options...
Oron Posted December 22, 2011 Share Posted December 22, 2011 Bonjour Apparemment c'est la table des comparaisons donc suffit de tester la comparaison entre vos différents produits. Et pour le bloc de recherche donc tester la recherche avec des nom de vos produits. 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