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)
Tracking
(Not tracked)
VERIFIED
FIXED
People
(Reporter: phil.subscription, Assigned: gregaryh)
Details
Attachments
(1 file)
92.37 KB,
text/plain
|
Details |
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).
Comment 1•18 years ago
|
||
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'],
],
},
Reporter | ||
Comment 2•18 years ago
|
||
Reporter | ||
Comment 3•18 years ago
|
||
It doesn't have the test_case_attachments definition. I've attached my schema.pm.
What should I do?
Comment 4•18 years ago
|
||
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
Reporter | ||
Comment 5•18 years ago
|
||
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 → ---
Reporter | ||
Comment 6•18 years ago
|
||
Dooohhh, I just noticed the patch in the testopia distribution. I'll try that.
Apologies.
Status: REOPENED → RESOLVED
Closed: 18 years ago → 18 years ago
Resolution: --- → FIXED
Reporter | ||
Comment 7•18 years ago
|
||
It worked, problem solved. Many thanks.
You need to log in
before you can comment on or make changes to this bug.
Description
•