.checksetup.pl error generated during RHEL 8, MySql 8.0 and Bugzilla 5.0.6 installation

[Hunt, Ron (PERATON)]

Good morning,

I am currently in the process of upgrading my current RHEL 7 - MySql57 - Bugzilla 5.0.6 to RHEL 8 - MySql8.0 - Bugzilla 5.0.6 due to RHEL 7 moving to end of life status.

Once I have everything installed and ran the .checksetup.pl script, I am getting the following error due to MySql8.0 using "group" preventing Bugzilla to use it as a primary key:

DBD::mysql::db selectrow_array 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 where name = ''' at line 1 [for Statement "SELECT id FROM groups where name = ''"] at Bugzilla/Install/DB.pm line 2497.
        Bugzilla::Install::DB::_fix_group_with_empty_name() called at Bugzilla/Install/DB.pm line 358
        Bugzilla::Install::DB::update_table_definitions(HASH(0x55dd82199cc8)) called at ./checksetup.pl line 175

Any suggestions on how to resolve this issue?

Thank you,

Ron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/support-list/attachments/20240102/405e8a6e/attachment.html>