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/