ich hoffe das mir hier jemand bei meinem Problem helfen kann.
Ich habe die Version 3.0.10 und möchte auf die 3.2.10 updaten.
Die DB hab ich vor den Updates auf utf8 und von MyISAM auf InnoDB umgestellt.
Das Update auf 3.1.18 lief bis auf die Meldung soweit ganz gut:
Code: Select all
cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs
Code: Select all
ERROR 1050 (42S01) at line 169: Table 'smime_signer_cert_relations' already exists
Wenn ich die Fehlermeldung ignoriere und mit dem Update fortfahre auf 3.2.10 hagelt es nur noch Fehler.
Code: Select all
bin/otrs.CheckDB.pl
Code: Select all
cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -f -u root otrs
Code: Select all
ERROR 1091 (42000) at line 20: Can't DROP 'ticket_answered' ; check that column/key exists
ERROR 1091 (42000) at line 25: Can't DROP 'ticket_queue_vie w'; check that column/key exists
Code: Select all
scripts/DBUpdate-to-3.2.pl
Code: Select all
Migration started...
Step 1 of 10: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.
Step 2 of 10: Check framework version... done.
Step 3 of 10: Cleanup UserPreferences... done.
Step 4 of 10: Updating toolbar configuration... done.
Step 5 of 10: Updating AgentTicketZoom window configuration... done.
Step 6 of 10: Dropping obsolete columns from article_search... Check if columns exist.
Columns found, drop them.
ALTER TABLE article_search DROP a_freetext1
ALTER TABLE article_search DROP a_freetext2
ALTER TABLE article_search DROP a_freetext3
ALTER TABLE article_search DROP a_freekey1
ALTER TABLE article_search DROP a_freekey2
ALTER TABLE article_search DROP a_freekey3
done.
Step 7 of 10: Dropping unused indexes on article_flag... SET @FKExists := (SELECT COUNT(*) FROM information_schema.table_constraints WHERE table_schema = DATABASE() AND table_name = 'article_flag' AND constraint_name = 'FK_article_flag_article_id_id')
OK
SET @FKSQLStatement := IF( @FKExists > 0, 'ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_article_id_id', 'SELECT ''INFO: Foreign key constraint FK_article_flag_article_id_id does not exist, skipping.''' )
OK
PREPARE FKStatement FROM @FKSQLStatement
OK
EXECUTE FKStatement
OK
SET @FKExists := (SELECT COUNT(*) FROM information_schema.table_constraints WHERE table_schema = DATABASE() AND table_name = 'article_flag' AND constraint_name = 'FK_article_flag_create_by_id')
OK
SET @FKSQLStatement := IF( @FKExists > 0, 'ALTER TABLE article_flag DROP FOREIGN KEY FK_article_flag_create_by_id', 'SELECT ''INFO: Foreign key constraint FK_article_flag_create_by_id does not exist, skipping.''' )
OK
PREPARE FKStatement FROM @FKSQLStatement
OK
EXECUTE FKStatement
OK
DROP INDEX article_flag_create_by ON article_flag
DBD::mysql::db do failed: Can't DROP 'article_flag_create_by'; check that column/key exists at /opt/otrs-3.2.10/Kernel/System/DB.pm line 475.
ERROR: OTRS-DBUpdate-to-3.2-10 Perl: 5.10.1 OS: linux Time: Thu Aug 29 09:40:22 2013
Message: Can't DROP 'article_flag_create_by'; check that column/key exists, SQL: 'DROP INDEX article_flag_create_by ON article_flag'
Traceback (65344):
Module: main::_DropArticleFlagIndexes (unknown version) Line: 488
Module: scripts/DBUpdate-to-3.2.pl (unknown version) Line: 109
Index was not present
DROP INDEX article_flag_article_id_article_key ON article_flag
OK
ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id)
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrs2`.<result 2 when explaining filename '#sql-f7c6_1e'>, CONSTRAINT `FK_article_flag_article_id_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)) at /opt/otrs-3.2.10/Kernel/System/DB.pm line 475.
ERROR: OTRS-DBUpdate-to-3.2-10 Perl: 5.10.1 OS: linux Time: Thu Aug 29 09:41:54 2013
Message: Cannot add or update a child row: a foreign key constraint fails (`otrs2`.<result 2 when explaining filename '#sql-f7c6_1e'>, CONSTRAINT `FK_article_flag_article_id_id` FOREIGN KEY (`article_id`) REFERENCES `article` (`id`)), SQL: 'ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_article_id_id FOREIGN KEY (article_id) REFERENCES article (id)'
Traceback (65344):
Module: main::_DropArticleFlagIndexes (unknown version) Line: 488
Module: scripts/DBUpdate-to-3.2.pl (unknown version) Line: 109
Index was not present
ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id)
OK
Step 8 of 10: Migration cache backend configuration... done.
Step 9 of 10: Clean up the cache... done.
Step 10 of 10: Refresh configuration cache another time...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
done.
Migration completed!
Danke schon mal für eure Hilfe.