Bug 26612: Error during web install for it-IT translation
authorJohn Fawcett <john@voipsupport.it>
Mon, 12 Oct 2020 11:06:40 +0000 (13:06 +0200)
committerLucas Gass <lucas@bywatersolutions.com>
Fri, 13 Nov 2020 18:50:55 +0000 (18:50 +0000)
commit3973ef10b6b68eb4550dacf2c5a99475040dfdd1
tree61877e95b8d519a16a873b2d60dc030a838f57bb
parent86f801f350520910f78b78bfdaaa2783d7364929
Bug 26612: Error during web install for it-IT translation

Patch changes some of the values in the sql statement that inserts 307a
unimarc row into the marc_subfield_structure which created an SQL error
on installation.

The fields changed are:
- isurl now 0 instead of NULL,
- hidden now -5 instead of NULL,
- seealso empty string instead of NULL,
- link empty string instead of NULL.

These field values are now similar to the ones inserted for 306a or 308a.
The value that caused the SQL error was using NULL for hidden (due to
the NOT NULL constraint in the table definition).

I have tested the install with this change and found no issues.

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 7c74c6636f779bbbaceee74f8704df9ec625815d)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql