Testopia does not show up in Bugzilla 5.0 after install...

[Richard Aronson]

Howdy...

I have Bugzilla 5.0 up and running with Ubuntu 14.04.

When I follow the instructions to install Testopia 2.5 I receive the following error after running checksetup.pl

=================================================================
..
Reading ./localconfig...
Checking for DBD-mysql (v4.001) ok: found v4.025
Checking for MySQL (v5.0.15) ok: found v5.5.44-0ubuntu0.14.04.1

Removing existing compiled templates...
Precompiling templates...done.
Fixing file permissions...

Checking Testopia setup ...
Populating test plan ACLs ...
Done checking Testopia setup.

Adding foreign key: test_case_components.component_id ->
components.id...
Adding foreign key: test_case_components.case_id ->
test_cases.case_id...
DBD::mysql::db do failed: Can't create table 'bugs.#sql-4e9_29' (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, ADD
CONSTRAINT fk_test_case_components_case_id_test_cases_case_id FOREIGN KEY (case_id)
REFERENCES test_cases(case_id)
ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 642.
Bugzilla::DB::bz_add_fks('Bugzilla::DB::Mysql=HASH(0x7a779a8)', 'test_case_components', 'HASH(0x6f9a5c8)', 'HASH(0xc97f9b8)') called at Bugzilla/DB.pm line 546
Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x7a779a8)') called at Bugzilla/Install/DB.pm line 745
Bugzilla::Install::DB::update_table_definitions('HASH(0x1dfeb18)') called at ./checksetup.pl line 172
root@Bugzilla-ubuntu:/var/www/html#
=========================================================================

what am I missing?

Cheers,
rich

[Richard Aronson]

Howdy again...

I just tried a workaround that seemed to help, but I want to make sure I am not breaking anything down the road.

Any help would be...helpful...

I commented out the line 172 in the checksetup.pl file.

#Bugzilla::Install::DB::update_table_definitions(\%old_params);

Testopia is now available in Bugzilla. I will begin my testing before going live this this.

Cheers,
rich

[souja...@gmail.com]

after commenting the line (told in the above comment)the Testopia was installed successfully, but its not available or shown in Bugzilla.


Please let me know where this option is available or what can be done to get this option