Re: [otrs] Problems with update from 3.1.6 to 3.1.8

So it's not my fault? Since I am relieved. :) I checked it many times but I do not find the "skip db-update". So, now I will test it again without updating the db. Thanks a lot, Kay On Mon, Aug 13, 2012 at 6:41 PM, Gerald Young wrote:

On second thought, the UPGRADING is incorrect as it's written. It says skip step "9, 11, and 13-19"

That doesn't make sense.

8 is dbupdate. You should be able to skip that for patch level updates. 9 is safe and potentially required to run. 10 should be skipped as there's no reason to update your apache config if it's working. 11 is required (restart services) 12-18 are optional for patch releases 19 is important for 3.1.5+ (ACL changes) 20 is important for upgrade of SMIME information 21 is only important for 3.1 beta releases.

(This isn't "official", but it is on the "what makes sense to do?")

On Mon, Aug 13, 2012 at 12:33 PM, Gerald Young wrote:

...

"What should I do?" First, read UPGRADING and realize you don't need to do dbupdate on 3.1x to 3.1x http://source.otrs.org/viewvc.cgi/otrs/ ... =rel-3_1_8

If you are running a lower version of OTRS you have to follow the upgrade path to 3.0 first (1.1->1.2->1.3->2.0->2.1->2.2->2.3->2.4->3.0->3.1 ...)!

Please note that if you upgrade from OTRS 2.2 or earlier, you have to take an extra step; please read http://bugs.otrs.org/show_bug.cgi?id=6798

Within a single minor version you can skip patch level releases if you want to upgrade. For instance you can upgrade directly from OTRS 3.1.1 to version 3.1.4. If you need to do such a "patch level upgrade", you should skip steps 9, 11 and 13-19.

Please note that for upgrades from 3.1.beta1 or 3.1.beta2, an additional step 21 is needed!

"So do I have to do database upgrade or not?" ... what is your version? "3.1.x" Is that 3.1.beta1 or 3.1.beta2? "no" That's your answer.

"3.0.x" Follow the upgrading steps in the file, completely, including database.

"2.4.x" Upgrade to 3.0.x paying attention to that 3.0x UPGRADING, including database

"<2.4.x" follow the upgrade path above (in UPGRADING).

On Mon, Aug 13, 2012 at 12:17 PM, guckuck wrote:

...

Hi,

I run OTRS on Ubuntu 11.4.

During the DB-Update I get the errors above.

Despite the mistakes I have finished the update. OTRS seems to be working properly yet.

What should I do?

Best regards, Kay

SCHEMA UPDATE PART 1: ===================== kay@v14860:/opt/otrs$ cat scripts/DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs Enter password: ERROR 1050 (42S01) at line 28: Table 'gi_webservice_config' already exists ERROR 1050 (42S01) at line 45: Table 'gi_webservice_config_history' already exists ERROR 1050 (42S01) at line 60: Table 'scheduler_task_list' already exists ERROR 1050 (42S01) at line 73: Table 'gi_debugger_entry' already exists ERROR 1050 (42S01) at line 87: Table 'gi_debugger_entry_content' already exists ERROR 1050 (42S01) at line 101: Table 'gi_object_lock_state' already exists ERROR 1062 (23000) at line 115: Duplicate entry 'EscalationSolutionTimeStop' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 121: Duplicate entry 'EscalationResponseTimeStart' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 127: Duplicate entry 'EscalationUpdateTimeStart' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 133: Duplicate entry 'EscalationSolutionTimeStart' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 139: Duplicate entry 'EscalationResponseTimeNotifyBefore' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 145: Duplicate entry 'EscalationUpdateTimeNotifyBefore' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 151: Duplicate entry 'EscalationSolutionTimeNotifyBefore' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 157: Duplicate entry 'EscalationResponseTimeStop' for key 'ticket_history_type_name' ERROR 1062 (23000) at line 163: Duplicate entry 'EscalationUpdateTimeStop' for key 'ticket_history_type_name' ERROR 1050 (42S01) at line 169: Table 'smime_signer_cert_relations' already exists ERROR 1060 (42S21) at line 184: Duplicate column name 'process_change' ERROR 1050 (42S01) at line 190: Table 'dynamic_field_value' already exists ERROR 1050 (42S01) at line 205: Table 'dynamic_field' already exists ERROR 1060 (42S21) at line 224: Duplicate column name 'imap_folder'

DATABASE MIGRATION SCRIPT =========================

kay@v14860:/opt/otrs$ sudo scripts/DBUpdate-to-3.1.pl

Migration started...

Step 1 of 24: Refresh configuration cache... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 5. Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 5. done.

Step 2 of 24: Check framework version... done.

Step 3 of 24: Creating DynamicField tables (if necessary)... done.

DBD::mysql::db do failed: Unknown column 'freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'freekey1' in 'field list', SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

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

DBD::mysql::db do failed: Unknown column 'a_freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'a_freekey1' in 'field list', SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

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

Step 4 of 24: Create new dynamic fields for free fields (text, key, date)... Free fields were deleted, migration is already done! done.

Step 5 of 24: Migrate ticket free fields to dynamic fields... DBD::mysql::db do failed: Unknown column 'freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'freekey1' in 'field list', SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

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

DBD::mysql::db do failed: Unknown column 'a_freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'a_freekey1' in 'field list', SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

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

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

Step 6 of 24: Migrate article free fields to dynamic fields... DBD::mysql::db do failed: Unknown column 'freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'freekey1' in 'field list', SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

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

DBD::mysql::db do failed: Unknown column 'a_freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'a_freekey1' in 'field list', SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

Traceback (11572): 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: Unknown column 'freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'freekey1' in 'field list', SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

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

DBD::mysql::db do failed: Unknown column 'a_freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'a_freekey1' in 'field list', SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

Traceback (11572): 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: Unknown column 'freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'freekey1' in 'field list', SQL: 'SELECT freekey1, freetext1, freetime1 FROM ticket'

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

DBD::mysql::db do failed: Unknown column 'a_freekey1' in 'field list' at /opt/otrs-3.1.8/Kernel/System/DB.pm line 478. ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Mon Aug 13 17:45:01 2012

Message: Unknown column 'a_freekey1' in 'field list', SQL: 'SELECT a_freekey1, a_freetext1 FROM article'

Traceback (11572): 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.

Step 9 of 24: Migrate free fields configuration... done.

Step 10 of 24: Update history type from 'TicketFreeTextUpdate' to 'TicketDynamicFieldUpdate'... done.

Step 11 of 24: Migrate free fields window configuration... done.

Step 12 of 24: Migrate free fields stats configuration... done.

Step 13 of 24: Migrate free fields generic agent jobs configuration... done.

Step 14 of 24: Migrate free fields post master configuration... done.

Step 15 of 24: Migrate free fields standard responses configuration... done.

Step 16 of 24: Migrate free fields auto responses configuration... done.

Step 17 of 24: Migrate free fields salutations configuration... done.

Step 18 of 24: Migrate free fields signatures configuration... done.

Step 19 of 24: Migrate free fields search profiles configuration... done.

Step 20 of 24: Migrate free fields notifications configuration... done.

Step 21 of 24: Migrate free fields notification event configuration... done.

Step 22 of 24: Checking for duplicate entries on ticket_flag table... done.

Step 23 of 24: Clean up the cache... done.

Step 24 of 24: Refresh configuration cache another time... If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry! Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 5. Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAuto.pm line 5. done.

Migration completed!

SCHEMA UPDATE PART 2: ===================== kay@v14860:/opt/otrs$ cat scripts/DBUpdate-to-3.1-post.mysql.sql | mysql -p -f -u root otrs Enter password: ERROR 1091 (42000) at line 7: Can't DROP 'freetext1'; check that column/key exists ERROR 1091 (42000) at line 11: Can't DROP 'freetext2'; check that column/key exists ERROR 1091 (42000) at line 15: Can't DROP 'freetext3'; check that column/key exists ERROR 1091 (42000) at line 19: Can't DROP 'freetext4'; check that column/key exists ERROR 1091 (42000) at line 23: Can't DROP 'freetext5'; check that column/key exists ERROR 1091 (42000) at line 27: Can't DROP 'freetext6'; check that column/key exists ERROR 1091 (42000) at line 31: Can't DROP 'freetext7'; check that column/key exists ERROR 1091 (42000) at line 35: Can't DROP 'freetext8'; check that column/key exists ERROR 1091 (42000) at line 39: Can't DROP 'freetext9'; check that column/key exists ERROR 1091 (42000) at line 43: Can't DROP 'freetext10'; check that column/key exists ERROR 1091 (42000) at line 47: Can't DROP 'freetext11'; check that column/key exists ERROR 1091 (42000) at line 51: Can't DROP 'freetext12'; check that column/key exists ERROR 1091 (42000) at line 55: Can't DROP 'freetext13'; check that column/key exists ERROR 1091 (42000) at line 59: Can't DROP 'freetext14'; check that column/key exists ERROR 1091 (42000) at line 63: Can't DROP 'freetext15'; check that column/key exists ERROR 1091 (42000) at line 67: Can't DROP 'freetext16'; check that column/key exists ERROR 1091 (42000) at line 71: Can't DROP 'freekey1'; check that column/key exists ERROR 1091 (42000) at line 75: Can't DROP 'freekey2'; check that column/key exists ERROR 1091 (42000) at line 79: Can't DROP 'freekey3'; check that column/key exists ERROR 1091 (42000) at line 83: Can't DROP 'freekey4'; check that column/key exists ERROR 1091 (42000) at line 87: Can't DROP 'freekey5'; check that column/key exists ERROR 1091 (42000) at line 91: Can't DROP 'freekey6'; check that column/key exists ERROR 1091 (42000) at line 95: Can't DROP 'freekey7'; check that column/key exists ERROR 1091 (42000) at line 99: Can't DROP 'freekey8'; check that column/key exists ERROR 1091 (42000) at line 103: Can't DROP 'freekey9'; check that column/key exists ERROR 1091 (42000) at line 107: Can't DROP 'freekey10'; check that column/key exists ERROR 1091 (42000) at line 111: Can't DROP 'freekey11'; check that column/key exists ERROR 1091 (42000) at line 115: Can't DROP 'freekey12'; check that column/key exists ERROR 1091 (42000) at line 119: Can't DROP 'freekey13'; check that column/key exists ERROR 1091 (42000) at line 123: Can't DROP 'freekey14'; check that column/key exists ERROR 1091 (42000) at line 127: Can't DROP 'freekey15'; check that column/key exists ERROR 1091 (42000) at line 131: Can't DROP 'freekey16'; check that column/key exists ERROR 1091 (42000) at line 135: Can't DROP 'freetime1'; check that column/key exists ERROR 1091 (42000) at line 139: Can't DROP 'freetime2'; check that column/key exists ERROR 1091 (42000) at line 143: Can't DROP 'freetime3'; check that column/key exists ERROR 1091 (42000) at line 147: Can't DROP 'freetime4'; check that column/key exists ERROR 1091 (42000) at line 151: Can't DROP 'freetime5'; check that column/key exists ERROR 1091 (42000) at line 155: Can't DROP 'freetime6'; check that column/key exists ERROR 1091 (42000) at line 159: Can't DROP 'a_freetext1'; check that column/key exists ERROR 1091 (42000) at line 163: Can't DROP 'a_freetext2'; check that column/key exists ERROR 1091 (42000) at line 167: Can't DROP 'a_freetext3'; check that column/key exists ERROR 1091 (42000) at line 171: Can't DROP 'a_freekey1'; check that column/key exists ERROR 1091 (42000) at line 175: Can't DROP 'a_freekey2'; check that column/key exists ERROR 1091 (42000) at line 179: Can't DROP 'a_freekey3'; check that column/key exists ERROR 1061 (42000) at line 180: Duplicate key name 'ticket_flag_per_user' --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs