[Koha] DB Upgrade error saga

[Alvaro Cornejo]

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 at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>