Hallo alleseits, ich habe gerade mal versucht unser OTRS 1.3.2 auf 2.1.0 upzudaten - allerdings habe ich mit 2 Probleme zu kämpfen. 1) Mailzustellung schlägt fehl Command output: DBD::mysql::db do failed: Unknown column 'responsible_user_id' in 'field list' at /opt/otrs-2.1.0/Kernel/System/DB.pm line 378. ERROR: OTRS-PM-10 Perl: 5.8.3 OS: linux Time: Wed Aug 30 14:12:41 2006 Message: Unknown column 'responsible_user_id' in 'field list', SQL: 'INSERT INTO ticket (tn, title, create_time_unix, queue_id, ticket_lock_id, user_id, responsible_user_id, group_id, ticket_priority_id, ticket_state_id, ticket_answered, escalation_start_time, timeout, valid_id, create_time, create_by, change_time, change_by) VALUES ('2006083010000061', 'Test - 30.08.2006 - #05', 1156939961, 2, 1, 1, 1, 1, 2, 1, 0, 1156939961, 0, 1, current_timestamp, 1, current_timestamp, 1)' Traceback (24342): Module: Kernel::System::Ticket::TicketCreate (v1.217) Line: 398 Module: Kernel::System::PostMaster::NewTicket::Run (v1.55) Line: 162 Mod 2) Frontend "geht nicht" Ein Versuch Queues anzuzeigen schlägt mir folgender Fehlermeldung fehl: Software error: Can't use an undefined value as a HASH reference at ../..//Kernel/System/Ticket/Article.pm line 1282. Irgendeine Idee woran es in beiden Fällen liegen könnte ? Anbei meine Config.pm. Viele Grüße Sascha # DatabaseHost # (The database host.) $Self->{'DatabaseHost'} = 'localhost'; # Database # (The database name.) $Self->{'Database'} = 'meinedatenbdank'; # DatabaseUser # (The database user.) $Self->{'DatabaseUser'} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{'DatabasePw'} = 'meinpasswort'; # DatabaseDSN # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; #------------------------------------------------------# # Prio auf 4 Normal für neue Tickets 11.01.2005 /sk # #------------------------------------------------------# $Self->{PostmasterDefaultPriority} = '4 Normal'; $Self->{Ticket::Frontend::EmailPriorit} = '4 Normal'; $Self->{Ticket::Frontend::PhonePriority} = '4 Normal'; $Self->{Ticket::Frontend::PhonePriority} = '4 Normal'; $Self->{CustomerDefaultPriority} = '4 Normal'; #------------------------------------------------------# # Einträge für responses hinzu 23.02.2005 /sk # #------------------------------------------------------# $Self->{'Module::Permission'}->{'AdminResponse'} = 'responses'; # ---------------------------------------------------- # # fs root directory # ---------------------------------------------------- # $Self->{Home} = '/opt/otrs'; # **************************************************** # # insert your own config settings "here" # # config settings taken from Kernel/Config/Defaults.pm # # **************************************************** # # $Self->{SessionUseCookie} = 0; # $Self->{CheckMXRecord} = 0; # **************************************************** #
Hallo. 1.) Die Version 2.10 ist eine Beta und sollte im Prduktiveinsatz nicht verwendet werden. 2.) Führe das Datenbankupdate aus. -- Mit freundlichen Grüssen André Bauer System: Debian 3.1 / Apache 2.0.54 / MySQL 4.1.11 / OTRS 2.0.4 ============================================ mcb> Hallo alleseits, mcb> ich habe gerade mal versucht unser OTRS 1.3.2 auf 2.1.0 mcb> upzudaten - allerdings habe ich mit 2 Probleme zu kämpfen. mcb> 1) Mailzustellung schlägt fehl mcb> Command output: DBD::mysql::db do failed: Unknown column mcb> 'responsible_user_id' in 'field list' at mcb> /opt/otrs-2.1.0/Kernel/System/DB.pm line 378. ERROR: OTRS-PM-10 mcb> Perl: 5.8.3 OS: linux Time: Wed Aug 30 14:12:41 2006 Message: mcb> Unknown column 'responsible_user_id' in 'field list', SQL: mcb> 'INSERT INTO ticket (tn, title, create_time_unix, queue_id, mcb> ticket_lock_id, user_id, responsible_user_id, group_id, mcb> ticket_priority_id, ticket_state_id, ticket_answered, mcb> escalation_start_time, timeout, valid_id, create_time, create_by, mcb> change_time, change_by) VALUES ('2006083010000061', 'Test - mcb> 30.08.2006 - #05', 1156939961, 2, 1, 1, 1, 1, 2, 1, 0, mcb> 1156939961, 0, 1, current_timestamp, 1, current_timestamp, 1)' mcb> Traceback (24342): Module: mcb> Kernel::System::Ticket::TicketCreate (v1.217) Line: 398 mcb> Module: Kernel::System::PostMaster::NewTicket::Run (v1.55) Line: mcb> 162 Mod mcb> 2) Frontend "geht nicht" mcb> Ein Versuch Queues anzuzeigen schlägt mir folgender Fehlermeldung fehl: mcb> Software error: mcb> Can't use an undefined value as a HASH reference at mcb> ../..//Kernel/System/Ticket/Article.pm line 1282. mcb> Irgendeine Idee woran es in beiden Fällen liegen könnte ? mcb> Anbei meine Config.pm. mcb> Viele Grüße mcb> Sascha mcb> # DatabaseHost mcb> # (The database host.) mcb> $Self->{'DatabaseHost'} = 'localhost'; mcb> # Database mcb> # (The database name.) mcb> $Self->{'Database'} = 'meinedatenbdank'; mcb> # DatabaseUser mcb> # (The database user.) mcb> $Self->{'DatabaseUser'} = 'otrs'; mcb> # DatabasePw mcb> # (The password of database user. You also can use bin/CryptPassword.pl mcb> # for crypted passwords.) mcb> $Self->{'DatabasePw'} = 'meinpasswort'; mcb> # DatabaseDSN mcb> # (The database DSN for MySQL ==> more: "man DBD::mysql") mcb> $Self->{DatabaseDSN} = mcb> "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; mcb> #------------------------------------------------------# mcb> # Prio auf 4 Normal für neue Tickets 11.01.2005 /sk # mcb> #------------------------------------------------------# mcb> $Self->{PostmasterDefaultPriority} = '4 Normal'; mcb> $Self->{Ticket::Frontend::EmailPriorit} = '4 Normal'; mcb> $Self->{Ticket::Frontend::PhonePriority} = '4 Normal'; mcb> $Self->{Ticket::Frontend::PhonePriority} = '4 Normal'; mcb> $Self->{CustomerDefaultPriority} = '4 Normal'; mcb> #------------------------------------------------------# mcb> # Einträge für responses hinzu 23.02.2005 /sk # mcb> #------------------------------------------------------# mcb> $Self->{'Module::Permission'}->{'AdminResponse'} = 'responses'; mcb> # ---------------------------------------------------- # mcb> # fs root directory mcb> # ---------------------------------------------------- # mcb> $Self->{Home} = '/opt/otrs'; mcb> # **************************************************** # mcb> # insert your own config settings "here" # mcb> # config settings taken from Kernel/Config/Defaults.pm # mcb> # **************************************************** # mcb> # $Self->{SessionUseCookie} = 0; mcb> # $Self->{CheckMXRecord} = 0; mcb> # **************************************************** #
participants (2)
-
André Bauer -
ml＠charliesangels.biz