I have a problem to migrate my rt-2.0.9 installation to rt3-0.6
after importing the rt2 db to rt3 db with rt2-to-rt3-v1.20 i am
unable to create new ticket or udpate existing ticket in rt3.
befor the update rt3 work well.
I use a gentoo system with postgres postgresql-7.3.4
Server Version: Apache/1.3.28 (Unix) (Gentoo/Linux) mod_perl/1.27
Latest version installed: 0.91
Latest version installed: 1.37
Latest version installed: 1.22
looking in the log when i try to create the ticket i obtain this.
Nov 17 11:32:34 philippe-2 RT: DBD::Pg::st execute failed: ERROR: Cannot
insert a duplicate key into unique index tickets_pkey at /usr/lib/perl5/
site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410. (/usr/local/rt3//lib/
Nov 17 11:32:34 philippe-2 RT: RT::Handle=HASH(0x8befe80) couldn’t execute the
query ‘INSERT INTO Tickets (Owner, Started, Type, InitialPriority,
LastUpdatedBy, Resolved, Starts, Subject, Status, Created, FinalPriority,
Priority, Queue, Due, LastUpdated, Creator) VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/lib/perl5/
site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417. (/usr/local/rt3//lib/
As rt3 working correctly befor update of db from rt2 i suspect the conversion
tools but have no idea where to investigate to try to resolve my problem.
Any help will be welcom.
Philippe Van Hecke
Rue de la Science, 4
Tel: +32 (0) 27903333
Fax: +32 (0) 27903335