https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402
--- Comment #2 from Charles Gruener <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
