I have inherited a RedHat PgZilla 2.15 installation that I would love
to migrate onto a current BugZilla. I have tried the rather hopefull
direct upgrade, with simply installing 2.22 and running checksetup.pl
on a copy of the database, but this breaks with the errror:
-- start --
Checking for DBD::Pg (v1.31) ok: found v1.49
Checking for PostgreSQL (v7.03.0000) ok: found v08.00.0800
Adding new table attachments ...
[Thu Sep 21 10:20:58 2006] checksetup.pl: NOTICE: CREATE TABLE will
create implicit sequence "attachments_attach_id_seq1" for serial column
"attachments.attach_id"
Software error:
DBD::Pg::db do failed: ERROR: relation "attachments"
already exists
at Bugzilla/DB.pm line 513
Bugzilla:
B::_bz_add_table_raw('Bugzilla:
B::Pg=HASH(0x9e95fd4)',
'attachments') called at Bugzilla/DB.pm line 488
Bugzilla:
B::bz_add_table('Bugzilla:
B::Pg=HASH(0x9e95fd4)',
'attachments') called at Bugzilla/DB.pm line 335
Bugzilla:
B::bz_setup_database('Bugzilla:
B::Pg=HASH(0x9e95fd4)')
called at Bugzilla/DB/Pg.pm line 220
Bugzilla:
B::Pg::bz_setup_database('Bugzilla:
B::Pg=HASH(0x9e95fd4)')
called at ./checksetup.pl line 1601
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.
[Thu Sep 21 10:20:58 2006] checksetup.pl: DBD::Pg::db do failed: ERROR:
relation "attachments" already exists
[Thu Sep 21 10:20:58 2006] checksetup.pl: at Bugzilla/DB.pm line 513
[Thu Sep 21 10:20:58 2006] checksetup.pl:
Bugzilla:
B::_bz_add_table_raw('Bugzilla:
B::Pg=HASH(0x9e95fd4)',
'attachments') called at Bugzilla/DB.pm line 488
[Thu Sep 21 10:20:58 2006] checksetup.pl:
Bugzilla:
B::bz_add_table('Bugzilla:
B::Pg=HASH(0x9e95fd4)',
'attachments') called at Bugzilla/DB.pm line 335
[Thu Sep 21 10:20:58 2006] checksetup.pl:
Bugzilla:
B::bz_setup_database('Bugzilla:
B::Pg=HASH(0x9e95fd4)')
called at Bugzilla/DB/Pg.pm line 220
[Thu Sep 21 10:20:58 2006] checksetup.pl:
Bugzilla:
B::Pg::bz_setup_database('Bugzilla:
B::Pg=HASH(0x9e95fd4)')
called at ./checksetup.pl line 1601
-- end --
I have also tried what I believe to be the first PostgreSQL compatible
BugZilla, 2.20, and recieve the same error. Trying to use BugZilla
results in SQL errors about columns not existing.
My guess is that the datastructure of PgZilla isn't what BugZilla
expects. Does a mapping or fixup script exist? Any advice would be most
welcome!
Thanks,
Alastair