Closed Bug 1216450 Opened 10 years ago Closed 10 years ago

DBD::mysql::db do failed: Can't create table 'bugzilla.#sql-3484_7' (errno: 150)

Categories

(Bugzilla :: Installation & Upgrading, defect)

5.0.1
defect
Not set
normal

Tracking

()

RESOLVED INVALID

People

(Reporter: khiresh.kalita, Unassigned)

Details

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0 Build ID: 20150826023504 Steps to reproduce: I am upgrading bugzilla 4.2.2 version 5.0.1 version. I have followed the steps given https://www.bugzilla.org/docs/4.2/en/html/upgrade.html Actual results: While running ./checksetup.pl I have encountered following issue: Retried several times but no luck. Removing existing compiled templates... Precompiling templates...done. Fixing file permissions... Adding foreign key: test_case_components.component_id -> components.id... DBD::mysql::db do failed: Can't create table 'bugzilla.#sql-3484_7' (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 642 Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x6687520)', 'test_case_components', 'HASH(0x5eb8428)', 'HASH(0x9944460)') called at Bugzilla/DB.pm line 546 Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x6687520)') called at Bugzilla/Install/DB.pm line 745 Bugzilla::Install::DB::update_table_definitions('HASH(0x1fae058)') called at ./checksetup.pl line 172 Expected results: Expecting successful bugzilla upgrade.
For future reference I'd recommend http://bugzilla.readthedocs.org/en/5.0/installing/upgrading.html > test_case_components That sounds like Testopia. See bug 923865. Closing as INVALID as there is no problem created by the Bugzilla codebase in this task.
Status: UNCONFIRMED → RESOLVED
Closed: 10 years ago
Resolution: --- → INVALID
You need to log in before you can comment on or make changes to this bug.