Hallo,
folgender Fehler im Cron-Job UnlockTickets:
DBD::mysql::st execute failed: Unknown column 'comment' in 'field list' at
/opt/otrs/Kernel/System/DB.pm line 400.
ERROR: OTRS-UnlockTickets-1 Perl: 5.8.0 OS: linux Time: Thu Feb 26 00:30:05
2004
Message: Unknown column 'comment' in 'field list', SQL: 'SELECT
salutation, first_name, last_name, login, pw, email, phone,
location, room, customer_id, comment, valid_id, login FROM
customer_user WHERE login = 'jwendlan''
Traceback (1400):
Module: Kernel::System::CustomerUser::DB::CustomerUserDataGet (v1.22)
Line: 210
Module: Kernel::System::CustomerUser::CustomerUserDataGet (v1.17) Line:
118
Module: Kernel::System::Ticket::SendNotification::SendNotification
(v1.13) Line: 54
Module: Kernel::System::Ticket::Lock::SetLock (v1.12) Line: 147
Module: /opt/otrs/bin/UnlockTickets.pl (v1.15) Line: 92
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
/opt/otrs/Kernel/System/DB.pm line 438.
In der DB in customer_user heißt das Feld comments. Kann ich das in der
DB abändern oder ist da tiefergehende Reparatur nötig?
Viele Grüße
Jonas