[rt-users] Problem upgrade from rt-2.0.9 to rt3-0.6

[Philippe Van Hecke]

On Monday 17 November 2003 12:13, Ruslan U. Zakirov wrote:
> Philippe Van Hecke wrote:
> > 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
> > HTML-Mason 1.20
> >
> > *  Apache-DBI
> >       Latest version installed: 0.91
> >
> > *  DBI
> >       Latest version installed: 1.37
> >
> > *  DBD-Pg
> >       Latest version installed: 1.22
> >
> > DBIx::SearchBuilder 0.92
> >
> > 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/ RT.pm:247)
> > 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/ RT.pm:247)
> >
> > 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.
>
> I think you should update PG autoincrement generators.
> I don't use Pg so I don't know how to do it, but search in archives
> there was same problem.
> 	Good luck. Ruslan.

Have try to search in the rt-user mailing list archive but find nothing
for pg related. But after looking more deeply into my postgres log
it seem that this not the only error i get when i import the old db
i have also many pg_atoi error followed by some email adresses.

like this 
ERROR:  pg_atoi: error in "xxxt at yyy.be": can't parse "xxxt at yyy.be"

and also many following

ERROR:  Invalid UNICODE character sequence found (0xe964e9)

So i thing that i will drop pg usage and try to use mysql.
my question is  does the dump from rt2+pg will be 
imported into rt3 with mysql ?

regards,

Philippe.
 
-- 
_____________________
Philippe Van Hecke
NETWORK ENGINEER
BELNET
Rue de la Science, 4 
B-1000 Brussels 
Belgium 
Tel: +32 (0) 27903333 
Fax: +32 (0) 27903335
______________________