rsanzures Posted June 1, 2010 Share Posted June 1, 2010 Buenas Noches a todos, estoy actualziando mi tienda de la version 1.1.0.5 a la version 1.3, al pasar al paso 4Me da los siguientes errores, y SET NAMES 'utf8'/* ##################################### */ /* STRUCTURE */ /* ##################################### */ DROP TABLE IF EXISTS ps_order_customization_returnALTER 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 existsALTER 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 NULLALTER 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 definedALTER TABLE ps_connections CHANGE `http_referer` `http_referer` VARCHAR(255) DEFAULT NULLALTER 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 existsALTER TABLE ps_hook_module ADD PRIMARY KEY (id_module,id_hook)(1068) Multiple primary key definedALTER TABLE ps_hook_module ADD INDEX id_module (`id_module`)(1061) Duplicate key name '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 NULLALTER 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 CHANGE `name` `name` VARCHAR(255) NOT NULLALTER TABLE ps_page_type ADD INDEX `name` (`name`)(1061) Duplicate key name 'name'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 definedALTER TABLE ps_image_lang ADD INDEX id_image (id_image)(1061) Duplicate key name 'id_image'ALTER TABLE ps_range_price CHANGE `delimiter1` `delimiter1` DECIMAL(13, 6) NOT NULLALTER TABLE ps_range_price CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULLALTER TABLE ps_range_price CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULLALTER TABLE ps_range_price DROP INDEX `range_price_unique`(1091) Can't DROP 'range_price_unique'; check that column/key existsALTER 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 NULLALTER TABLE ps_range_weight CHANGE `delimiter2` `delimiter2` DECIMAL(13, 6) NOT NULLALTER TABLE ps_range_weight CHANGE `id_carrier` `id_carrier` INT(10) UNSIGNED NOT NULLALTER TABLE ps_range_weight DROP INDE Link to comment Share on other sites More sharing options...
4webs.es Posted June 1, 2010 Share Posted June 1, 2010 ya tienes las tablas....DROP TABLE IF EXISTS Link to comment Share on other sites More sharing options...
rsanzures Posted June 2, 2010 Author Share Posted June 2, 2010 Si tengo creadas la tablasporque estas funcionan con la version 1.1.0.5 Link to comment Share on other sites More sharing options...
shacker Posted June 5, 2010 Share Posted June 5, 2010 Si tengo creadas la tablasporque estas funcionan con la version 1.1.0.5 prueba actualizarlo por pasos, primero a 1.2 y despues a 1.3 Link to comment Share on other sites More sharing options...
Recommended Posts