mysql 5.7

[john.v...@effnet.com]

I've recently upgraded to mysql 5.7 and when upgrading to the gerrit 2.13 I got the following error:

Upgrading schema to 116 ...

Upgrading schema to 117 ...

Upgrading schema to 118 ...

Upgrading schema to 119 ...

Upgrading schema to 120 ...

Upgrading schema to 121 ...

Upgrading schema to 122 ...

Upgrading schema to 123 ...

Upgrading schema to 124 ...

Upgrading schema to 125 ...

Upgrading schema to 126 ...

Upgrading schema to 128 ...

Upgrading schema to 129 ...

Exception in thread "main" com.google.gwtorm.server.OrmException: Cannot apply SQL

ALTER TABLE changes ADD note_db_state TEXT

at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:44)

at com.google.gwtorm.schema.sql.SqlDialect.addColumn(SqlDialect.java:357)

at com.google.gwtorm.jdbc.JdbcSchema.addColumns(JdbcSchema.java:131)

at com.google.gwtorm.jdbc.JdbcSchema.updateSchema(JdbcSchema.java:92)

at com.google.gerrit.server.schema.SchemaVersion.updateSchema(SchemaVersion.java:122)

at com.google.gerrit.server.schema.SchemaVersion.upgradeFrom(SchemaVersion.java:80)

at com.google.gerrit.server.schema.SchemaVersion.check(SchemaVersion.java:72)

at com.google.gerrit.server.schema.SchemaUpdater.update(SchemaUpdater.java:109)

at com.google.gerrit.pgm.init.BaseInit$SiteRun.upgradeSchema(BaseInit.java:361)

at com.google.gerrit.pgm.init.BaseInit.run(BaseInit.java:129)

at com.google.gerrit.pgm.util.AbstractProgram.main(AbstractProgram.java:64)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.google.gerrit.launcher.GerritLauncher.invokeProgram(GerritLauncher.java:161)

at com.google.gerrit.launcher.GerritLauncher.mainImpl(GerritLauncher.java:102)

at com.google.gerrit.launcher.GerritLauncher.main(GerritLauncher.java:59)

at Main.main(Main.java:25)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'last_updated_on'

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:888)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:730)

at com.google.gwtorm.jdbc.JdbcExecutor.execute(JdbcExecutor.java:42)

... 18 more

I fixed it by removing NO_ZERO_IN_DATE,NO_ZERO_DATE from sql_mode.