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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 --------------------------------------------------------------------- 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
