Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL 8: 'groups' is no longer allowed as unquoted table name #6

Closed
4 tasks done
bschmalhofer opened this issue May 7, 2020 · 2 comments
Closed
4 tasks done

MySQL 8: 'groups' is no longer allowed as unquoted table name #6

bschmalhofer opened this issue May 7, 2020 · 2 comments
Milestone
OTOBO 10.0.1

Comments

@bschmalhofer
Copy link
Contributor

bschmalhofer commented May 7, 2020 •
edited
Loading

'groups' is a reserved word in MySQL 8. The solution is to rename the table 'groups' to 'groups_table'.

TODO:

  • adapt the table creation in the table creation step during installation
  • rename 'groups' to 'groups_table' in the OTOBO Perl modules
  • rename 'groups' to 'groups_table' in the OTOBO test scripts
  • migrate 'groups' to 'groups_table' during the migration to OTOBO 10
@bschmalhofer bschmalhofer mentioned this issue May 7, 2020
Closed
5 tasks
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 7, 2020
@bschmalhofer
Issue RotherOSS#6: groups -> groups_table in setup .xml
7163457
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 7, 2020
@bschmalhofer
Issue RotherOSS#6: groups -> groups_table in scripts/database/*.sql
5d710e4 
These files might be obsolete.
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 7, 2020
@bschmalhofer
Issue RotherOSS#6: groups -> groups_table in Kernel::System modules
b3aaf3e
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 7, 2020
@bschmalhofer
ssue RotherOSS#6: groups -> groups_table in test scripts
5bd37c1
@bschmalhofer
Copy link
Contributor Author

bschmalhofer commented May 7, 2020 •
edited
Loading

Ist noch nicht getestet.

Migrationskript auf OTOBO 10 ist ein separates issue

@bschmalhofer
Copy link
Contributor Author

The table name has been changes and OTOBO still seems to work.

@bschmalhofer bschmalhofer added this to the OTOBO 10.0 milestone Jul 22, 2020
@Wolverine80 Wolverine80 mentioned this issue Nov 13, 2020
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
OTOBO 10.0.1
Development

No branches or pull requests
1 participant
@bschmalhofer