Hi Keith For the 1st error, it seems debit_id was not created during upgrade so you can try to manually add the missing column 'debit_id' accessing directly to the db and then run schema-upgrade again. On koha 21.11 as per https://schema.koha-community.org/21_11/tables/article_requests.html 'debit_id' does not exist but on 22.05 it does ( https://schema.koha-community.org/22_05/tables/article_requests.html) As per the DB definition debit_id is a column INT 10 so you can do something like: ALTER TABLE article_requests ADD debit_id INT AFTER cancellation_reason For the 2nd error, I have no idea. As always, backup your database before trying this manual modification. Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le sam. 2 juil. 2022 à 13:50, Keith Sorbo <keith@thesorbos.com> a écrit :
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!) _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha