[Bug 16835] New: Upgrade database failed from 3.2200000 to new version
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16835 Bug ID: 16835 Summary: Upgrade database failed from 3.2200000 to new version Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: lenhatanh86@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Update errors : [Thu Jun 30 16:12:57 2016] updatedatabase.pl: DBD::mysql::st execute failed: Data truncated for column 'type' at row 1 [for Statement "INSERT INTO `search_field` ( `label`, `name`, `type`) VALUES ( ?, ?, ? )" with ParamValues: 0='Match', 1='Match', 2=''] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. [Thu Jun 30 16:12:57 2016] updatedatabase.pl: DBIx::Class::Storage::DBI::_dbh_execute(): Data truncated for column 'type' at row 1 at /usr/share/koha/lib/Koha/Objects.pm line 101 When I checked code on git, this error maybe related with file /admin/searchengine/elasticsearch/mappings.yaml and file installer/data/mysql/updatedatabase.pl (from line 12263) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16835 Bob Ewart <bob-ewart@bobsown.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bob-ewart@bobsown.com --- Comment #1 from Bob Ewart <bob-ewart@bobsown.com> --- 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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16835 --- Comment #2 from Bob Ewart <bob-ewart@bobsown.com> --- 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16835 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- This should have been resolved by bug 20229 making sure that Koha doesn't use STRICT_TRANS_TABLES. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org