https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276
tony-the-hawk <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #32 from tony-the-hawk <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
