<html>
<head>
<!-- Template generated by Exclaimer Signature Manager Exchange Edition on 09:09:22 Friday, 28 May 2021 -->
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css">P.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
LI.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
DIV.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
TABLE.ImprintUniqueIDTable {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
</head>
<body>
<p class="ImprintUniqueID"></p>
<div>> More problems with checksetup.pl, this time it seems that mysql 8 made "groups" a keyword,<br>
> so statements like "select groups from..." are failing. Fix seems to be enclose groups in<br>
> backticks: `groups`<br>
> - Edited DB.pm, changed line 2497<br>
> - Edited DB.pm, changed line 2950<br>
<br>
This is from our recent upgrade notes. Eventually we realized this wasn't fixable, so we tried downgrading to 8.0.19, which IIRC was just before the GROUPS keyword was introduced. But then we ran into other issues.<br>
<br>
So we gave up on v8 and downgraded to MySQL 5.7.30, which seems to work well enough. We recently upgraded to 5.7.34 and it's still working.<br>
<br>
Regards,<br>
Dan<br>
<br>
<br>
</div>
<br>
<p></p>
<p class="ImprintUniqueID">
<table class="ImprintUniqueIDTable" style="HEIGHT: 78px; WIDTH: 330px" borderColor="#ffffff" cellspacing="0" cellpadding="0" width="230" border="0">
<tbody>
<tr>
<td style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: #484848; PADDING-BOTTOM: 5px" valign="bottom" nowrap="">
<span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: #484848"><span style="FONT-SIZE: 13.5pt; FONT-FAMILY: Verdana"><font face="Arial"><font color="#055d8f"><strong><font style="font-size:10pt;">Daniel</font><font size="2"> </font><font style="font-size:10pt;">McCarty</font><br>
</strong></font></font></span><span style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana; COLOR: #484848"><font color="#808080" face="Arial"><strong><font style="font-size:10pt;">Director of Engineering</font></strong></font></span></span></td>
</tr>
<tr>
<td><span style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana; COLOR: #484848"><font color="#808080" size="2" face="Arial">W. H. Leary Co.<br>
<font color="#055d8f">P.</font> +1 708.444.4900</font></span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Verdana; COLOR: #484848"><font color="#808080"><br>
<font size="2"><font color="#055d8f">E.</font> </font><font style="font-family:Arial;font-size:10pt;color:#808080;">danielm@whleary.com</font><font size="2"> |
</font></font><font size="2"><font color="#055d8f">W.</font> </font><span style="font-family:Arial;font-size:10pt;color:#808080;"><a href="http://www.whleary.com" title="" target="" style="font-family:Arial;font-size:10pt;color:#808080;"><span style="font-family:Arial; font-size:10pt; color:#808080;">whleary.com</span></a></span><font size="1" face="Arial"></font></span></td>
</tr>
</tbody>
</table>
</p>
<p class="ImprintUniqueID"><br>
</p>
<div>
<div>-----Original Message-----<br>
From: support-list <support-list-bounces@bugzilla.org> On Behalf Of Thorsten Schöning<br>
Sent: Friday, May 28, 2021 7:49 AM<br>
To: support-list@bugzilla.org<br>
Subject: Re: [External] [EXT] Re: Bugzilla<br>
<br>
Guten Tag John Claessen,<br>
am Freitag, 28. Mai 2021 um 13:02 schrieben Sie:<br>
<br>
> Bugzilla now uses the InnoDB storage engine in MySQL for most tables.<br>
> Converting tables to InnoDB:<br>
> Converting table groups... DBD::mysql::db do failed: You have an error<br>
> in your SQL syntax; check the manual that corresponds to your MySQL<br>
> server version for the right syntax to use near 'groups ENGINE =<br>
> InnoDB' at line 1 [for Statement "ALTER TABLE groups ENGINE = InnoDB"]<br>
> at Bugzilla/DB/Mysql.pm line 391, <DATA> line 747.<br>
<br>
This is a known issue: Starting with MySQL 8 the term "groups" is a keyword and needs to be quoted, which is Bugzilla is not doing currently. You need to use an older MySQL or MariaDB/PostgreSQL instead. There has been some work to quote those terms, but I'm
not sure in which branch which state is available. Better use a released Bugzilla with a compatible DB-engine.<br>
<br>
https://urldefense.proofpoint.com/v2/url?u=https-3A__groups.google.com_g_mozilla.support.bugzilla_c_8KJ6UPAnvPE-3Fpli-3D1&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=aiw6D0qoNvEhIj4UbScPS91eCqA9AzDSvZw3rdzuaU4&e=<br>
https://urldefense.proofpoint.com/v2/url?u=https-3A__bugzilla.mozilla.org_show-5Fbug.cgi-3Fid-3D1592129&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=vMmmmQspiYkHt3jkxlqXPB6GfqKvx3PALHOhJ0FXY04&e=<br>
https://urldefense.proofpoint.com/v2/url?u=https-3A__bugzilla.mozilla.org_show-5Fbug.cgi-3Fid-3D1614511&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=hkwtr79PhlIK7vc0smOoX_tR8Cy8iaR33xHMcsALLVk&e=<br>
https://urldefense.proofpoint.com/v2/url?u=https-3A__www.bugzilla.org_docs_4.4_en_html_api_contrib_bzdbcopy.html&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=C6in9RzKNHdZZCeOydvNMXuO3hQ4BJcDD5Vh-fbFcWE&e=<br>
<br>
Mit freundlichen Grüßen<br>
<br>
Thorsten Schöning<br>
<br>
--<br>
AM-SoFT IT-Service - Bitstore Hameln GmbH i.G.<br>
Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK<br>
<br>
E-Mail: Thorsten.Schoening@AM-SoFT.de<br>
Web: https://urldefense.proofpoint.com/v2/url?u=http-3A__www.AM-2DSoFT.de_&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=uOcZd4xTKHmtSm8gTe9Q4VhOPX8gmjppUTKY360yPKM&e=<br>
<br>
Tel: 05151- 9468- 0<br>
Tel: 05151- 9468-55<br>
Fax: 05151- 9468-88<br>
Mobil: 0178-8 9468-04<br>
<br>
AM-SoFT IT-Service - Bitstore Hameln GmbH i.G., Brandenburger Str. 7c, 31789 Hameln AG Hannover HRB neu - Geschäftsführer: Janine Galonska<br>
<br>
<br>
Für Rückfragen stehe ich Ihnen sehr gerne zur Verfügung.<br>
<br>
Mit freundlichen Grüßen<br>
<br>
Thorsten Schöning<br>
<br>
<br>
Tel: 05151 9468 0<br>
Fax: 05151 9468 88<br>
Mobil:<br>
Webseite: https://urldefense.proofpoint.com/v2/url?u=https-3A__www.am-2Dsoft.de&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=rAYfQZovnEQnEXj_0lbQ-R2gQOZ7Ab-A9X2yZt-CJLA&e=<br>
<br>
AM-Soft IT-Service - Bitstore Hameln GmbH i.G. ist ein Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK<br>
<br>
AM-Soft IT-Service - Bitstore Hameln GmbH i.G.<br>
Brandenburger Str. 7c<br>
31789 Hameln<br>
Tel: 05151 9468 0<br>
<br>
Bitstore IT-Consulting GmbH<br>
Zentrale - Berlin Lichtenberg<br>
Frankfurter Allee 285<br>
10317 Berlin<br>
Tel: 030 453 087 80<br>
<br>
CBS IT-Service - Bitstore Kaulsdorf UG<br>
Tel: 030 453 087 880 1<br>
<br>
Büro Dallgow-Döberitz<br>
Tel: 03322 507 020<br>
<br>
Büro Kloster Lehnin<br>
Tel: 033207 566 530<br>
<br>
PCE IT-Service - Bitstore Darmstadt UG<br>
Darmstadt<br>
Tel: 06151 392 973 0<br>
<br>
Büro Neuruppin<br>
Tel: 033932 606 090<br>
<br>
ACI EDV Systemhaus - Bitstore Dresden GmbH Dresden<br>
Tel: 0351 254 410<br>
<br>
Das Systemhaus - Bitstore Magdeburg GmbH Magdeburg<br>
Tel: 0391 636 651 0<br>
<br>
https://urldefense.proofpoint.com/v2/url?u=http-3A__Allerdata.IT&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=9Wo3uOKuVgqleIucNHUMpoi-Vq0KHgfov19ZXIrgcWM&e=
- Bitstore Wittenberg GmbH Wittenberg<br>
Tel: 03491 876 735 7<br>
<br>
Büro Liebenwalde<br>
Tel: 033054 810 00<br>
<br>
HSA - das Büro - Bitstore Altenburg UG<br>
Altenburg<br>
Tel: 0344 784 390 97<br>
<br>
Bitstore IT – Consulting GmbH<br>
NL Piesteritz<br>
Piesteritz<br>
Tel: 03491 644 868 6<br>
<br>
Solltec IT-Services - Bitstore Braunschweig UG Braunschweig<br>
Tel: 0531 206 068 0<br>
<br>
MF Computer Service - Bitstore Gütersloh GmbH Gütersloh<br>
Tel: 05245 920 809 3<br>
<br>
Firmensitz: AM-Soft IT-Service - Bitstore Hameln GmbH i.G. , Brandenburger Str. 7c , 31789 Hameln Geschäftsführer Janine Galonska<br>
<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
support-list mailing list<br>
support-list@bugzilla.org<br>
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.bugzilla.org_listinfo_support-2Dlist&d=DwIGaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=KfJK_i8bAAiKEOAyAm9y9vt5kSwc8dkKCDiCjPA9mhw&m=YdUzZPDrA4nHypTj-EP4yupl3t3rQSZxqzwlhEUMM9w&s=MyozZxWLYMEHd9tv4c8qIm84oLE1Iyq1YbHMSJm1x14&e=<br>
</div>
</div>
</body>
</html>