[Koha-bugs] [Bug 34276] upgrading 23.05 to 23.05.002

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276

tony-the-hawk <antonio.falco at unito.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |antonio.falco at unito.it

--- Comment #32 from tony-the-hawk <antonio.falco at 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.