.checksetup.pl error generated during RHEL 8, MySql 8.0 and Bugzilla 5.0.6 installation
"Hunt, Ron (PERATON)" <[email protected]> Tue, 2 Jan 2024 12:37:08 +0000
| Newsgroups | gmane.comp.mozilla.devel.webtools |
|---|---|
| Message-ID | <SA1P110MB1568878622AAB3B0E9BEFA75F561A@SA1P110MB1568.NAMP110.PROD.OUTLOOK.COM> |
--===============4370111952241617569==
Content-Language: en-US
Content-Type: multipart/alternative;
boundary="_000_SA1P110MB1568878622AAB3B0E9BEFA75F561ASA1P110MB1568NAMP_"
--_000_SA1P110MB1568878622AAB3B0E9BEFA75F561ASA1P110MB1568NAMP_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Good morning,
I am currently in the process of upgrading my current RHEL 7 - MySql57 - Bu=
gzilla 5.0.6 to RHEL 8 - MySql8.0 - Bugzilla 5.0.6 due to RHEL 7 moving to =
end of life status.
Once I have everything installed and ran the .checksetup.pl script, I am ge=
tting the following error due to MySql8.0 using "group" preventing Bugzilla=
to use it as a primary key:
DBD::mysql::db selectrow_array failed: You have an error in your SQL syntax=
; check the manual that corresponds to your MySQL server version for the ri=
ght syntax to use near 'groups where name =3D ''' at line 1 [for Statement =
"SELECT id FROM groups where name =3D ''"] at Bugzilla/Install/DB.pm line 2=
497.
Bugzilla::Install::DB::_fix_group_with_empty_name() called at Bugzi=
lla/Install/DB.pm line 358
Bugzilla::Install::DB::update_table_definitions(HASH(0x55dd82199cc8=
)) called at ./checksetup.pl line 175
Any suggestions on how to resolve this issue?
Thank you,
Ron
--_000_SA1P110MB1568878622AAB3B0E9BEFA75F561ASA1P110MB1568NAMP_
Content-Type: text/html; charset="us-ascii"
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.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/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.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{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 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 curren=
t RHEL 7 – MySql57 – Bugzilla 5.0.6 to RHEL 8 – MySql8.0 =
– Bugzilla 5.0.6 due to RHEL 7 moving to end of life status.<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 .checks=
etup.pl script, I am getting the following error due to MySql8.0 using R=
20;group” 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 e=
rror in your SQL syntax; check the manual that corresponds to your MySQL se=
rver version for the right syntax to use near 'groups where name =3D ''' at=
line 1 [for Statement "SELECT id FROM
groups where name =3D ''"] at Bugzilla/Install/DB.pm line 2497.<o:p><=
/o:p></p>
<p class=3D"MsoNormal"> Bugzilla:=
:Install::DB::_fix_group_with_empty_name() called at Bugzilla/Install/DB.pm=
line 358<o:p></o:p></p>
<p class=3D"MsoNormal"> Bugzilla:=
:Install::DB::update_table_definitions(HASH(0x55dd82199cc8)) called at ./ch=
ecksetup.pl 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>
</body>
</html>
--_000_SA1P110MB1568878622AAB3B0E9BEFA75F561ASA1P110MB1568NAMP_--
--===============4370111952241617569==
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
--===============4370111952241617569==--