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...