Bug 14952

Summary:	web installer database errors on 3.18.11
Product:	Koha	Reporter:	Bob Ewart <bob-ewart>
Component:	Installation and upgrade (web-based installer)	Assignee:	Bugs List <koha-bugs>
Status:	CLOSED FIXED	QA Contact:	Testopia <testopia>
Severity:	normal
Priority:	P5 - low	CC:	bob-ewart, gmcharlt, jonathan.druart, liz
Version:	3.18
Hardware:	PC
OS:	Linux
See Also:	http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637
Change sponsored?:	---	Patch complexity:	---
Documentation contact:		Documentation submission:
Text to go in the release notes:		Version(s) released in:
Circulation function:

Description Bob Ewart 2015-10-04 18:45:38 UTC

Installing Koha 3.18.11 built from the tar ball on openSuse 13.2.

Select all optional data in step 3.

optional data added
sample_patrons.sql
ERROR 1048 (23000) at line 1: Column 'address' cannot be null 

mandatory data added

authorities_normal_marc21.sql
ERROR 1366 (22007) at line 270: Incorrect integer value: '' for column 'linkid' at row 1 

The build used all the defaults except for 'icu' and the passwords.

Comment 1 Bob Ewart 2015-10-08 17:58:27 UTC

As Liz Rea reported on the mailing list, this problem is caused by the "STRICT_TRANS_TABLES" settings.

If you turn it off, all the data is created as it should be

Comment 2 Bob Ewart 2015-10-08 17:59:38 UTC

As Liz Rea reported on the mailing list, this problem is caused by the "STRICT_TRANS_TABLES" settings.

If you turn it off, all the data is created as it should be

Comment 3 Liz Rea 2015-11-12 21:53:43 UTC

I'll have a look into this thank you for your report.

CHeers,
Liz

Comment 4 Owen Leonard 2016-06-21 13:37:16 UTC

Is this bug valid for any version more recent than 3.18.x? If not please close it.

Comment 5 Jonathan Druart 2016-08-16 08:42:27 UTC

This bug is (will) certainly fixed by bug 16403, bug 16573 and/or bug 16554.