tach, es gibt eine Datei die die letzte Ticketnummer enthält. leider weiss ich den Namen nicht mehr, wurde hier auf der Liste aber schon öfter angesprochen... Such die Liste halt mal durch ich meine auch da gibts ein paar DB-Upgrdae scripts die man der Reihe nach auf die db loslassen sollte bei einem upgrade. findeste sicherlich auch in der Liste.... Li otrs-de-bounces@otrs.org schrieb am 17.03.2006 10:42:53:
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
-------------------------------------------------------------------------------
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 Germany 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. _______________________________________________ OTRS Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? => http://www.otrs.de/