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
--
Fridolin SOMERS <fridolin.som...@biblibre.com>
Software and system maintainer 🦄
BibLibre, France
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
