Hallo zusammen,
ich habe so ein ähnliches Problem. Ich will ein Update von
v1.06 rev 4642 SP2 dated: 2014-08-12, Datenbank Version: "MOD_1.0.6.0", PHP-Version 5.5.9
nach
v2.0.5.0 rev 12487 dated: 2019-12-13, Datenbank Version: "MOD_2.0.5.0", PHP-Version 5.6.40
machen. Ich habe root Zugriff, kann immer die passende PHP-Version einstellen etc.
Ich verwende den Installer von v2.0.5.0 rev 12487
Das DB-Struktur update und die Updates
update_1.0.6.0_to_1.0.6.1.sql
update_1.0.6.1_to_1.0.6.2.sql
update_1.0.6.2_to_1.0.6.3.sql
update_1.0.6.3_to_1.0.6.4.sql
laufen ohne Fehler durch.
Jedoch gibt es eine ganze Seite Fehlermeldungen beim update_1.0.6.4_to_2.0.0.0.sql, siehe weiter unten.
Ich hatte zuvor alle Zahlungs- Versand- und sonst-wie Module gemäß Anleitung im _install Verzeichnis deinstalliert und sonstige Hinweise beherzigt.
Wenn ich in der SSH das Update
mysql -u datenbankuser -p datenbank_ < update_1.0.6.4_to_2.0.0.0.sql
manuell ausführe, kommt nur eine einzige Fehlermeldung
ERROR 1061 (42000) at line 144: Duplicate key name 'idx_code'
Vermutlich bricht das manuelle Update in der SSH an dieser Stelle ab.
Ich habe diese Schleife in mehreren Varianten durchgespielt und bleibe immer hier (update_1.0.6.4_to_2.0.0.0.sql) hängen.
Kann mir einer sagen, was ich falsch mache bzw. was ich besser machen soll?
Danke.
Hier die Fehlermeldungen:
update_1.0.6.4_to_2.0.0.0.sql im Installer
Mit Fehlern ausgeführt:
ALTER TABLE `currencies` ADD UNIQUE KEY `idx_code` (`code`)
ALTER TABLE `products_options_values_to_products_options` ADD KEY `idx_products_options_id` (`products_options_id`)
ALTER TABLE whos_online ADD PRIMARY KEY (session_id)
CREATE TABLE module_backup ( configuration_id int(11) NOT NULL AUTO_INCREMENT, configuration_key varchar(64) NOT NULL, configuration_value text NOT NULL, last_modified datetime DEFAULT NULL, PRIMARY KEY (configuration_id), UNIQUE idx_configuration_key (configuration_key) )
ALTER TABLE orders DROP cc_type
ALTER TABLE orders DROP cc_owner
ALTER TABLE orders DROP cc_number
ALTER TABLE orders DROP cc_expires
ALTER TABLE orders DROP cc_start
ALTER TABLE orders DROP cc_issue
ALTER TABLE orders DROP cc_cvv
ALTER TABLE admin_access DROP blacklist
ALTER TABLE admin_access CHANGE fck_wrapper filemanager INT(1) NOT NULL DEFAULT 0
ALTER TABLE products_vpe ADD PRIMARY KEY (products_vpe_id, language_id)
ALTER TABLE products_xsell_grp_name ADD PRIMARY KEY (products_xsell_grp_name_id, language_id)
ALTER TABLE countries ADD UNIQUE idx_countries_iso_code_2 (countries_iso_code_2)
ALTER TABLE countries ADD UNIQUE idx_countries_iso_code_3 (countries_iso_code_3)
ALTER TABLE coupon_gv_customer DROP INDEX customer_id
ALTER TABLE coupons_description DROP INDEX coupon_id
ALTER TABLE coupons_description ADD PRIMARY KEY (coupon_id, language_id)
ALTER TABLE coupon_email_track ADD UNIQUE idx_coupon_id (coupon_id)
ALTER TABLE customers_status DROP INDEX idx_orders_status_name
ALTER TABLE customers_status ADD UNIQUE idx_customers_status_name (customers_status_name, language_id)
ALTER TABLE campaigns ADD UNIQUE idx_campaigns_refID (campaigns_refID)
ALTER TABLE banners_history ADD KEY idx_banners_id (banners_id)
ALTER TABLE languages ADD UNIQUE idx_code (code)
ALTER TABLE content_manager DROP INDEX content_meta_title
ALTER TABLE content_manager ADD KEY idx_content_group (content_group)
ALTER TABLE customers ADD KEY idx_customers_email_address (customers_email_address)
ALTER TABLE customers_ip DROP INDEX customers_id
ALTER TABLE customers_ip ADD KEY idx_customers_id (customers_id)
ALTER TABLE newsletter_recipients ADD UNIQUE idx_customers_email_address (customers_email_address)
ALTER TABLE newsletter_recipients ADD KEY idx_mail_key (mail_key)
ALTER TABLE orders_products_attributes ADD KEY idx_orders_id (orders_id)
ALTER TABLE orders_products_attributes ADD KEY idx_orders_products_id (orders_products_id)
ALTER TABLE orders_products_download ADD KEY idx_orders_id (orders_id)
ALTER TABLE orders_products_download ADD KEY idx_orders_products_id (orders_products_id)
ALTER TABLE orders_total DROP INDEX idx_orders_total_orders_id
ALTER TABLE orders_total ADD KEY idx_orders_id (orders_id)
ALTER TABLE products ADD KEY idx_products_status (products_status)
ALTER TABLE products_description DROP INDEX products_name
ALTER TABLE products_description ADD KEY idx_products_name (products_name)
ALTER TABLE products_graduated_prices DROP INDEX products_id
ALTER TABLE products_graduated_prices ADD KEY idx_products_id (products_id)
ALTER TABLE reviews ADD KEY idx_products_id (products_id)
ALTER TABLE shop_configuration DROP INDEX configuration_key
ALTER TABLE shop_configuration ADD KEY idx_configuration_key (configuration_key)
ALTER TABLE specials DROP INDEX idx_specials_products_id
ALTER TABLE specials ADD KEY idx_products_id (products_id)
ALTER TABLE specials ADD KEY idx_status (status)
ALTER TABLE products_content ADD KEY idx_products_id (products_id)
ALTER TABLE address_book DROP INDEX idx_address_book_customers_id
ALTER TABLE address_book ADD KEY idx_customers_id (customers_id)
ALTER TABLE banktransfer DROP INDEX orders_id
ALTER TABLE campaigns_ip ADD KEY idx_campaign (campaign)
ALTER TABLE coupon_gv_queue DROP INDEX uid
ALTER TABLE coupon_gv_queue ADD KEY idx_customer_id (customer_id)
ALTER TABLE tax_rates ADD KEY idx_tax_zone_id (tax_zone_id)
ALTER TABLE zones_to_geo_zones ADD KEY idx_geo_zone_id (geo_zone_id)
CREATE TABLE newsfeed ( news_id INT( 11 ) NOT NULL AUTO_INCREMENT, news_title VARCHAR( 128 ) NULL, news_text TEXT NULL, news_link VARCHAR( 128 ) NULL, news_date INT( 11 ) NULL, PRIMARY KEY (news_id), UNIQUE idx_news_link (news_link) )
ALTER TABLE geo_zones ADD UNIQUE idx_geo_zone_name (geo_zone_name)
Ich habe mir im aktuelllen DB-Stand die Stellen mit idx_code herausgesucht und zweimal gefunden:
Hier die erste:
DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currencies` (
`currencies_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(32) NOT NULL,
`code` char(3) NOT NULL,
`symbol_left` varchar(12) DEFAULT NULL,
`symbol_right` varchar(12) DEFAULT NULL,
`decimal_point` char(1) DEFAULT NULL,
`thousands_point` char(1) DEFAULT NULL,
`decimal_places` char(1) DEFAULT NULL,
`value` float(13,8) DEFAULT NULL,
`last_updated` datetime DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`currencies_id`),
UNIQUE KEY `idx_code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
und hier die zweite:
DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `languages` (
`languages_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`code` char(5) NOT NULL,
`image` varchar(64) DEFAULT NULL,
`directory` varchar(32) DEFAULT NULL,
`sort_order` int(3) DEFAULT NULL,
`language_charset` text NOT NULL,
`status` int(1) NOT NULL,
`status_admin` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`languages_id`),
UNIQUE KEY `idx_code` (`code`),
KEY `IDX_LANGUAGES_NAME` (`name`),
KEY `idx_status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;