https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10459 --- Comment #54 from Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> --- (In reply to Marcel de Rooy from comment #52)

What about filling created_on once in AddMember ? Mysql accepts: `stamp1` timestamp NULL DEFAULT NULL, `stamp2` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Which MySQL version? For example this two columns in virtualshelves give problems on 5.7: `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified `created_on` TIMESTAMP NOT NULL, -- creation time loading kohastructure fails with line: 2212 `created_on` TIMESTAMP NOT NULL, -- creation time error: (Invalid default value for 'created_on'): CREATE TABLE `virtualshelves` It seems that we will find some problems because of the new version default sql_mode. It's something that we need to address. ATM neither 16.05 nor 3.22 run on Ubuntu 16.04. -- You are receiving this mail because: You are watching all bug changes.