1364666 - Bugzilla upgrade issue from 4.4.12 to 5.0.3 due to Testopia

Status: RESOLVED DUPLICATE of bug 923865

(Testopia :: General, defect)

Description

[vijay prakash]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36

Steps to reproduce:

We are up gradationing Bugzilla from 4.4.12 to 5.0.3




Actual results:

Getting following error. while running ./checksetup.pl

DBD::mysql::db do failed: Can't create table 'bugzilladb.#sql-439b_d' (errno: 150) [for Statement "ALTER TABLE test_case_components ADD
     CONSTRAINT fk_test_case_components_component_id_components_id FOREIGN KEY (component_id)
     REFERENCES components(id)
      ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 667
        Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x7c41d28)', 'test_case_components', 'HASH(0x7466928)', 'HASH(0xaf32dd0)') called at Bugzilla/DB.pm line 571
        Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x7c41d28)') called at Bugzilla/Install/DB.pm line 748
        Bugzilla::Install::DB::update_table_definitions('HASH(0x28cb738)') called at ./checksetup.pl line 172

Comment 1

[Teemu Mannermaa (:wicked)]

That FK is not part of Bugzilla but rather Testopia addon. You need to be on latest Testopia to run it on Bugzilla 5 so make sure to update Testopia as well. And specifically Testopia 2.5 has a bug where it fails with an error like this.