Upgrading bugzilla 4.2.4 to 5.0.6

[Pierre Hernandez]

Hello all,

I would like to upgrade my bugzilla application from 4.2.4 to 5.0.6.

Should i have to apply all existing patches between 4.2.4 and 5.0.6 or am i able to migrate directly 4.2.4 to 5.06 ?

i tried the second option and i have the below error:

DBD::mysql::db do failed: Cannot change column 'id': used in a foreign key constraint 'fk_test_case_components_component_id_components_id' of table 'prod_bugzilla.test_case_components' [for Statement "ALTER TABLE components CHANGE COLUMN
id id mediumint auto_increment NOT NULL"] at Bugzilla/DB.pm line 754.
Bugzilla::DB::bz_alter_column_raw(Bugzilla::DB::Mysql=HASH(0x55d246201b90), "components", "id", HASH(0x55d2456c10f8), HASH(0x55d249445668), undef) called at Bugzilla/DB.pm line 713
Bugzilla::DB::bz_alter_column(Bugzilla::DB::Mysql=HASH(0x55d246201b90), "components", "id", HASH(0x55d2456c10f8)) called at Bugzilla/Install/DB.pm line 4182
Bugzilla::Install::DB::_fix_components_primary_key() called at Bugzilla/Install/DB.pm line 712
Bugzilla::Install::DB::update_table_definitions(HASH(0x55d23f9235c8)) called at ./checksetup.pl line 175

Any advices?

Thanks for your help,

Pierre

[Thorsten Schöning]

Guten Tag Pierre Hernandez,
am Dienstag, 2. Februar 2021 um 15:45 schrieben Sie:

> Should i have to apply all existing patches between 4.2.4 and 5.0.6
> or am i able to migrate directly 4.2.4 to 5.06 ?

No patches necessary, get 5.0.6 using GIT, read the following first:

https://bugzilla.readthedocs.io/en/5.0/installing/upgrading.html

> DBD::mysql::db do failed: Cannot change column 'id': used in a
> foreign key constraint
> 'fk_test_case_components_component_id_components_id' of table
> 'prod_bugzilla.test_case_components' [for Statement "ALTER TABLE components CHANGE COLUMN
> id id mediumint auto_increment NOT NULL"] at Bugzilla/DB.pm line 754.

Reading something about "test", did you install Testopia? You need
that to be available for upgrades as well, otherwise Bugzilla itself
won't be able to handle applied schema changes by Testopia.

https://wiki.mozilla.org/Testopia

> The good news is that the current code in the git repository already
> works with Bugzilla 5.0, and so if you upgraded to 5.0 already, and
> if you don't mind having a work-in-progress extension on your
> machine, you can decide to pull the code from the git repository.
> This would also let us get some early feedback in case you find
> regressions.

https://developer.mozilla.org/en-US/docs/Mozilla/Bugzilla/Testopia

Mit freundlichen Grüßen

Thorsten Schöning

--
Thorsten Schöning
AM-SoFT IT-Service - Bitstore Hameln GmbH i.G. ist ein Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK

E-Mail: Thorsten....@AM-SoFT.de
Web: http://www.AM-SoFT.de/

Telefon: 05151- 9468- 0
Telefon: 05151- 9468-55
Fax: 05151- 9468-88
Mobil: 0178-8 9468-04

AM-SoFT IT-Service - Bitstore Hameln GmbH i.G., Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB neu - Geschäftsführer: Janine Galonska


Für Rückfragen stehe ich Ihnen sehr gerne zur Verfügung.

Mit freundlichen Grüßen

Thorsten Schöning


Tel: 05151 9468 0
Fax: 05151 9468 88
Mobil:
Webseite: https://www.am-soft.de

AM-Soft IT-Service - Bitstore Hameln GmbH i.G. ist ein Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK

AM-Soft IT-Service - Bitstore Hameln GmbH i.G.
Brandenburger Str. 7c
31789 Hameln
Tel: 05151 9468 0

Bitstore IT-Consulting GmbH
Zentrale - Berlin Lichtenberg
Frankfurter Allee 285
10317 Berlin
Tel: 030 453 087 80

CBS IT-Service - Bitstore Kaulsdorf UG
Tel: 030 453 087 880 1

Büro Dallgow-Döberitz
Tel: 03322 507 020

Büro Kloster Lehnin
Tel: 033207 566 530

PCE IT-Service - Bitstore Darmstadt UG
Darmstadt
Tel: 06151 392 973 0

Büro Neuruppin
Tel: 033932 606 090

ACI EDV Systemhaus Dresden GmbH
Dresden
Tel: 0351 254 410

Das Systemhaus - Bitstore Magdeburg GmbH
Magdeburg
Tel: 0391 636 651 0

Allerdata.IT - Bitstore Wittenberg GmbH
Wittenberg
Tel: 03491 876 735 7

Büro Liebenwalde
Tel: 033054 810 00

HSA - das Büro - Bitstore Altenburg UG
Altenburg
Tel: 0344 784 390 97

Bitstore IT – Consulting GmbH
NL Piesteritz
Piesteritz
Tel: 03491 644 868 6

Solltec IT-Services - Bitstore Braunschweig UG
Braunschweig
Tel: 0531 206 068 0

MF Computer Service - Bitstore Gütersloh GmbH
Gütersloh
Tel: 05245 920 809 3

Firmensitz: MF Computer Service - Bitstore Gütersloh GmbH, Gildestraße 25, 33442 Herzebrock-Clarholz
Geschäftsführer Janine Galonska

[Pierre Hernandez]

Hi Thorsten,

Problem solved since i do not use testopia. Thanks for your help on this

BR,

Pierre