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

[Hunt, Ron (PERATON)]

Thank you for the quick response.

Ron

From: Dave Miller <justdave at bugzilla.org>
Sent: Tuesday, January 2, 2024 10:39 AM
To: support-list at bugzilla.org; Hunt, Ron (PERATON) <Ronald.Hunt at peraton.com>
Subject: [EXTERNAL] Re: .checksetup.pl error generated during RHEL 8, MySql 8.0 and Bugzilla 5.0.6 installation

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<mailto: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/f5688a90/attachment-0001.html>