Hi Kay and Gerald, there was indeed a mistake in our UPGRADING file which was fixed last week. Please find the latest version here: http://source.otrs.org/viewvc.cgi/otrs/UPGRADING?view=markup&pathrev=rel-3_1
Best regards, mg Am 13.08.12 18:49, schrieb guckuck: > 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 > -- Martin Gruner Senior Developer R&D OTRS AG Europaring 4 94315 Straubing T: +49 (0)6172 681988 0 F: +49 (0)9421 56818 18 I: www.otrs.com/ Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065 Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn, Sabine Riedel Verbinden wir uns! OTRS 3.1 schafft einfachere Integration mit Drittapplikationen – Für Frühbucher zum Vorzugspreis: http://www.otrs.com/index.php?id=2361&L=1 --------------------------------------------------------------------- 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
