Migrate Bugzilla 2.7 to new server

Hi all,
I need to migrate an old Bugzilla 2.7 with Mysql 4.1 to a new server. I hav=
e installed Mysql 5.7 on the new server. I dumped and restored the database=
.. When I run the application I got following error. Error Code: 1054. Unkno=
wn column 'bugs.bug_id' in 'on clause'. It looks like Mysql 5.7 doesn't sup=
port mixing explicit and implicit query. Any help is appreciated.

SELECT bugs.bug_id, bugs.bug_severity, bugs.priority FROM bugs, profiles AS=
 map_assigned_to
LEFT JOIN bug_group_map ON bug_group_map.bug_id =3D bugs.bug_id
0
Luyin
8/8/2019 7:09:32 PM
mozilla.support.bugzilla 10104 articles. 0 followers. Post Follow

4 Replies
52 Views

Similar Articles

[PageSpeed] 16

Guten Tag Luyin Sun,
am Donnerstag, 8. August 2019 um 21:09 schrieben Sie:

> I need to migrate an old Bugzilla 2.7 with Mysql 4.1 to a new

2.7 sounds pretty unlikely, even the official repo only goes back
until 2.14 and according current dev standards 2.7 would have been a
development release not suitable for production use.

> server. I have installed Mysql 5.7 on the new server. I dumped and
> restored the database. When I run the application I got following
> error. Error Code: 1054. Unknown column 'bugs.bug_id' in 'on
> clause'.

What "application" exactly? You can't just dump the database and run
Bugzilla in the web browser, you need to always run checksetup.pl
first. That checks for necessary Perl libs in your new environment,
optionally upgrades your database, depending on which version of
Bugzilla you are using on the new server etc.

> It looks like Mysql 5.7 doesn't support mixing explicit and
> implicit query. Any help is appreciated.

Not sure what you are trying to tell here, but I would start looking
at the database if the column mentioned in the error really exists.

Mit freundlichen Gr=FC=DFen,

Thorsten Sch=F6ning

--=20
Thorsten Sch=F6ning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Gesch=E4ftsf=FChrer: Andreas Muchow

0
windows
8/9/2019 8:42:15 AM
On Friday, August 9, 2019 at 4:42:29 AM UTC-4, Thorsten Sch=C3=B6ning wrote=
:
> Guten Tag Luyin Sun,
> am Donnerstag, 8. August 2019 um 21:09 schrieben Sie:
>=20
> > I need to migrate an old Bugzilla 2.7 with Mysql 4.1 to a new
>=20
> 2.7 sounds pretty unlikely, even the official repo only goes back
> until 2.14 and according current dev standards 2.7 would have been a
> development release not suitable for production use.
>=20
> > server. I have installed Mysql 5.7 on the new server. I dumped and
> > restored the database. When I run the application I got following
> > error. Error Code: 1054. Unknown column 'bugs.bug_id' in 'on
> > clause'.
>=20
> What "application" exactly? You can't just dump the database and run
> Bugzilla in the web browser, you need to always run checksetup.pl
> first. That checks for necessary Perl libs in your new environment,
> optionally upgrades your database, depending on which version of
> Bugzilla you are using on the new server etc.
>=20
> > It looks like Mysql 5.7 doesn't support mixing explicit and
> > implicit query. Any help is appreciated.
>=20
> Not sure what you are trying to tell here, but I would start looking
> at the database if the column mentioned in the error really exists.
>=20
> Mit freundlichen Gr=C3=BC=C3=9Fen,
>=20
> Thorsten Sch=C3=B6ning
>=20
> --=20
> Thorsten Sch=C3=B6ning       E-Mail: Thorsten.Schoening@AM-SoFT.de
> AM-SoFT IT-Systeme      http://www.AM-SoFT.de/
>=20
> Telefon...........05151-  9468- 55
> Fax...............05151-  9468- 88
> Mobil..............0178-8 9468- 04
>=20
> AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
> AG Hannover HRB 207 694 - Gesch=C3=A4ftsf=C3=BChrer: Andreas Muchow

Thanks for your time. I have to rewrite queries in .pm file to meet new Mys=
ql standard. Now it's working.
0
Luyin
8/9/2019 1:53:44 PM
Guten Tag Luyin Sun,
am Freitag, 9. August 2019 um 15:53 schrieben Sie:

> Thanks for your time. I have to rewrite queries in .pm file to meet
> new Mysql standard. Now it's working.

Remember to either provide your fixes back to the project if it has
been an error before or simply upgrade your old installation. It's
pretty difficult to keep track of such customizations in the long
term.

Mit freundlichen Gr=C3=BC=C3=9Fen,

Thorsten Sch=C3=B6ning

--=20
Thorsten Sch=C3=B6ning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Gesch=C3=A4ftsf=C3=BChrer: Andreas Muchow

0
utf
8/9/2019 4:19:36 PM
On Friday, August 9, 2019 at 12:19:49 PM UTC-4, Thorsten Sch=C3=B6ning wrot=
e:
> Guten Tag Luyin Sun,
> am Freitag, 9. August 2019 um 15:53 schrieben Sie:
>=20
> > Thanks for your time. I have to rewrite queries in .pm file to meet
> > new Mysql standard. Now it's working.
>=20
> Remember to either provide your fixes back to the project if it has
> been an error before or simply upgrade your old installation. It's
> pretty difficult to keep track of such customizations in the long
> term.
>=20
> Mit freundlichen Gr=C3=BC=C3=9Fen,
>=20
> Thorsten Sch=C3=B6ning
>=20
> --=20
> Thorsten Sch=C3=B6ning       E-Mail: Thorsten.Schoening@AM-SoFT.de
> AM-SoFT IT-Systeme      http://www.AM-SoFT.de/
>=20
> Telefon...........05151-  9468- 55
> Fax...............05151-  9468- 88
> Mobil..............0178-8 9468- 04
>=20
> AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
> AG Hannover HRB 207 694 - Gesch=C3=A4ftsf=C3=BChrer: Andreas Muchow

I am pretty sure it should be already fixed in latest version. Our instance=
 is way behind release. I am afread to upgrade it. That's why I just fixed =
it in the code. We are using our instance only for history bug reference. T=
here is no need to maintain or upgrade it.
0
Luyin
8/9/2019 4:47:02 PM
Reply: