Closed Bug 378503 Opened 18 years ago Closed 18 years ago

test_case_attachments missing on upgrade from testopia 1.1.1 to testopia 1.2

Categories

(Testopia :: General, defect)

x86
Linux
defect
Not set
major

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: phil.subscription, Assigned: gregaryh)

Details

Attachments

(1 file)

User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11 Build Identifier: testopia 1.2 I'm trying to upgrade from testopia 1.1.1/bugzilla 2.22.1 to testopia 1.2. tr_install.pl fails with the message .... Dropping table test_plan_group_map... Adding new index 'test_case_attachments_primary_idx' to the test_case_attachments table ... DBD::mysql::db do failed: Table 'bugs.test_case_attachments' doesn't exist at Bugzilla/DB.pm line 479 Bugzilla::DB::bz_add_index_raw('Bugzilla::DB::Mysql=HASH(0x886f058)', 'test_case_attachments', 'test_case_attachments_primary_idx', 'ARRAY(0x898820c)') called at Bugzilla/DB.pm line 452 Bugzilla::DB::bz_add_index('Bugzilla::DB::Mysql=HASH(0x886f058)', 'test_case_attachments', 'test_case_attachments_primary_idx', 'ARRAY(0x898820c)') called at tr_install.pl line 437 main::UpdateDB('Bugzilla::DB::Mysql=HASH(0x886f058)') called at tr_install.pl line 78 As reported above, there is no test_case_attachments table, although there is a test_attachments table and a number of other test_case_*** tables. The output of tr_install.pl doesn't mention creating or removing a test_case_attachments table. Reproducible: Always Steps to Reproduce: 1. cd /var/www/bugzilla 2. tar zxf testopia-1.2.tar.gz 3. sudo perl tr_install.pl Problem happened running Ubuntu 6.10 LTS inside a virtual PC, running on Windows XP Pro. testopia was running OK before the attempted upgrade (with a few minor problems).
Does your Bugzilla/DB/Schema.pm contain this? test_case_attachments => { FIELDS => [ attachment_id => {TYPE => 'INT4', NOTNULL => 1}, case_id => {TYPE => 'INT4', NOTNULL => 1, UNSIGNED => 1}, case_run_id => {TYPE => 'INT4', UNSIGNED => 1}, ], INDEXES => [ test_case_attachments_primary_idx => ['attachment_id'], attachment_case_id_idx => ['case_id'], attachment_caserun_id_idx => ['case_run_id'], ], },
Attached file My schema file
It doesn't have the test_case_attachments definition. I've attached my schema.pm. What should I do?
Revert your bugzilla files (below) back to 2.22.1 and then re-apply testopia/patch-2.22.1 File list: Bugzilla/DB/Schema/Mysql.pm Bugzilla/DB/Schema/Pg.pm Bugzilla/DB/Schema.pm Bugzilla.pm Bugzilla/Template.pm Bugzilla/User.pm checksetup.pl editusers.cgi enter_bug.cgi post_bug.cgi
Status: NEW → RESOLVED
Closed: 18 years ago
Resolution: --- → FIXED
I used the patch(2) on bug 360737 but still got the same result. i.e. test_case_attachments doesn't exist at Bugzilla/DB.pm line 479. Is this the patch that you meant me to use?
Status: RESOLVED → REOPENED
Resolution: FIXED → ---
Dooohhh, I just noticed the patch in the testopia distribution. I'll try that. Apologies.
Status: REOPENED → RESOLVED
Closed: 18 years ago18 years ago
Resolution: --- → FIXED
It worked, problem solved. Many thanks.
You're welcome -- I'm glad it's working now.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: