Checksetup.pl / Building index error - Migrating from 2.19.2 to 2.22

Hi,

We are upgrading our MySQL server to 5.0 and our bugzilla 2.19.2 does 
not support such version of MySQL... so I'm trying to upgrade bugzilla 
to 2.22.

I've created a new virtual host to test the migration. Here is the test 
config: Linux Fedora Core 4 / MySQL 4.1 / Apache 2.0 / PHP 5.0 / Perl 5.8.6

Step by step:
- run sanitycheck on bugzilla 2.19.2
- dump bugzilla 2.19.2 database
- untar bugzilla-2.22.tar.gz to virtual host
- copy data/ and localconfig file from 2.19.2 to 2.22
- run checksetup.pl on 2.22
- install new required perl packages
- re-run checksetup.pl on 2.22

here is the error message:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[root@pinguinserver bugzilla-2.22]# ./checksetup.pl

Checking perl modules ...
Checking for       AppConfig (v1.52)   ok: found v1.56
Checking for             CGI (v2.93)   ok: found v3.10
Checking for    Data::Dumper (any)     ok: found v2.121_02
Checking for    Date::Format (v2.21)   ok: found v2.22
Checking for             DBI (v1.38)   ok: found v1.48
Checking for      File::Spec (v0.84)   ok: found v3.01
Checking for      File::Temp (any)     ok: found v0.14
Checking for        Template (v2.08)   ok: found v2.13
Checking for      Text::Wrap (v2001.0131) ok: found v2001.09292
Checking for    Mail::Mailer (v1.67)   ok: found v1.67
Checking for    MIME::Base64 (v3.01)   ok: found v3.05
Checking for    MIME::Parser (v5.406)  ok: found v5.420
Checking for        Storable (any)     ok: found v2.13

The following Perl modules are optional:
Checking for              GD (v1.20)   ok: found v2.16
Checking for     Chart::Base (v1.0)    ok: found v2.3
Checking for       XML::Twig (any)     ok: found v3.23
Checking for       GD::Graph (any)     ok: found v1.43
Checking for GD::Text::Align (any)     ok: found v1.18
Checking for     PatchReader (v0.9.4)  ok: found v0.9.5
Checking for   Image::Magick (any)      not found

If you want to convert BMP image attachments to PNG to conserve
disk space, you will need to install the ImageMagick application
Available from http://www.imagemagick.org, and the Image::Magick
Perl module by running (as root):

    /usr/bin/perl -MCPAN -e 'install "Image::Magick"'

Checking user setup ...
Removing existing compiled templates ...
Precompiling templates ...
Checking for      DBD::mysql (v2.9003) ok: found v2.9007
Checking for           MySQL (v4.0.14) ok: found v4.1.16-log
Checking for        GraphViz (any)     ok: found

Adding new index 'versions_product_id_idx' to the versions table ...
<h1>Software error:</h1>
<pre>DBD::mysql::db do failed: Duplicate entry '16-4.2' for key 1 at 
Bugzilla/DB.pm line 479
 
Bugzilla::DB::bz_add_index_raw('Bugzilla::DB::Mysql=HASH(0xc18778c)', 
'versions', 'versions_product_id_idx', 'HASH(0xc2ffacc)') called at 
Bugzilla/DB.pm line 452
 
Bugzilla::DB::bz_add_index('Bugzilla::DB::Mysql=HASH(0xc18778c)', 
'versions', 'versions_product_id_idx', 'HASH(0xc2ffacc)') called at 
../checksetup.pl line 4029
</pre>
<p>
For help, please send mail to this site's webmaster, giving this error 
message
and the time and date of the error.

</p>
[Fri Apr 28 10:35:44 2006] checksetup.pl: DBD::mysql::db do failed: 
Duplicate entry '16-4.2' for key 1 at Bugzilla/DB.pm line 479
[Fri Apr 28 10:35:44 2006] checksetup.pl: 
Bugzilla::DB::bz_add_index_raw('Bugzilla::DB::Mysql=HASH(0xc18778c)', 
'versions', 'versions_product_id_idx', 'HASH(0xc2ffacc)') called at 
Bugzilla/DB.pm line 452
[Fri Apr 28 10:35:44 2006] checksetup.pl: 
Bugzilla::DB::bz_add_index('Bugzilla::DB::Mysql=HASH(0xc18778c)', 
'versions', 'versions_product_id_idx', 'HASH(0xc2ffacc)') called at 
../checksetup.pl line 4029
[root@pinguinserver bugzilla-2.22]#

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Here is the code of checksetup.pl (from line 4029):

$dbh->bz_add_index('versions', 'versions_product_id_idx',
                    {TYPE => 'UNIQUE', FIELDS => [qw(product_id value)]});

I don't know what is the '16-4.2' value... It's not from the original 
versions table, and cannot be a product_id...

Any idea?

best regards,

Christophe

0
Christophe
4/28/2006 9:23:58 AM
netscape.mozilla.webtools 4144 articles. 0 followers. Follow

0 Replies
676 Views

Similar Articles

[PageSpeed] 25
Get it on Google Play
Get it on Apple App Store

Reply: