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