Summary: | Utf8mb4 collation causes problems with missing tables when upgrading the database | ||
---|---|---|---|
Product: | Koha | Reporter: | Andreas Hedström Mace <andreas.hedstrom.mace> |
Component: | Architecture, internals, and plumbing | Assignee: | Bugs List <koha-bugs> |
Status: | CLOSED WONTFIX | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | afrane55, dcook, mengu, pasi.kallinen |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: |
Description
Andreas Hedström Mace
2019-08-21 21:06:02 UTC
This has been reported 4 years ago and I believe it might have been caused by a changed collation on the borrowers table. Should this be marked WONTFIX at this point? (In reply to Katrin Fischer from comment #1) > This has been reported 4 years ago and I believe it might have been caused > by a changed collation on the borrowers table. > Should this be marked WONTFIX at this point? I think this could be marked as WONTFIX. It sounds like an unfortunate migration issue, but I think "dave" and "davé" probably should be considered as equivalent for a unique index. When I try to make two patron records with those as the userid and cardnumber, I get the following warning: The following fields are wrong. Please fix them. Username already exists or could not create unique new one. Cardnumber already in use. So I think that sounds right to me. |