which branch supports mysql 8

[balag...@gmail.com]

I have tried release-5.0-stable and 5.2 but I cannot get bugzilla installed. It appears to fail because groups is a keyword in mysql 8 and it is not being quoted. Here is the error with branch 5.2 (release-5.0-stable fails differently):

DBD::mysql::db do 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 (
id mediumint auto_increment PRIMARY KEY NOT NULL,
name varchar(255) N' at line 1 [for Statement "CREATE TABLE groups (
id mediumint auto_increment PRIMARY KEY NOT NULL,
name varchar(255) NOT NULL,
description mediumtext NOT NULL,
isbuggroup tinyint NOT NULL,
userregexp tinytext DEFAULT '' NOT NULL,
isactive tinyint DEFAULT 1 NOT NULL,
icon_url tinytext
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT=Compact"] at Bugzilla/DB.pm line 63, <DATA> line 755.
Bugzilla::DB::__ANON__(Bugzilla::DB::Mysql=HASH(0x55c7be374638), "CREATE TABLE groups (\x{a}\x{9}id\x{9}mediumint auto_increment PRIMARY KE"...) called at Bugzilla/DB.pm line 882
Bugzilla::DB::_bz_add_table_raw(Bugzilla::DB::Mysql=HASH(0x55c7be374638), "groups", HASH(0x55c7be554aa0)) called at Bugzilla/DB.pm line 843
Bugzilla::DB::bz_add_table(Bugzilla::DB::Mysql=HASH(0x55c7be374638), "groups", HASH(0x55c7be554aa0)) called at Bugzilla/DB.pm line 552
Bugzilla::DB::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x55c7be374638)) called at Bugzilla/DB/Mysql.pm line 586
Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x55c7be374638)) called at ./checksetup.pl line 123

[Dave Miller]

We probably won't support it. Adding groups as a reserved word was unfortunate. Getting compatible with it requires a significant chunk of Bugzilla to be rewritten.

The recommendation right now is to use MariaDB instead of MySQL (MariaDB 10.x should be a drop-in replacement for MySQL 8.x)

>_______________________________________________
>support-bugzilla mailing list
>support-...@lists.mozilla.org
>https://lists.mozilla.org/listinfo/support-bugzilla
>PLEASE put support-...@lists.mozilla.org in the To: field when you reply.

--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.

[balag...@gmail.com]

Thanks for the prompt response. I was hoping to install it in an existing instance to save money and maintenance complexity. It would be helpful to others to mention something about this in the documentation. I couldn't find much so I started going over the source and found some history suggesting it was working at one point, maybe 5.0.6, but couldn't find that branch.

[Thorsten Schöning]

Guten Tag balag...@gmail.com,
am Mittwoch, 8. April 2020 um 01:16 schrieben Sie:

> I couldn't find much so I started going over the
> source and found some history suggesting it was working at one
> point, maybe 5.0.6, but couldn't find that branch.

5.0.6 is 5.0 actually, but that doesn't seem to contain most of the
associated work. So if 5.2 doesn't work, it's still broken and you
need to use an older version, MariaDB or PostgreSQL.

https://bugzilla.mozilla.org/show_bug.cgi?id=1592129
https://github.com/bugzilla/bugzilla/commits/5.2

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail: Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow