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 | 3 months ago
  1. 0

    GitHub comment 1098#242354857

    GitHub | 3 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 | 3 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 | 9 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 | 8 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 | 7 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 3 months ago
  2. tvrmsmith 7 times, last 3 months ago
  3. Malcshour 26 times, last 6 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