There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Gerrit with Gitlab
    via by Sanoob E P,
  • mysql 5.7
    via by Unknown author,
  • gerrit with mysql
    via by djph29,
  • Duplicate Upgrade Query in 3.1
    via GitHub by jtesser
  • Re: views created before tables?
    via by Stephen Cameron,
  • Invalid SQL syntax
    via GitHub by cbadenes
    • Cannot apply SQL CREATE TABLE account_group_by_id_aud ( added_by INT DEFAULT 0 NOT NULL, removed_by INT, removed_on TIMESTAMP NULL DEFAULT NULL, group_id INT DEFAULT 0 NOT NULL, include_uuid VARCHAR(255) BINARY DEFAULT '' NOT NULL, added_on TIMESTAMP NOT NULL ,PRIMARY KEY(group_id,include_uuid,added_on) ) at at at at at at$SiteRun.upgradeSchema( at at at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke( at sun.reflect.DelegatingMethodAccessorImpl.invoke( at java.lang.reflect.Method.invoke( at at at at Main.main( Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid default value for 'added_on' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance( at sun.reflect.DelegatingConstructorAccessorImpl.newInstance( at java.lang.reflect.Constructor.newInstance( at com.mysql.jdbc.Util.handleNewInstance( at com.mysql.jdbc.Util.getInstance( at com.mysql.jdbc.SQLError.createSQLException( at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.checkErrorPacket( at com.mysql.jdbc.MysqlIO.sendCommand( at com.mysql.jdbc.MysqlIO.sqlQueryDirect( at com.mysql.jdbc.ConnectionImpl.execSQL( at com.mysql.jdbc.ConnectionImpl.execSQL( at com.mysql.jdbc.StatementImpl.execute( at com.mysql.jdbc.StatementImpl.execute( at ... 15 more

    Users with the same issue

    7 times, last one,
    88 times, last one,
    7 times, last one,
    3 times, last one,
    13 times, last one,
    115 more bugmates