600948 - Installation problem: DBD::mysql::db do failed: Can't create table...

Status: RESOLVED WORKSFORME

(Testopia :: General, defect)

Description

[Thiago Cesar Vieira]

User-Agent:       Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.13) Gecko/2009080317 Ubuntu/8.04 (hardy) Firefox/3.0.13
Build Identifier: 

./checksetup.pl
...
Checking Testopia setup ...
Use of uninitialized value in string eq at ./extensions/Testopia/Extension.pm line 1274.
Populating test plan ACLs ...
Done checking Testopia setup.

Adding foreign key: test_case_runs.environment_id ->
test_environments.environment_id...
DBD::mysql::db do failed: Can't create table './bugzilla/#sql-15f8_1a8bc0.frm' (errno: 121) [for Statement "ALTER TABLE test_case_runs ADD
     CONSTRAINT fk_d33f8a2a0b7988266c8ba80093087118 FOREIGN KEY (environment_id)
     REFERENCES test_environments(environment_id)
      ON UPDATE CASCADE ON DELETE CASCADE"] at Bugzilla/DB.pm line 515
        Bugzilla::DB::bz_add_fk('Bugzilla::DB::Mysql=HASH(0x3869d10)', 'test_case_runs', 'environment_id', 'HASH(0x3f6a7f0)') called at Bugzilla/DB.pm line 450
        Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x3869d10)') called at Bugzilla/Install/DB.pm line 613
        Bugzilla::Install::DB::update_table_definitions('HASH(0xb1b310)') called at ./checksetup.pl line 198


# echo $?
255

Reproducible: Always

Steps to Reproduce:
1. Go to Bugzilla root directory
2. Untar Testopia tarball
3. patch -p0 -i extensions/Testopia/patch-3.6
4. ./checksetup.pl
Actual Results:  
Loading Bugzilla page on web-browser, no link about Testopia is displayed.
It seems that Testopia was not correctly installed.

Expected Results:  
Testopia should be installed correctly.

Bugzilla: 3.6 (not 3.6.1 nor 3.6.2)
Testtopia: 2.4

Comment 1

[Thiago Cesar Vieira]

Attachment: Running ./checksetup.pl -> installation problems

It is not possible to install Testopia 2.4 because error "DBD::mysql::db do failed: Can't create table...".

Comment 2

[Frédéric Buclin]

I cannot reproduce. Try again with Testopia 2.5.

Comment 3

[Richard Aronson]

I too can reproduce this issue...

I am trying to install Testopia 2.5 on a fresh install of Bugzilla 5.0 on Ubuntu 14.04 server.

Error message below:
==============================================================
COMMANDS TO INSTALL OPTIONAL MODULES:

Apache-SizeLimit: /usr/bin/perl install-module.pl Apache2::SizeLimit


To attempt an automatic install of every required and optional module
with one command, do:

  /usr/bin/perl install-module.pl --all

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-16b6_2a' (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(0x76ffbe8)', 'test_case_components', 'HASH(0x6c1cec8)', 'HASH(0xc600b48)') called at Bugzilla/DB.pm line 546
	Bugzilla::DB::bz_setup_foreign_keys('Bugzilla::DB::Mysql=HASH(0x76ffbe8)') called at Bugzilla/Install/DB.pm line 745
	Bugzilla::Install::DB::update_table_definitions('HASH(0x1a80be8)') called at ./checksetup.pl line 172
root@Bugzilla-ubuntu:/var/www/html# 

=======================================================================================

Comment 4

[Andre Klapper]

(In reply to Richard Aronson from comment #3)
> I am trying to install Testopia 2.5 on a fresh install of Bugzilla 5.0

That is bug 923865 instead.