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 <[email protected]> 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 > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
