Ryan Gordon
Miscellaneous | Programmer | May 18, 2020, 12:16:35 (ET) | icculus@icculus.org

Irritatingly, MySQL 8 reserves (but does not use) the keyword "groups,"
so if you happened to have something like this:

SELECT name FROM groups where user=5;

Then as soon as you upgraded to MySQL 8, your query would be a syntax error.

This will work, though:

SELECT name FROM `groups` where user=5;

Naturally, Bugzilla has a table named "groups", so this broke.

Ubuntu started shipping MySQL 8 in 2019, and there was never a Bugzilla
5.0.7 release to fix this (the unreleased 5.2 branch supposedly has this
fixed, but I'm not sure).

If you, like me, just updated your old Ubuntu server and
found--surprise!--that the stable Bugzilla release no longer works, here's
[a patch to 5.0.6 to fix it][1].

I can't say this is correct, complete, or sane, but it got the bug tracker
up and running again here.

[1]: https://icculus.org/~icculus/dotplan/bugzilla-5.0.6-mysql8.diff


When this .plan was written: 2020-05-18 12:16:35
.plan archives for this user: finger icculus?listarchives=1@icculus.org
Powered by IcculusFinger v2.1.27 (https://icculus.org/IcculusFinger/)
Stick it in the camel and go.

Ryan Gordon 05/18
Jeff Heath 12/13
Don MacAskill 07/24
Ryan Feltrin 04/25
Ron Crisco 05/30
Scott Rice 04/23
Richard Smith 11/13

Also Today...


Full list

Visit Webdog today!


Square Eight - Taking over the world and you don't even know it yet! Copyright © Square Eight 1998-2024. All Rights Reserved.
The BlueTracker is provided by Webdog.
We are not responsible for the content of the .plans displayed here.