liquibase.exception.DatabaseException: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause [Failed SQL: CREATE TABLE demo.jhi_user (id BIGINT AUTO_INCREMENT NOT NULL, login VARCHAR(50) NOT NULL, password_hash VARCHAR(60) NULL, first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL, email VARCHAR(100) NULL, activated BIT(1) NOT NULL, lang_key VARCHAR(5) NULL, activation_key VARCHAR(20) NULL, reset_key VARCHAR(20) NULL, created_by VARCHAR(50) NOT NULL, created_date timestamp DEFAULT NOW() NOT NULL, reset_date timestamp NULL, last_modified_by VARCHAR(50) NULL, last_modified_date timestamp DEFAULT NOW() NULL, CONSTRAINT PK_JHI_USER PRIMARY KEY (id), UNIQUE (email), UNIQUE (login))]

GitHub | jethan | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    GitHub comment 1098#242354857

    GitHub | 6 months ago | jethan
    liquibase.exception.DatabaseException: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause [Failed SQL: CREATE TABLE demo.jhi_user (id BIGINT AUTO_INCREMENT NOT NULL, login VARCHAR(50) NOT NULL, password_hash VARCHAR(60) NULL, first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL, email VARCHAR(100) NULL, activated BIT(1) NOT NULL, lang_key VARCHAR(5) NULL, activation_key VARCHAR(20) NULL, reset_key VARCHAR(20) NULL, created_by VARCHAR(50) NOT NULL, created_date timestamp DEFAULT NOW() NOT NULL, reset_date timestamp NULL, last_modified_by VARCHAR(50) NULL, last_modified_date timestamp DEFAULT NOW() NULL, CONSTRAINT PK_JHI_USER PRIMARY KEY (id), UNIQUE (email), UNIQUE (login))]
  2. 0

    question

    GitHub | 6 months ago | jethan
    liquibase.exception.DatabaseException: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause [Failed SQL: CREATE TABLE demo.jhi_user (id BIGINT AUTO_INCREMENT NOT NULL, login VARCHAR(50) NOT NULL, password_hash VARCHAR(60) NULL, first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL, email VARCHAR(100) NULL, activated BIT(1) NOT NULL, lang_key VARCHAR(5) NULL, activation_key VARCHAR(20) NULL, reset_key VARCHAR(20) NULL, created_by VARCHAR(50) NOT NULL, created_date timestamp DEFAULT NOW() NOT NULL, reset_date timestamp NULL, last_modified_by VARCHAR(50) NULL, last_modified_date timestamp DEFAULT NOW() NULL, CONSTRAINT PK_JHI_USER PRIMARY KEY (id), UNIQUE (email), UNIQUE (login))]
  3. 0

    updating user entity to add foreign key

    GitHub | 11 months ago | francisyuya
    liquibase.exception.DatabaseException: Can't create table '.\blog\#sql-784_3f.frm' (errno: 150) [Failed SQL: ALTER TABLE blog.jhi_user ADD CONSTRAINT fk_user_activityField FOREIGN KEY (activity_field_info_id) REFERENCES blog.activity_field_info (id)]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDL Studio sample JDL causes liquidbase errors in JHipster 3.0

    GitHub | 11 months ago | adam-ho
    liquibase.exception.DatabaseException: Table "LOCATION" not found; SQL statement: ALTER TABLE PUBLIC.department ADD CONSTRAINT fk_department_location_id FOREIGN KEY (location_id) REFERENCES PUBLIC.location (id) [42102-191] [Failed SQL: ALTER TABLE PUBLIC.department ADD CONSTRAINT fk_department_location_id FOREIGN KEY (location_id) REFERENCES PUBLIC.location (id)]
  6. 0

    The first initialization of the database (define with jdl-studio) with mvnw throw a liquibase exception

    GitHub | 9 months ago | chris2338
    liquibase.exception.DatabaseException: La cl+® est trop longue. Longueur maximale: 1000 [Failed SQL: ALTER TABLE fb.jhi_social_user_connection ADD UNIQUE (user_id, provider_id, provider_user_id)]

  1. tvrmsmith 2 times, last 5 months ago
  2. Malcshour 26 times, last 8 months ago
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. liquibase.exception.DatabaseException

    Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause [Failed SQL: CREATE TABLE demo.jhi_user (id BIGINT AUTO_INCREMENT NOT NULL, login VARCHAR(50) NOT NULL, password_hash VARCHAR(60) NULL, first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL, email VARCHAR(100) NULL, activated BIT(1) NOT NULL, lang_key VARCHAR(5) NULL, activation_key VARCHAR(20) NULL, reset_key VARCHAR(20) NULL, created_by VARCHAR(50) NOT NULL, created_date timestamp DEFAULT NOW() NOT NULL, reset_date timestamp NULL, last_modified_by VARCHAR(50) NULL, last_modified_date timestamp DEFAULT NOW() NULL, CONSTRAINT PK_JHI_USER PRIMARY KEY (id), UNIQUE (email), UNIQUE (login))]

    at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement()
  2. Liquibase Core
    SpringLiquibase.afterPropertiesSet
    1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:301)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:107)
    4. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1251)
    5. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1234)
    6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:554)
    7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
    8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
    9. liquibase.Liquibase.update(Liquibase.java:212)
    10. liquibase.Liquibase.update(Liquibase.java:192)
    11. liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:434)
    12. liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:391)
    12 frames
  3. free.config.liquibase
    AsyncSpringLiquibase.lambda$afterPropertiesSet$39
    1. free.config.liquibase.AsyncSpringLiquibase.initDb(AsyncSpringLiquibase.java:66)
    2. free.config.liquibase.AsyncSpringLiquibase.lambda$afterPropertiesSet$39(AsyncSpringLiquibase.java:49)
    2 frames