[Koha] Koha 22.05 update error

[Marcel de Rooy]

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 at lists.katipo.co.nz> namens David L. Whelchel <dlwhelchel at outlook.com>
Verzonden: woensdag 8 juni 2022 20:30
Aan: koha at lists.katipo.co.nz <koha at 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 at pullman.com

_______________________________________________

Koha mailing list  https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2F&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Cb1689d114b524426573008da497d16f0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637903098997056033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=B9NzroMz6YNuotnlzg80gXGj6ghsRO9kT3P8OdJkNs8%3D&reserved=0
Koha at lists.katipo.co.nz
Unsubscribe: https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7Cb1689d114b524426573008da497d16f0%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637903098997056033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=GbZHmVOeQFtNfMCfFl73MzLXRSutZ%2B8didMeCqpo%2F4A%3D&reserved=0