[Koha] DB Upgrade error saga

Keith Sorbo keith at thesorbos.com
Sun Jul 3 06:50:00 NZST 2022


I am still struggling to get my koha library database to upgrade properly.

My saga:
1. I attempted an update which timed out and errored.
2. I restored from a mysql database prior to my update attempt
3. I ran the koha-upgrade-schema library update. It ran through quite few
upgrades but errored with the following:

Upgrading database schema for sati
Upgrade to 21.12.00.057  [18:44:54]: Bug 30852 - Add index to
article_requests.debit_id
ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Key column
'debit_id' doesn't exist in table at /usr/share/koha/lib/C4/Installer.pm
line 739

DEV atomic update
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/
bug_30899.pl  [18:44:54]: Bug 30899 - Check borrower_attribute_types FK
constraint (30449 follow-up)

What do I need to do to get my koha library back up and functional? (We
have been offline for over 2 weeks because of the database upgrade
problems!)


More information about the Koha mailing list