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

Dave Miller justdave at
Tue Jan 2 15:39:02 UTC 2024

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> 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 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/ line 2497.
>        Bugzilla::Install::DB::_fix_group_with_empty_name() called at Bugzilla/Install/ line 358
>        Bugzilla::Install::DB::update_table_definitions(HASH(0x55dd82199cc8)) called at ./ line 175
>Any suggestions on how to resolve this issue?
>Thank you,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the support-list mailing list