[rt-users] Try to migrating from MySQL to Postgres

[Juanjo]

Hi.

I try to make a migration in my dev server from MySQL to Postgres.

Now im trying to use the scrip from Dario given in this thread
http://www.gossamer-threads.com/lists/rt/users/103305

I get this error:

[root@rt ~]# ./RTmysqltoPg
Migrating ACL...
maxid=83
Asked ACL for 2000 starting from 0, got 73
DBD::Pg::st execute failed: ERROR:  duplicate key violates unique
«acl_pkey» at ./RTmysqltoPg line 130.
Use of uninitialized value $values[6] in join or string at ./RTmysqltoPg
line 130.
Use of uninitialized value $values[8] in join or string at ./RTmysqltoPg
line 130.

 2,0,SuperUser,1,0,Group,,1,,RT::System at ./RTmysqltoPg line 130.



in the ACL table there aren´t duplicates key for ID.
The new database is empty, only generated by # make initialize-database

Any help?

I attach the script.

Thanks.
Kindest Regards.

-- 
Un saludo.
Juanjo Corral

RTmysqltoPg
Description: Binary data