Hallo Liste,
jetzt noch mal vollständig..
ich habe kürzlich ein Upgrade von OTRS
1.3 auf die letzte stabile Version 2.04 durchgeführt. Das Update auf ich auf
zwei verschiedene Arten durchgeführt:
1. neues Debian System installiert und
OTRS per apt-get installiert.
Dump von OTRS 1.3
unter Redhat 7.3 eingespielt und Config Dateien angepasst.
2. bestehendes System upgegraded mit einem
aktuellen rpm Paket von OTRS.
Problem unter Debian:
Tickets werden doppelt erstellt. Ich habe
unser „Prefix“ 66 dort eingetragen, leider macht OTRS nicht beim
letzten Ticket weiter sondern zählt von vorne an los, was diese Errors
ausspuckt:
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601133) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601181) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601230) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601280) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601331) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]: [Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr]
Tn (6601383) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601436) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601490) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601545) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601601) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]: [Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr]
Tn (6601658) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601716) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601775) exists! Creating new one.
Mar 15 14:54:03 v852
OTRS-PM3-66[17976]:
[Notice][Kernel::System::Ticket::Number::AutoIncrement::CreateTicketNr] Tn
(6601835) exists
Problem unter Redhat:
Mar 15 18:06:15 homer
OTRS-CGI-66[26640]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:15 homer
OTRS-CGI-66[26640]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id, q.comments,
q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock, sa.value0,
sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify, q.owner_notify,
q.default_sign_key FROM queue q, system_address sa WHERE q.system_address_id
= sa.id AND q.id = 1'
Mar 15 18:06:15 homer
OTRS-CGI-66[26640]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:15 homer
OTRS-CGI-66[26640]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 1'
Mar 15 18:06:15 homer
OTRS-CGI-66[26640]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:20 homer
OTRS-CGI-66[26642]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 1'
Mar 15 18:06:20 homer
OTRS-CGI-66[26642]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:20 homer
OTRS-CGI-66[26642]:
[Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndex][Line:357]:
Unknown column 'content_size' in 'field list', SQL: 'SELECT filename,
content_type, content_size FROM article_attachment WHERE article_id = 125890
ORDER BY id'
Mar 15 18:06:38 homer
OTRS-CGI-66[26643]: [Error][Kernel::System::Ticket::HistoryAdd][Line:3647]:
Unknown column 'queue_id' in 'field list', SQL: 'INSERT INTO ticket_history
(name, history_type_id, ticket_id, article_id, queue_id, owner_id,
priority_id, state_id, valid_id, create_time, create_by, change_time,
change_by) VALUES ('%lock', 21, 32610, NULL, 1, 1, 3, 1, 1,
current_timestamp, 4, current_timestamp, 4)'
Mar 15 18:06:38 homer
OTRS-CGI-66[26643]: [Error][Kernel::System::Ticket::HistoryAdd][Line:3647]:
Unknown column 'queue_id' in 'field list', SQL: 'INSERT INTO ticket_history (name,
history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id,
state_id, valid_id, create_time, create_by, change_time, change_by) VALUES
('Reset of unlock time.', 29, 32610, NULL, 1, 1, 3, 1, 1, current_timestamp,
4, current_timestamp, 4)'
Mar 15 18:06:38 homer
OTRS-CGI-66[26643]: [Error][Kernel::System::Ticket::HistoryAdd][Line:3647]:
Unknown column 'queue_id' in 'field list', SQL: 'INSERT INTO ticket_history
(name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id,
state_id, valid_id, create_time, create_by, change_time, change_by) VALUES
('%rsimon%4', 27, 32610, NULL, 1, 1, 3, 1, 1, current_timestamp, 4,
current_timestamp, 4)'
Mar 15 18:06:38 homer
OTRS-CGI-66[26643]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 1'
Mar 15 18:06:38 homer
OTRS-CGI-6alation_time, q.follow_up_id, q.follow_up_lock, sa.value0, sa.value1,
q.id, q.move_notify, q.state_notify, q.lock_notify, q.owner_notify,
q.default_sign_key FROM queue q, system_address sa WHERE q.system_address_id
= sa.id AND q.id = 1'
Mar 15 18:06:42 homer
OTRS-CGI-66[26641]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:42 homer
OTRS-CGI-66[26641]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 1'
Mar 15 18:06:42 homer
OTRS-CGI-66[26641]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:44 homer
OTRS-CGI-66[26644]: [Error][Kernel::System::Ticket::HistoryAdd][Line:3647]:
Unknown column 'queue_id' in 'field list', SQL: 'INSERT INTO ticket_history
(name, history_type_id, ticket_id, article_id, queue_id, owner_id,
priority_id, state_id, valid_id, create_time, create_by, change_time, change_by)
VALUES ('%Close', 17, 32611, 125898, 1, 4, 3, 1, 1, current_timestamp, 4,
current_timestamp, 4)'
Mar 15 18:06:44 homer
OTRS-CGI-66[26644]: [Error][Kernel::System::Ticket::HistoryAdd][Line:3647]:
Unknown column 'queue_id' in 'field list', SQL: 'INSERT INTO ticket_history
(name, history_type_id, ticket_id, article_id, queue_id, owner_id,
priority_id, state_id, valid_id, create_time, create_by, change_time,
change_by) VALUES ('%new%closed successful%', 32, 32611, 125898, 1, 4, 3, 2,
1, current_timestamp, 4, current_timestamp, 4)'
Mar 15 18:06:44 homer
OTRS-CGI-66[26644]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 1'
Mar 15 18:06:44 homer
OTRS-CGI-66[26644]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:44 homer
OTRS-CGI-66[26644]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 1'
Mar 15 18:06:44 homer
OTRS-CGI-66[26644]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 1!
Mar 15 18:06:44 homer
OTRS-CGI-66[26644]: [Error][Kernel::System::Ticket::HistoryAdd][Line:3647]:
Unknown column 'queue_id' in 'field list', SQL: 'INSERT INTO ticket_history
(name, history_type_id, ticket_id, article_id, queue_id, owner_id,
priority_id, state_id, valid_id, create_time, create_by, change_time,
change_by) VALUES ('%unlock', 22, 32611, NULL, 1, 4, 3, 2, 1,
current_timestamp, 4, current_timestamp, 4)'
Mar 15 18:06:45 homer
OTRS-CGI-66[26643]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 1'
Mar 15 18:06:45 homer OTRS-CGI-66[26643]:
[Error][Kernel::System::Queue::QueueGet][Line:823]: Found no $ID for 1!
Mar 15 18:07:19 homer
OTRS-CGI-66[26641]: [Error][Kernel::System::Queue::QueueGet][Line:796]: Unknown
column 'q.default_sign_key' in 'field list', SQL: 'SELECT q.name, q.group_id,
q.unlock_timeout, q.system_address_id, q.salutation_id, q.signature_id,
q.comments, q.valid_id, q.escalation_time, q.follow_up_id, q.follow_up_lock,
sa.value0, sa.value1, q.id, q.move_notify, q.state_notify, q.lock_notify,
q.owner_notify, q.default_sign_key FROM queue q, system_address sa WHERE
q.system_address_id = sa.id AND q.id = 2'
Mar 15 18:07:19 homer
OTRS-CGI-66[26641]: [Error][Kernel::System::Queue::QueueGet][Line:823]: Found
no $ID for 2!
Natürlich wurde auch das Dumpfile
eingespielt, welches dem OTRS Paket beiliegt (DBUpdate-to-2.0.mysql.sql).
Ebenfalls ist die Darstellung der eigenen
Queue völlig fehlerhaft beim Upgrade der Redhat Version, unter Debian hab ich
dies Problem nicht.
Hat jemand ähnliche Probleme sowie eine
Lösung?
Bisweilen habe ich mir damit geholfen,
wieder OTRS 1.3 einzuspielen, da dies korrekt arbeitet.
Mit freundlichen Grüßen | Best regards
-------------------------------------------------------------------------------
Robert Simon
[netclusive] GmbH
Geschäftsführer
Robert-Bosch-Str.10,
Haus I
phone: +49 (0) 2602 / 94
708 - 0
D-56410 Montabaur
fax: +49 (0)
2602 / 94 708 - 299
rsimon@netclusive.de
http://www.netclusive.de
-------------------------------------------------------------------------------
Diese E-Mail enthält vertrauliche
und/oder rechtlich geschützte Informationen.
Wenn Sie nicht der richtige Adressat sind
oder diese E-Mail irrtümlich erhalten
haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die
unbefugte Weitergabe dieser Mail ist nicht
gestattet.
This e-mail may contain
confidential and/or privileged information. If you are
not the intended recipient (or
have received this e-mail in error) please notify
the sender immediately and
destroy this e-mail. Any unauthorised copying,
disclosure or distribution of
the material in this e-mail is strictly forbidden.