Error----scripts/DBUpdate-to-3.1.pl

English! place to talk about development, programming and coding
Post Reply
dileep0358
Znuny newbie
Posts: 62
Joined: 05 Oct 2011, 12:31
Znuny Version: 4.0.12
Real Name: Dileep Kumar SIngh
Company: MotherSonsumi InfoTech & Designs Ltd.

Error----scripts/DBUpdate-to-3.1.pl

Post by dileep0358 »

dear community,
when i am migrating otrs from 3.0.1 to 3.1.5 i am getting following error-

Code: Select all

Step 6 of 24: 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.

 >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 00:40:29 2012

 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

 Traceback (30635):
   Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 417
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 109

DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478.

 >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 00:40:29 2012

 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

 Traceback (30635):
   Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 422
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 109

Free fields were deleted, migration is already done!
done.

Step 7 of 24: 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.

 >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 00:40:29 2012

 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

 Traceback (30635):
   Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 417
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 117

DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478.

 >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 00:40:29 2012

 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

 Traceback (30635):
   Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 422
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) 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.

 >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 00:40:29 2012

 Message: MySQL server has gone away, SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

 Traceback (30635):
   Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 417
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 125

DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478.

 >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 00:40:29 2012

 Message: MySQL server has gone away, SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

 Traceback (30635):
   Module: main::_IsFreefieldsMigrationAlreadyDone (v1.85) Line: 422
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 125

Step 8 of 24: 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.

 >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.8.8 OS: linux Time: Wed Jun 27 00:40:29 2012

 Message: MySQL server has gone away, SQL: 'SELECT id, name, field_order FROM dynamic_field ORDER BY field_order, id'

 Traceback (30635):
   Module: Kernel::System::DynamicField::DynamicFieldList (v1.56.2.1) Line: 720
   Module: main::_MigrateFreeFieldsConfiguration (v1.85) Line: 1095
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 139

Can't use an undefined value as a HASH reference at scripts/DBUpdate-to-3.1.pl line 1100.
please tell me the problem....
regards,
dileep singh
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Error----scripts/DBUpdate-to-3.1.pl

Post by jojo »

you can not write this file >> Can't write /var/log/otrs.log.2012-6: Permission denied <<

Check the permissions of the user
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
dileep0358
Znuny newbie
Posts: 62
Joined: 05 Oct 2011, 12:31
Znuny Version: 4.0.12
Real Name: Dileep Kumar SIngh
Company: MotherSonsumi InfoTech & Designs Ltd.

Re: Error----scripts/DBUpdate-to-3.1.pl

Post by dileep0358 »

thanks for the reply......
what about this error

Code: Select all

DBD::mysql::db do failed: MySQL server has gone away at /opt/otrs/Kernel/System/DB.pm line 478.
Post Reply