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

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

rbadiverx
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
_______________________________________________
support-webtools mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-webtools
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

rbadiverx
On Thursday, August 27, 2015 at 4:31:53 PM UTC-7, Richard Aronson wrote:

> 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

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
_______________________________________________
support-webtools mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-webtools
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

soujanya323
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
_______________________________________________
support-webtools mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-webtools
Loading...