ich versuche auf einer Testmaschine gerade ein Update von OTRS. Leider bekomme ich bei Schritt 9 Fehlermeldungen geliefert.
cat scripts/DBUpdate-to-3.2.mysql.sql | mysql -p -f -u root otrs
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_view'; check that column/key exists
Muss ich mir jetzt sorgen machen oder kann ich mit dem Update einfach fortfahren?
Ich habe jetzt einfach mal zum testen mit dem Update weiter gemacht und bekomme beim folgenden Schritt diese Meldungen (kleiner Auszug):
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.17/Kernel/System/DB.pm line 482.
ERROR: OTRS-DBUpdate-to-3.2-10 Perl: 5.10.0 OS: linux Time: Tue Jan 27 10:49:19 2015
Message: Can't DROP 'article_flag_create_by'; check that column/key exists, SQL: 'DROP INDEX article_flag_create_by ON article_flag'
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)
OK
ALTER TABLE article_flag ADD CONSTRAINT FK_article_flag_create_by_id FOREIGN KEY (create_by) REFERENCES users (id)
DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrs/#sql-4ca8_bc`, CONSTRAINT `FK_article_flag_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)) at /opt/otrs-3.2.17/Kernel/System/DB.pm line 482.
ERROR: OTRS-DBUpdate-to-3.2-10 Perl: 5.10.0 OS: linux Time: Tue Jan 27 10:50:15 2015
Index was not present
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.