The problem is deeper, then.  issuingrule didn't have unique id, so the problem is not with the starting db.  It seems to be when creating the new entries, autoincrement doesn't seem to do its job ?

I don't think there's any integrity problem with your old database, more with the environment, the actual database server configuration.  But I'm just spitballing at this point...

Philippe Blouin Directeur de la technologie T  833-INLIBRO (465-4276), poste 230 C  philippe.blouin@inLibro.com www.inLibro.com

Hi Philippe

Many thanks! You wrote:

> Ok, let's cheat.  You have very few rules, and most of the info has
> been moved already.  So just comment the lines 20734 to 20746 and run
> updatedatabase.pl again.
>
> OR modify the version to move ahead.
>
> update systempreferences set value = '19.1200018' where variable =
> 'version';
>
> Then you can drop the issuingrules table later, when you're satisfied
> with everything.  Note that you'll need to update the rules manually
> in the staff interface to add back the issue length and renewal
> count/period...

I have modified the version and then moved ahead... unfortunately there is another duplicate entry in another table and the script aborted again:

Upgrade to 19.12.00.029  [15:13:32]: Bug 17702 - Add column account_credit_types.archived
{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'  at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
    DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x5598ef055ba8), "DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' "...) called at /usr/share/perl5/DBIx/Class/Storage.pm line 113
    DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x5598f4639198), "DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' "...) called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1623
    DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'", DBI::db=HASH(0x5598f4e19490), undef) called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 20966


How should I proceed?

Is there a way how I can check the original database for duplicate entries so the update process won't abort?

Best wishes: Michael