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
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...
HI, Is there an ETA on the bug fix for this issue that was suggested in the thread to this email? When is it the next update scheduled for release? Thanks --Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel@pullman.com -----Original Message----- From: David L. Whelchel Sent: Wednesday, June 8, 2022 11:30 AM To: koha@lists.katipo.co.nz Subject: 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
7 days or so. El vie, 17 jun 2022 20:14, David L. Whelchel <dlwhelchel@outlook.com> escribió:
HI,
Is there an ETA on the bug fix for this issue that was suggested in the thread to this email? When is it the next update scheduled for release?
Thanks
--Dave
------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel@pullman.com
-----Original Message----- From: David L. Whelchel Sent: Wednesday, June 8, 2022 11:30 AM To: koha@lists.katipo.co.nz Subject: 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 http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
David L. Whelchel -
Marcel de Rooy -
Tomas Cohen Arazi