Hi

At my own risk I have modified the version to 19.12.00.029 and then moved ahead... (of course table "opac_news" will have to be checked after the update)

Unfortunately then another error popped up:

Upgrade to 19.12.00.075 [15:28:32]: Bug 25086 - Set changed_fields column of borrower_modifications as nullable {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Can't create table `koha_bib`.`serial` (errno: 150 "Foreign key constraint is incorrectly formed") at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x5654e142fba8), "DBI Exception: DBD::mysql::db do failed: Can't create table `"...) called at /usr/share/perl5/DBIx/Class/Storage.pm line 113
        
DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x5654e693cdd8),
 "DBI Exception: DBD::mysql::db do failed: Can't create table `"...) called at 
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1623
DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Can't create table `koha_bib`.`seri"..., DBI::db=HASH(0x5654e71fe510), undef) called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 21746


I guess in this case I cannot just modify the version and move ahead. I assume there will be more errors like this since the process hasn't even reached Koha 20.05. To me it seems like this database is corrupt and I cannot proceed to Koha 24.05.

Now my question ist - how can I check the integrity of the Koha 19.11 database so the update process to reach Koha 24.05 will work as expected?

Best wisshes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch




Am 10.07.24 um 15:20 schrieb Michael Kuhn via Koha-devel:
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/

Reply via email to