Invalid default value for 'CREATE_TS'

Hi team,
I am using MySql database and getting below error.

Task :dataimport-core:assembleDbScripts UP-TO-DATE

Task :dataimport-core:createDb FAILED
Using database URL: jdbc:mysql://localhost/cuba?useSSL=false&allowMultiQueries=true&serverTimezone=UTC, user: root
Failed to execute: create table SYS_DB_CHANGELOG (
SCRIPT_NAME varchar(190) not null primary key,
CREATE_TS datetime default current_timestamp,
IS_INIT integer default 0) because: Invalid default value for ‘CREATE_TS’

FAILURE: Build failed with an exception.

  • What went wrong:
    Execution failed for task ‘:dataimport-core:createDb’.

java.lang.RuntimeException (no error message)

  • Try:
    Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.

  • Get more help at https://help.gradle.org

Deprecated Gradle features were used in this build, making it incompatible with Gradle 5.0.
Use ‘–warning-mode all’ to show the individual deprecation warnings.
See Command-Line Interface

BUILD FAILED in 0s
2 actionable tasks: 1 executed, 1 up-to-date
Invalid default value for ‘CREATE_TS’
3:10:22 PM: Task execution finished ‘createDb’.

THANKS…

Hi,
What MySQL version are you using?

It’s resolved i was used 5.0, now using lates so issue resolved.
Thanks for reply :slight_smile:

Hi can you help me on this Question :