1898161 - UTF-8 conversion fails on Mysql 8+

Status: RESOLVED FIXED

(Bugzilla :: Installation & Upgrading, defect)

Description

[Dave Miller [:justdave]]

Converting the flagtypes table to UTF-8...
DBD::mysql::st execute 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' at line 1 [for Statement "SHOW FULL COLUMNS FROM groups"] at Bugzilla/DB/Mysql.pm line 729.
	Bugzilla::DB::Mysql::bz_setup_database(Bugzilla::DB::Mysql=HASH(0x62cf6f86b748)) called at checksetup.pl line 133

Comment 1

[BMO Github Automation]

Attachment: [bugzilla/bugzilla] [5.2] Bug 1898161: fix utf8-conversion on MySQL 8 (#193)

Comment 2

[Dave Miller [:justdave]]

This is broken in Harmony, too. I guess Harmony does better at not trying to do a utf-8 conversion on a new install.

Comment 3

[BMO Github Automation]

Attachment: [bugzilla/harmony] [harmony] Bug 1898161: fix utf8-conversion on MySQL 8 (#136)

Comment 4

[Dave Miller [:justdave]]

Comment on attachment 9403141 [details] [review]
[bugzilla/harmony] [harmony] Bug 1898161: fix utf8-conversion on MySQL 8 (#136)

removing duplicate PR reference

Comment 5

[Dave Miller [:justdave]]

Comment on attachment 9403142 [details] [review]
[bugzilla/harmony] [harmony] Bug 1898161: fix utf8-conversion on MySQL 8 (#136)

Landed in Harmony:
https://github.com/bugzilla/harmony/commit/ede41711604063895b42d142fff1899cfd35d024

Comment 6

[Dave Miller [:justdave]]

Comment on attachment 9403139 [details] [review]
[bugzilla/bugzilla] [5.2] Bug 1898161: fix utf8-conversion on MySQL 8 (#193)

Landed on 5.2:
https://github.com/bugzilla/bugzilla/commit/fb710d6c6da3335d3d7871c05bbce9325a207cc5