Jump to content
Sign in to follow this  
MANJES

Gros problème de base sql suite à migration Version 1.1.0.5 à Version 1.2.2.0

Recommended Posts

Voici les erreurs sql que j'ai suite à migration et je ne sais pas les résoudres.
Merci de bien vouloir m'aider.

SET NAMES 'utf8'

/* ##################################### */ /* STRUCTURE */ /* ##################################### */ DROP TABLE IF EXISTS ps_order_customization_return

ALTER TABLE ps_cart ADD id_guest INT UNSIGNED NULL AFTER id_customer

(1060) Duplicate column name 'id_guest'
ALTER TABLE ps_tab ADD `module` varchar(64) NULL AFTER class_name

(1060) Duplicate column name 'module'
ALTER TABLE ps_product ADD `indexed` tinyint(1) NOT NULL default '0' AFTER `active`

(1060) Duplicate column name 'indexed'
ALTER TABLE ps_orders DROP INDEX `orders_customer`

(1091) Can't DROP 'orders_customer'; check that column/key exists
ALTER TABLE ps_orders ADD INDEX id_customer (id_customer)

(1061) Duplicate key name 'id_customer'
ALTER TABLE ps_orders ADD valid INTEGER(1) UNSIGNED NOT NULL DEFAULT '0' AFTER delivery_date

(1060) Duplicate column name 'valid'
ALTER TABLE ps_orders ADD INDEX `id_cart` (`id_cart`)

(1061) Duplicate key name 'id_cart'
ALTER TABLE ps_customer ADD deleted TINYINT(1) NOT NULL DEFAULT '0' AFTER active

(1060) Duplicate column name 'deleted'
ALTER TABLE ps_employee ADD stats_date_to DATE NULL DEFAULT NULL AFTER last_passwd_gen

(1060) Duplicate column name 'stats_date_to'
ALTER TABLE ps_employee ADD stats_date_from DATE NULL DEFAULT NULL AFTER last_passwd_gen

(1060) Duplicate column name 'stats_date_from'
ALTER TABLE ps_order_state ADD hidden TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER unremovable

(1060) Duplicate column name 'hidden'
ALTER TABLE ps_carrier ADD is_module TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER range_behavior

(1060) Duplicate column name 'is_module'
ALTER TABLE ps_carrier ADD INDEX deleted (`deleted`, `active`)

(1061) Duplicate key name 'deleted'
ALTER TABLE ps_state CHANGE iso_code `iso_code` char(4) NOT NULL

ALTER TABLE ps_order_detail CHANGE product_quantity_cancelled product_quantity_refunded INT(10) UNSIGNED NOT NULL DEFAULT '0'

(1054) Unknown column 'product_quantity_cancelled' in 'ps_order_detail'
ALTER TABLE ps_order_detail ADD INDEX product_id (product_id)

(1061) Duplicate key name 'product_id'
ALTER TABLE ps_attribute_lang ADD INDEX id_lang (`id_lang`, `name`)

(1061) Duplicate key name 'id_lang'
ALTER TABLE ps_attribute_lang ADD INDEX id_lang_2 (`id_lang`)

ALTER TABLE ps_attribute_lang ADD INDEX id_attribute (`id_attribute`)

ALTER TABLE ps_block_cms ADD PRIMARY KEY (`id_block`, `id_cms`)

(1068) Multiple primary key defined
ALTER TABLE ps_connections CHANGE `http_referer` `http_referer` VARCHAR(255) DEFAULT NULL

ALTER TABLE ps_connections ADD INDEX `date_add` (`date_add`)

(1061) Duplicate key name 'date_add'
ALTER TABLE ps_customer DROP INDEX `customer_email`

ALTER TABLE ps_customer ADD UNIQUE `customer_email` (`email`)

ALTER TABLE ps_delivery ADD INDEX id_zone (`id_zone`)

(1061) Duplicate key name 'id_zone'
ALTER TABLE ps_delivery ADD INDEX id_carrier (`id_carrier`, `id_zone`)

(1061) Duplicate key name 'id_carrier'
ALTER TABLE ps_discount_category ADD INDEX id_category (`id_category`)

ALTER TABLE ps_feature_product ADD INDEX `id_feature` (`id_feature`)

ALTER TABLE ps_hook_module DROP INDEX `hook_module_index`

(1091) Can't DROP 'hook_module_index'; check that column/key exists
ALTER TABLE ps_hook_module ADD PRIMARY KEY (id_module,id_hook)

(1068) Multiple primary key defined
ALTER TABLE ps_hook_module ADD INDEX id_module (`id_module`)

ALTER TABLE ps_hook_module ADD INDEX id_hook (`id_hook`)

(1061) Duplicate key name 'id_hook'
ALTER TABLE ps_module CHANGE `active` `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE ps_page CHANGE `id_object` `id_object` INT UNSIGNED NULL DEFAULT NULL

ALTER TABLE ps_page ADD INDEX `id_page_type` (`id_page_type`)

(1061) Duplicate key name 'id_page_type'
ALTER TABLE ps_page ADD INDEX `id_object` (`id_object`)

(1061) Duplicate key name 'id_object'
ALTER TABLE ps_page_type ADD INDEX `name` (`name`)

(1061) Duplicate key name 'name'
ALTER TABLE ps_page_type CHANGE `name` `name` VARCHAR(255) NOT NULL

ALTER TABLE ps_product_attribute ADD INDEX reference (reference)

(1061) Duplicate key name 'reference'
ALTER TABLE ps_product_attribute ADD INDEX supplier_reference (supplier_reference)

(1061) Duplicate key name 'supplier_reference'
ALTER TABLE ps_product_lang ADD INDEX id_product (id_product)

ALTER TABLE ps_product_lang ADD INDEX id_lang (id_lang)

(1061) Duplicate key name 'id_lang'
ALTER TABLE ps_product_lang ADD INDEX `name` (`name`)

(1061) Duplicate key name 'name'
ALTER TABLE ps_product_lang ADD FULLTEXT KEY ftsname (`name`)

ALTER TABLE ps_cart_discount ADD INDEX `id_discount` (`id_discount`)

(1061) Duplicate key name 'id_discount'
ALTER TABLE ps_discount_category ADD PRIMARY KEY (id_category,id_discount)

(1068) Multiple primary key defined
ALTER TABLE ps_image_lang ADD INDEX id_image (id_image)

ALTER TABLE ps_range_price CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL

ALTER TABLE ps_range_price CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL

ALTER TABLE ps_range_price CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL

ALTER TABLE ps_range_price DROP INDEX `range_price_unique`

(1091) Can't DROP 'range_price_unique'; check that column/key exists
ALTER TABLE ps_range_price ADD UNIQUE KEY `id_carrier` (`id_carrier`,`delimiter1`,`delimiter2`)

(1061) Duplicate key name 'id_carrier'
ALTER TABLE ps_range_weight CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULL

ALTER TABLE ps_range_weight CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULL

ALTER TABLE ps_range_weight CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULL

ALTER TABLE ps_range_weight DROP INDEX `range_weight_unique`

(1091) Can't DROP 'range_weight_unique'; check that column/key exists
ALTER TABLE

Share this post


Link to post
Share on other sites

i have the same problem.

i think its because of database prefix change...

any one can solve this ?

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More