See bug 30899. The fix has been pushed to master and will be backported soon to 22.05/21.11. When you replace CONSTRAINT by FOREIGN KEY in the SQL statement, you could correct yourself. ________________________________ Van: Koha <koha-bounces@lists.katipo.co.nz> namens David L. Whelchel <dlwhelchel@outlook.com> Verzonden: woensdag 8 juni 2022 20:30 Aan: koha@lists.katipo.co.nz <koha@lists.katipo.co.nz> Onderwerp: [Koha] Koha 22.05 update error 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@pullman.com _______________________________________________ Koha mailing list https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-commun... Koha@lists.katipo.co.nz Unsubscribe: https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.kati...