wir haben hier ein verdammt altes OTRS im Einsatz (Version 2.2.1) und wollten nach langer Zeit upgraden auf eine aktuelle Version (3.2.*).
So weit so gut, jedoch scheitert es schon beim Upgrade-Schritt von Version 2.2.1 auf 2.3.6, Grund hierfür scheint die Datenbank zu sein, da wohl Spalten in der Ticket-Tabelle fehlen.
Code: Select all
~> cat scripts/DBUpdate-to-2.3.mysql.sql | mysql -p -f -u root otrs
Enter password:
ERROR 1072 (42000) at line 116: Key column 'escalation_response_time' doesn't exist in table
ERROR 1072 (42000) at line 117: Key column 'escalation_solution_time' doesn't exist in table
Code: Select all
~>./scripts/DBUpdate-to-2.3.pl
[...]
Use of uninitialized value $Ticket{"StateType"} in pattern match (m//) at /opt/otrs-2.3.6/Kernel/System/Ticket.pm line 1778.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.14.2 OS: linux Time: Thu Jul 4 10:26:34 2013
Message: Need ID or Name!
Traceback (3867):
Module: Kernel::System::Queue::QueueGet (v1.103.2.1) Line: 759
Module: Kernel::System::Ticket::TicketEscalationIndexBuild (v1.346.2.9) Line: 1815
Module: main::MigrateEscalation (v1.20) Line: 273
Module: ./scripts/DBUpdate-to-2.3.pl (v1.20) Line: 96
DBD::mysql::db do failed: Unknown column 'escalation_response_time' in 'field list' at /opt/otrs-2.3.6/Kernel/System/DB.pm line 428.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.14.2 OS: linux Time: Thu Jul 4 10:26:34 2013
Message: Unknown column 'escalation_response_time' in 'field list', SQL: 'UPDATE ticket SET escalation_response_time = ? WHERE id = ?'
Traceback (3867):
Module: Kernel::System::Ticket::TicketEscalationIndexBuild (v1.346.2.9) Line: 1824
Module: main::MigrateEscalation (v1.20) Line: 273
Module: ./scripts/DBUpdate-to-2.3.pl (v1.20) Line: 96
DBD::mysql::db do failed: Unknown column 'escalation_solution_time' in 'field list' at /opt/otrs-2.3.6/Kernel/System/DB.pm line 428.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.14.2 OS: linux Time: Thu Jul 4 10:26:34 2013
Message: Unknown column 'escalation_solution_time' in 'field list', SQL: 'UPDATE ticket SET escalation_solution_time = ? WHERE id = ?'
Traceback (3867):
Module: Kernel::System::Ticket::TicketEscalationIndexBuild (v1.346.2.9) Line: 1989
Module: main::MigrateEscalation (v1.20) Line: 273
Module: ./scripts/DBUpdate-to-2.3.pl (v1.20) Line: 96
DBD::mysql::st execute failed: Unknown column 'st.escalation_response_time' in 'field list' at /opt/otrs-2.3.6/Kernel/System/DB.pm line 560.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.14.2 OS: linux Time: Thu Jul 4 10:26:34 2013
Message: Unknown column 'st.escalation_response_time' in 'field list', SQL: 'SELECT st.id, st.queue_id, sq.name, st.ticket_state_id, st.ticket_lock_id, sp.id, sp.name, st.create_time_unix, st.create_time, sq.group_id, st.tn, st.customer_id, st.customer_user_id, st.user_id, st.responsible_user_id, st.until_time, st.freekey1, st.freetext1, st.freekey2, st.freetext2, st.freekey3, st.freetext3, st.freekey4, st.freetext4, st.freekey5, st.freetext5, st.freekey6, st.freetext6, st.freekey7, st.freetext7, st.freekey8, st.freetext8, st.freekey9, st.freetext9, st.freekey10, st.freetext10, st.freekey11, st.freetext11, st.freekey12, st.freetext12, st.freekey13, st.freetext13, st.freekey14, st.freetext14, st.freekey15, st.freetext15, st.freekey16, st.freetext16, st.freetime1, st.freetime2, st.freetime3, st.freetime4, st.freetime5, st.freetime6, st.change_time, st.title, st.escalation_update_time, st.timeout, st.type_id, st.service_id, st.sla_id, st.escalation_response_time, st.escalation_solution_time, st.escalation_time FROM ticket st, ticket_priority sp, queue sq WHERE sp.id = st.ticket_priority_id AND sq.id = st.queue_id AND st.id = ?'
Traceback (3867):
Module: Kernel::System::Ticket::TicketGet (v1.346.2.9) Line: 806
Module: Kernel::System::Ticket::TicketEscalationIndexBuild (v1.346.2.9) Line: 1772
Module: main::MigrateEscalation (v1.20) Line: 273
Module: ./scripts/DBUpdate-to-2.3.pl (v1.20) Line: 96
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs-2.3.6/Kernel/System/DB.pm line 623.
ERROR: OTRS-DBUpdate-to-2.3-10 Perl: 5.14.2 OS: linux Time: Thu Jul 4 10:26:34 2013
[...]
Habe hier auch etwas in der Mailingliste einen Beitrag von 2010 gefunden, leider ohne Antwort, der genau zu meinem Problem passt:
http://lists.otrs.org/pipermail/otrs-de ... 12446.html
Weiß jemand eine Lösung?
Beste Grüße,
Jan
