[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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120626/7ff3a482/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: RTmysqltoPg
Type: application/octet-stream
Size: 5111 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120626/7ff3a482/attachment.obj>