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
