[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