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

[Dave Miller]

Bugzilla doesn't currently work with MySQL 8. You'll need to use MariaDB instead.

We're hoping to have MySQL 8 supported again in version 5.2.1 or so (5.2 which is about to be released will probably have MySQL 8 blocklisted because the compatibility fixes aren't quite ready to land yet, it's an extremely invasive patch)

On January 2, 2024 7:37:08 AM EST, "Hunt, Ron (PERATON)" <Ronald.Hunt at peraton.com> wrote:
>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/cf531da2/attachment.html>