[Koha] error occurred while importing the database structure

[David Nind]

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 at 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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>