https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276 tony-the-hawk <antonio.falco@unito.it> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |antonio.falco@unito.it --- Comment #32 from tony-the-hawk <antonio.falco@unito.it> --- (In reply to beardst from comment #19)
I upgraded from 22.05 and came across this issue as well. Actually had 3 issues in the DB that I had to work through independently. For this one here is what worked, had to track down the FK that was blocking the drop of the illrequests_bibfk key
ALTER TABLE illrequests DROP FOREIGN KEY illrequests_ibfk_1; ALTER TABLE illrequests DROP KEY illrequests_bibfk;
After that I was able to retry the webinstall and it went through. Ran this command to see if the FK constraint was recreated. This is also the command I used to find the FK in the first place
SELECT RefCons.constraint_schema, RefCons.table_name, RefCons.referenced_table_name, RefCons.constraint_name, KeyCol.column_name FROM information_schema.referential_constraints RefCons JOIN information_schema.key_column_usage KeyCol ON RefCons.constraint_schema = KeyCol.table_schema AND RefCons.table_name = KeyCol.table_name AND RefCons.constraint_name = KeyCol.constraint_name WHERE RefCons.constraint_schema = 'DATABASE_NAME';
After the two commands ALTER TABLE... I retried the web install and I had the following Update report : Upgrade to 23.05.00.002 [16:30:40]: Bug 21983 - Deleted biblio handling on ILL Added foreign key constraint 'illrequests.illrequests_bibfk' Upgrade to 23.05.00.003 [16:30:40]: Bug 32478 - Remove usage of Koha::Config::SysPref->find since bypasses cache Replace 'NULL' with 'null' in ItemsDeniedRenewal system preference Clear system preference cache Upgrade to 23.05.01.000 [16:30:40]: Koha 23.05.01 release Upgrade to 23.05.01.001 [16:30:40]: Bug 33961 - Remove Offline circulation tool Removed system preference 'AllowOfflineCirculation' Upgrade to 23.05.01.002 [16:30:40]: Bug 33117 - Patron checkout is not able to find patrons if using a second surname or other name during the search Added new system preference 'DefaultPatronSearchMethod' Update errors : Upgrade to 23.05.01.003 [16:30:41]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741 Updated biblioitems.place to text ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741 Updated deletedbiblioitems.place to text ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741 -- You are receiving this mail because: You are watching all bug changes.