Re: .checksetup.pl error generated during RHE L 8, MySql 8.0 and Bugzilla 5.0.6 installation
Dave Miller <[email protected]> Tue, 02 Jan 2024 10:39:02 -0500
| Newsgroups | gmane.comp.mozilla.devel.webtools |
|---|---|
| Message-ID | <[email protected]> |
--===============6954032787759182565==
Content-Type: multipart/alternative;
boundary=----92YVRUSS79FIKONN4R3D8D2F31WIDV
Content-Transfer-Encoding: 7bit
------92YVRUSS79FIKONN4R3D8D2F31WIDV
Content-Type: text/plain;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
Bugzilla doesn't currently work with MySQL 8=2E You'll need to use MariaDB =
instead=2E
We're hoping to have MySQL 8 supported again in version 5=2E2=2E1 or so (5=
=2E2 which is about to be released will probably have MySQL 8 blocklisted b=
ecause the compatibility fixes aren't quite ready to land yet, it's an extr=
emely invasive patch)
On January 2, 2024 7:37:08 AM EST, "Hunt, Ron (PERATON)" <Ronald=2EHunt@pe=
raton=2Ecom> wrote:
>Good morning,
>
>I am currently in the process of upgrading my current RHEL 7 - MySql57 - =
Bugzilla 5=2E0=2E6 to RHEL 8 - MySql8=2E0 - Bugzilla 5=2E0=2E6 due to RHEL =
7 moving to end of life status=2E
>
>Once I have everything installed and ran the =2Echecksetup=2Epl script, I=
am getting the following error due to MySql8=2E0 using "group" preventing =
Bugzilla to use it as a primary key:
>
>DBD::mysql::db selectrow_array failed: You have an error in your SQL synt=
ax; check the manual that corresponds to your MySQL server version for the =
right syntax to use near 'groups where name =3D ''' at line 1 [for Statemen=
t "SELECT id FROM groups where name =3D ''"] at Bugzilla/Install/DB=2Epm li=
ne 2497=2E
> Bugzilla::Install::DB::_fix_group_with_empty_name() called at Bug=
zilla/Install/DB=2Epm line 358
> Bugzilla::Install::DB::update_table_definitions(HASH(0x55dd82199c=
c8)) called at =2E/checksetup=2Epl line 175
>
>Any suggestions on how to resolve this issue?
>
>Thank you,
>
>Ron
------92YVRUSS79FIKONN4R3D8D2F31WIDV
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas=2Emicrosoft=2Ecom/office/2004/12/omml" xmlns=3D"h=
ttp://www=2Ew3=2Eorg/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii=
">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p=2EMsoNormal, li=2EMsoNormal, div=2EMsoNormal
{margin:0in;
font-size:11=2E0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
span=2EEmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
=2EMsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8=2E5in 11=2E0in;
margin:1=2E0in 1=2E0in 1=2E0in 1=2E0in;}
div=2EWordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap=
:break-word"><div dir=3D"auto">Bugzilla doesn't currently work with MySQL 8=
=2E You'll need to use MariaDB instead=2E<br><br>We're hoping to have MySQL=
8 supported again in version 5=2E2=2E1 or so (5=2E2 which is about to be r=
eleased will probably have MySQL 8 blocklisted because the compatibility fi=
xes aren't quite ready to land yet, it's an extremely invasive patch)</div>=
<br><br><div class=3D"gmail_quote"><div dir=3D"auto">On January 2, 2024 7:3=
7:08 AM EST, "Hunt, Ron (PERATON)" <Ronald=2EHunt@peraton=2Ecom> wrot=
e:</div><blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0=2E=
8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Good morning,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">I am currently in the process of upgrading my curre=
nt RHEL 7 =E2=80=93 MySql57 =E2=80=93 Bugzilla 5=2E0=2E6 to RHEL 8 =E2=80=
=93 MySql8=2E0 =E2=80=93 Bugzilla 5=2E0=2E6 due to RHEL 7 moving to end of =
life status=2E<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Once I have everything installed and ran the =2Eche=
cksetup=2Epl script, I am getting the following error due to MySql8=2E0 usi=
ng =E2=80=9Cgroup=E2=80=9D preventing Bugzilla to use it as a primary key:<=
o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">DBD::mysql::db selectrow_array failed: You have an =
error in your SQL syntax; check the manual that corresponds to your MySQL s=
erver version for the right syntax to use near 'groups where name =3D ''' a=
t line 1 [for Statement "SELECT id FROM
groups where name =3D ''"] at Bugzilla/Install/DB=2Epm line 2497=2E<o:p><=
/o:p></p>
<p class=3D"MsoNormal"> Bugzilla=
::Install::DB::_fix_group_with_empty_name() called at Bugzilla/Install/DB=
=2Epm line 358<o:p></o:p></p>
<p class=3D"MsoNormal"> Bugzilla=
::Install::DB::update_table_definitions(HASH(0x55dd82199cc8)) called at =2E=
/checksetup=2Epl line 175<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Any suggestions on how to resolve this issue?<o:p><=
/o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Thank you,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Ron<o:p></o:p></p>
</div>
</blockquote></div></body>
</html>
------92YVRUSS79FIKONN4R3D8D2F31WIDV--
--===============6954032787759182565==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
support-list mailing list
[email protected]
https://lists.bugzilla.org/listinfo/support-list
--===============6954032787759182565==--