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
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
