Hi Davide. This is an error that has just been fixed and should come out in the next monthly maintenance release for 19.05 and the new 19.11 release later this month: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23579 To manually fix it I think you have to edit installer/data/mysql/kohastructure.sql and change line around 3399-3405: from: `changed_fields` MEDIUMTEXT NOT NULL DEFAULT '', to: `changed_fields` MEDIUMTEXT NOT NULL, Hopefully someone else can let us know if this is wrong! It is also useful for us to know what operating system and version you have installed Koha on (generally supported Debian versions (8 or 9 - I think there are still some issues with 10) and the current or current-1 Ubuntu LTS versions (I think there are still some issues with the latest LTS version)), the database and version (MySQL or MariaDB), the version of Koha (such as 19.05.04), and whether you installed using the packages (the recommended way). Sometimes issues can be because of a specific version or combination. Hope this helps a little! David Nind | david.nind@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 m. +64 21 0537 847 On Fri, 22 Nov 2019 at 08:19, Davide Spanu <terraemondo@tiscali.it> wrote:
Good evening to all. I have tried several times to install Koha on a new server and I continue to receive database error(s). I follow the procedure step by step but I just can't understand where I'm wrong. The error I get with the webinstaller is this (then, consequently, many others).
The following error occurred while importing the database structure: [Thu Nov 21 18:26:44 2019] install.pl: DBD::mysql::st execute failed: BLOB, TEXT, GEOMETRY or JSON column 'changed_fields' can't have a default value at /usr/share/perl5/DBIx/RunSQL.pm line 273. Please contact your system administrator
Something is wrong with Mysql, but I don't understand what. I thank all of you in advance. Davide
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha