[Koha-bugs] [Bug 17260] updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN columns

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17260

--- Comment #1 from Blou <philippe.blouin at inlibro.com> ---
Created attachment 55263
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=55263&action=edit
Bug 17260 - updatedatabase.pl fails on invalid entries in ENUM and BOOLEAN
columns

The loading of file admin/searchengine/elasticsearch/mappings.yaml specifies
'type' as empty, which fails with Mysql 5.7+ which is more stringent.

Also, forcing an empty value into a boolean also fails.

Both issues arise when updatedatabase.pl hit 3.23.00.050.

NOTE: both issues could also be resolved by actually setting values in the load
file.
      This doesn't make this solution incorrect, though.

To Test/reproduce:
   -1) Happens with Mysql 5.7.4.  Maybe earlier, but certainly at that point.
   0) Find a database on 3.22 or earlier, save it.
   1) Set your code base to master)
   2) run updatedatabase.pl
   3) See the errors on 3.23.00.050
   4) Apply the patch
   5) Reload the 3.22 db.
   6) succeed with updatedatabase.pl

-- 
You are receiving this mail because:
You are watching all bug changes.