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;
# **************************************************** #