Many thanks, this solves the first issue. The seccond one was a mysql timeout, i had to increase it because we have more than 100000 tickets. _____ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Robert Poreba Sent: jueves, 22 de marzo de 2012 21:05 To: 'User questions and discussions about OTRS.' Subject: Re: [otrs] error upgrading from 3.0.10 to 3.1.2 Hi, Maybe this will help: http://bugs.otrs.org/show_bug.cgi?id=8237 -- Kind Regards, Robert From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of IT easyap Sent: 21 March 2012 09:39 To: 'User questions and discussions about OTRS.' Subject: [otrs] error upgrading from 3.0.10 to 3.1.2 Hello, I'm trying to migrate our server 3.0.10 to 3.1.2 but it doesn't work. In the first stage running the sql script DBUpdate-to-3.1.mysql.sql we receive a duplicate entry error, attached you will find the message. In the seccond stage running the perl script DBUpdate-to-3.1.pl the first 5 steps run with out any problem but at the begining of step 6 an error arrise. Could you please hel us with this issue ? Thanks in advance - cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs [root@otrs otrs]# cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs Enter password: ERROR 1062 (23000) at line 187: Duplicate entry '320742-Seen-105' for key 1 - scripts/DBUpdate-to-3.1.pl Migrated ticket 105000 of 105434 (with Free fields data). Migrated ticket 105100 of 105434 (with Free fields data). Migrated ticket 105200 of 105434 (with Free fields data). Migrated ticket 105300 of 105434 (with Free fields data). Migrated ticket 105400 of 105434 (with Free fields data). Migrated 105434 tickets of 105434 (with Free fields data). done. Step 6 of 23: Migrate article free fields to dynamic fields... DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Mar 21 10:27:32 2012 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket' Traceback (2760): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.74) Line: 407 Module: scripts/DBUpdate-to-3.1.pl (v1.74) Line: 109 DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Mar 21 10:27:32 2012 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article' Traceback (2760): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.74) Line: 412 Module: scripts/DBUpdate-to-3.1.pl (v1.74) Line: 109 Free fields were deleted, migration is already done! done. Step 7 of 23: Verify if ticket data was successfully migrated... DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Mar 21 10:27:32 2012 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket' Traceback (2760): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.74) Line: 407 Module: scripts/DBUpdate-to-3.1.pl (v1.74) Line: 117 DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Mar 21 10:27:32 2012 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article' Traceback (2760): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.74) Line: 412 Module: scripts/DBUpdate-to-3.1.pl (v1.74) Line: 117 Free fields were deleted, migration is already done! done. DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Mar 21 10:27:32 2012 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket' Traceback (2760): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.74) Line: 407 Module: scripts/DBUpdate-to-3.1.pl (v1.74) Line: 125 DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Mar 21 10:27:32 2012 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article' Traceback (2760): Module: main::_IsFreefieldsMigrationAlreadyDone (v1.74) Line: 412 Module: scripts/DBUpdate-to-3.1.pl (v1.74) Line: 125 Step 8 of 23: Verify if article data was successfully migrated... Free fields were deleted, migration is already done! done. DBD::mysql::st execute failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 618. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Mar 21 10:27:32 2012 Message: MySQL server has gone away, SQL: 'SELECT id, name, field_order FROM dynamic_field ORDER BY field_order, id' Traceback (2760): Module: Kernel::System::DynamicField::DynamicFieldList (v1.50) Line: 713 Module: main::_MigrateFreeFieldsConfiguration (v1.74) Line: 1085 Module: scripts/DBUpdate-to-3.1.pl (v1.74) Line: 139 Can't use an undefined value as a HASH reference at scripts/DBUpdate-to-3.1.pl line 1090. Step 9 of 23: Migrate free fields configuration...