Hi Daniel, I think this got lost when we had a bit of trouble with the mailing list. Were you able to resolve your issue? While we are working on the fix, the workaround suggested on the bug might help you to finish the update: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34516#c2 Katrin On 14.08.23 23:44, Daniel Owens wrote:
I opened a bug report, but I imagine it will take awhile before this is fixed. Is there any documentation about how to downgrade on Linux (Ubuntu)? I do have a backup.
Daniel
On 8/10/23 4:09 PM, Fridolin SOMERS wrote:
On 22.11.x index on publishercode seems OK : KEY `publishercode` (`publishercode`(191)),
The size on index has been added by : Bug 18336: Convert schema from utf8 to utf8mb4
I've look at old databases, the index is OK.
Please open a bug report.
Best regards
Le 10/08/2023 à 04:43, Daniel Owens a écrit :
This worked the last time I had the problem, but with the latest upgrade I got the web installer again. After running:
$ sudo service memcached restart $ sudo koha-upgrade-schema hbc
Upgrading database schema for hbc Upgrade to 22.11.07.003 [14:01:47]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors Updated biblioitems.place to text 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
Can anyone give me a pointer about where to go from here?
Daniel
On 7/11/23 10:18 AM, Bruns, Anke wrote:
Hi,
in our case, when this occurs, the solution is usually to restart the memcached and then perform koha-upgrade-schema <instance>.
Hope this helps.
Best regards, Anke
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha