https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42301
Bug ID: 42301
Summary: updatedatabase fails on mysql when adding a unique key
to a text column (introduced by 35380)
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Installation and upgrade (command-line installer)
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
The column 'name' is altered to be unique in bug 38530
When using mariadb this works fine but when using mysql as db engine this error
is thrown;
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column
'name' used in key specification without a key length at
/kohadevbox/koha/C4/Installer.pm line 818
to recreate:
- run ktd with mysql f.e.: DB_IMAGE=mysql:8.0 ktd --proxy --name mysql8 up -d
- enter ktd shell ktd --name mysql8 --shell
- checkout a Koha version prior to 35380
- reset_all
- checkout main
- updatedatabase
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
