[Koha] Koha 22.05 update error

David L. Whelchel dlwhelchel at outlook.com
Thu Jun 9 06:30:20 NZST 2022


Hello,

I am trying to update from the latest 21.12 version of Koha to 22.05 using the package manager and receive the following error in the following environment. No local modifications have been made to the SQL database :

Debian Version 9.13
mariadb  Ver 15.1 Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64) Upgrade to Koha 22.05

---

(Web Installer steps in the staff client)

Web installer > Update database
We are upgrading from Koha 21.12.00.040 to 22.05.00.000

Updating database structure
Update errors :
    Upgrade to 21.12.00.041 [11:22:10]: Bug 30449 - Check borrower_attribute_types FK constraint
    ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT category_code_fk' at line 1 at /usr/share/koha/lib/C4/Installer.pm line 739
---

Any help would be appreciated.

--Dave
-------------------------------------------------------------------------------
David L. Whelchel
725 SE Derby Street
Pullman, WA 99163
whelchel at pullman.com



More information about the Koha mailing list