ich bin gerade am vorbereiten für den Umstieg von ((OTRS)) 6 auf znuny, damit hier alles sauber ist, war der Gedanke, ich nehme ein Testsystem und spiele das ganze da mal drauf und wenn dann alles klappt geht das ins Produktiv System.
Hier bin ich beim Script für die Migration auf znuny 6.1 auf folgende Situation gestoßen:
Code: Select all
scripts/MigrateToZnuny6_1.pl
Migration started ...
Checking requirements ...
Requirement check for: Check framework version ...
Requirement check for: Check required Perl version ...
Requirement check for: Check required database version ...
Requirement check for: Check database charset ...
Requirement check for: Check required Perl modules ...
Requirement check for: Check if database has been backed up ...
Did you backup the database? [Y]es/[N]o: Y
Requirement check for: Upgrade database structure ...
Executing tasks ...
Step 1 of 19: Check framework version ...
Step 2 of 19: Check required Perl version ...
Step 3 of 19: Check required database version ...
Step 4 of 19: Check database charset ...
Step 5 of 19: Check required Perl modules ...
Step 6 of 19: Check installed CPAN modules for known vulnerabilities ...
Step 7 of 19: Check if database has been backed up ...
Step 8 of 19: Upgrade database structure ...
[Thu Dec 23 08:51:05 2021] MigrateToZnuny6_1.pl: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups RENAME permission_groups' at line 1 at /opt/znuny-6.1.2/Kernel/System/DB.pm line 471.
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.30.0 OS: linux Time: Thu Dec 23 07:51:05 2021
Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups RENAME permission_groups' at line 1, SQL: 'ALTER TABLE groups RENAME permission_groups'
Traceback (28179):
Module: scripts::MigrateToZnuny6_1::Base::ExecuteXMLDBString Line: 394
Module: scripts::MigrateToZnuny6_1::Base::ExecuteXMLDBArray Line: 342
Module: scripts::MigrateToZnuny6_1::UpgradeDatabaseStructure::RenameTables::Run Line: 34
Module: scripts::MigrateToZnuny6_1::UpgradeDatabaseStructure::Run Line: 79
Module: scripts::MigrateToZnuny6_1::_ExecuteComponent Line: 158
Module: scripts::MigrateToZnuny6_1::Run Line: 70
Module: scripts/MigrateToZnuny6_1.pl Line: 82
ERROR: OTRS-otrs.Console.pl-Dev::Code::CPANAudit-10 Perl: 5.30.0 OS: linux Time: Thu Dec 23 07:51:05 2021
Message: Error during execution of 'ALTER TABLE groups RENAME permission_groups'!
Traceback (28179):
Module: scripts::MigrateToZnuny6_1::Base::ExecuteXMLDBString Line: 397
Module: scripts::MigrateToZnuny6_1::Base::ExecuteXMLDBArray Line: 342
Module: scripts::MigrateToZnuny6_1::UpgradeDatabaseStructure::RenameTables::Run Line: 34
Module: scripts::MigrateToZnuny6_1::UpgradeDatabaseStructure::Run Line: 79
Module: scripts::MigrateToZnuny6_1::_ExecuteComponent Line: 158
Module: scripts::MigrateToZnuny6_1::Run Line: 70
Module: scripts/MigrateToZnuny6_1.pl Line: 82
Not possible to complete migration. Check previous messages for more information.
Und zwar ist es hier anscheinend so, dass das group hier als Teil eines Schlüsselwortes group by erkannt wird und daher auf einen Fehler läuft,
abhilfe schafft hier das das group in "BackTicks" gesetzt wird:
Code: Select all
mysql> ALTER TABLE `groups` RENAME `permission_groups`;
Query OK, 0 rows affected (1,54 sec)
Quelle:
https://stackoverflow.com/questions/126 ... e-in-mysql