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...
Logo inLibro <https://inLibro.com> Philippe Blouin
Directeur de la technologie
T 833-INLIBRO (465-4276) <tel:833-465-4276>, poste 230
C philippe.blo...@inlibro.com
www.inLibro.com <https://inLibro.com>
On 2024-07-10 09:20, Michael Kuhn wrote:
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
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/