[Opendnssec-user] mysql migrate duplicate entry

[Yuri Schaeffer]

Hi Emil,

If you can please test:
https://raw.githubusercontent.com/yschaeff/opendnssec/test/migrate_fix/enforcer/utils/1.4-2.0_db_convert/mysql_convert.sql

//Yuri


On 01-03-17 16:33, Yuri Schaeffer wrote:
> Hi Emil
> 
>> ERROR 1062 (23000) at line 474: Duplicate entry '81' for key 'PRIMARY'
> 
> As Berry said, it has to to with the shared keys option. The fix is
> pretty straight forward. I think a DISTINCT keyword in the right place
> solves the issue. However with your database in hand I came across
> multiple issues with the script.
> 
> So I'll work on those and evaluate the fix. I expect to have it finished
> tomorrow.
> 
> Regards,
> Yuri
> 
> 
> 
> _______________________________________________
> Opendnssec-user mailing list
> Opendnssec-user at lists.opendnssec.org
> https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20170301/f592a7a0/attachment.bin>