Summary: | Upgrade database failed from 3.2200000 to new version | ||
---|---|---|---|
Product: | Koha | Reporter: | lenhatanh86 |
Component: | Installation and upgrade (web-based installer) | Assignee: | Bugs List <koha-bugs> |
Status: | RESOLVED FIXED | QA Contact: | Testopia <testopia> |
Severity: | enhancement | ||
Priority: | P5 - low | CC: | bob-ewart, gmcharlt |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
Description
lenhatanh86
2016-06-30 09:28:17 UTC
This is a show stopper for me. I'm upgrading from 3.22.11 to 16.05.04 compiled from source on openSUSE. The original upgrade made a lot of changes and ended with this error. The link at the bottom to log in brought me back to the web installer and gave me this error in step 3. I would go into mysql and increase the size of the 'type' field if I could figure out what table it is referring to. The error message is not very helpful.f The problem is caused by STRICT_TRANS_TABLES. Delete it from my.cnf and restart mysql search_field.type is an enum and '' is not one of the listed values which causes STRICT_TRANS_TABLES to throw an error. I still think 'data truncated' is not very descriptive of the error, but that's mysql (or mariadb's) problem. |