https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23579 Cindy Murdock Ames <cmurdock@ccfls.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |cmurdock@ccfls.org --- Comment #1 from Cindy Murdock Ames <cmurdock@ccfls.org> --- Just chiming in to say this affected me too, and seemed to prevent the database creation from being completed. Fixed it by the same method, removing " DEFAULT ''" from line 3398 of kohastructure.sql. This was a fresh package install of 19.05.04 on Ubuntu Server Edition 18.04.3, with mysql-server 5.7.27-0ubuntu0.18.04.1. -- 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=23579 Ailton M. Duarte <adidas.coyas@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |adidas.coyas@gmail.com --- Comment #3 from Ailton M. Duarte <adidas.coyas@gmail.com> --- where i will find this kohastructure.sql -- 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=23579 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|critical |blocker CC| |jonathan.druart@bugs.koha-c | |ommunity.org Assignee|koha-bugs@lists.koha-commun |jonathan.druart@bugs.koha-c |ity.org |ommunity.org Version|19.05 |master Depends on| |23151 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23151 [Bug 23151] Patron self modification sends null dateofbirth -- 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=23579 --- Comment #4 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Created attachment 94716 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=94716&action=edit Bug 23579: Remove default value for MEDIUMTEXT borrower_modifications.changed_fields Installation under Ubuntu 18.04 is blocked: install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'changed_fields' can't have a default value at /usr/local/share/perl5/DBIx/RunSQL.pm line 273. https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html """ The BLOB, TEXT, GEOMETRY, and JSON data types cannot be assigned a default value. """ -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23579 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #94716|0 |1 is obsolete| | --- Comment #6 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Created attachment 94718 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=94718&action=edit Bug 23579: Remove default value for MEDIUMTEXT borrower_modifications.changed_fields Installation under Ubuntu 18.04 is blocked: install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'changed_fields' can't have a default value at /usr/local/share/perl5/DBIx/RunSQL.pm line 273. https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html """ The BLOB, TEXT, GEOMETRY, and JSON data types cannot be assigned a default value. """ Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23579 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA --- Comment #7 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Trival patch to stop a blocker.. going straight for QA on this one. Must admit, I've never understood why we have "DEFAULT ''" anyway.. surely if it's "NOT NULL" then an empty string is also a bad idea.. we are expecting real data in there and as such should throw db errors if were not putting proper valid data in. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23579 --- Comment #8 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Nice work! Pushed to master for 19.11.00 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23579 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |Pushed to stable Version(s)|19.11.00 |19.11.00,19.05.05 released in| | CC| |fridolin.somers@biblibre.co | |m --- Comment #10 from Fridolin SOMERS <fridolin.somers@biblibre.com> --- Pushed to 19.05.x for 19.05.05 -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23579 Agustín Moyano <agustinmoyano@theke.io> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |25086 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25086 [Bug 25086] OPAC Self Registration - Field 'changed_fields' doesn't have a default value -- You are receiving this mail because: You are watching all bug changes.