[Koha-bugs] [Bug 16402] Web Installation fails - Step 3 Importing the Database Structure

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402

--- Comment #2 from Charles Gruener <cgruener at gruener.us> ---
I attempted to change the sql_mode as suggested and the error persists upon
trying to import the database structure.  The file
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql needs
to be updated to comply with the changes introduced in MySQL release 5.7.3.

See: http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-3.html

Specifically: Columns in a PRIMARY KEY must be NOT NULL, but if declared
explicitly as NULL produced no error. Now an error occurs. For example, a
statement such as CREATE TABLE t (i INT NULL PRIMARY KEY) is rejected. The same
occurs for similar ALTER TABLE statements. (Bug #13995622, Bug #66987, Bug
#15967545, Bug #16545198)

Since I don't know much about how the database needs to be structured to
properly function, I'll just call out the fields that MySQL is erroring out on
in kohastructure.sql rather than attempting to write my own patch.

On line 1385: CREATE TABLE 'letter' uses 'branchcode' as part of its
PRIMARY_KEY, but is "default NULL"

On line 2476: CREATE TABLE 'permissions' uses 'code' as part of its PRIMARY_KEY
but is "DEFAULT NULL"

If I change those two (branchcode and code) to be "NOT NULL", I am able to get
the installer to continue, but as I stated above, I don't know if this is the
correct fix as I don't know how this impacts the database structure for the
usability of koha.

-- 
You are receiving this mail because:
You are watching all bug changes.