liquibase.exception.DatabaseException: Table 'users' already exists [Failed SQL: CREATE TABLE traccar.users (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, hashedpassword VARCHAR(128) NOT NULL, salt VARCHAR(128) NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(128) DEFAULT 'osm' NOT NULL, language VARCHAR(128) DEFAULT 'en' NOT NULL, distanceunit VARCHAR(128) DEFAULT 'km' NOT NULL, speedunit VARCHAR(128) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]

GitHub | Turbovix | 3 months ago
  1. 0

    GitHub comment 2337#247907183

    GitHub | 3 months ago | Turbovix
    liquibase.exception.DatabaseException: Table 'users' already exists [Failed SQL: CREATE TABLE traccar.users (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(128) NOT NULL, email VARCHAR(128) NOT NULL, hashedpassword VARCHAR(128) NOT NULL, salt VARCHAR(128) NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(128) DEFAULT 'osm' NOT NULL, language VARCHAR(128) DEFAULT 'en' NOT NULL, distanceunit VARCHAR(128) DEFAULT 'km' NOT NULL, speedunit VARCHAR(128) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USERS PRIMARY KEY (id))]
  2. 0

    Clean install with mysql/mariadb

    GitHub | 11 months ago | 1sthandy
    liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: CREATE TABLE traccar.user (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(1024) NOT NULL, email VARCHAR(256) NOT NULL, hashedPassword VARCHAR(1024) NOT NULL, salt VARCHAR(1024) DEFAULT '' NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(1024) DEFAULT 'osm' NOT NULL, language VARCHAR(1024) DEFAULT 'en' NOT NULL, distanceUnit VARCHAR(1024) DEFAULT 'km' NOT NULL, speedUnit VARCHAR(1024) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USER PRIMARY KEY (id), UNIQUE (email))]
  3. 0

    MySQL снова

    GitHub | 11 months ago | moroq
    liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: CREATE TABLE c0_skiltrade.user (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(1024) NOT NULL, email VARCHAR(256) NOT NULL, hashedPassword VARCHAR(1024) NOT NULL, salt VARCHAR(1024) DEFAULT '' NOT NULL, readonly BIT(1) DEFAULT 0 NOT NULL, admin BIT(1) DEFAULT 0 NOT NULL, map VARCHAR(1024) DEFAULT 'osm' NOT NULL, language VARCHAR(1024) DEFAULT 'en' NOT NULL, distanceUnit VARCHAR(1024) DEFAULT 'km' NOT NULL, speedUnit VARCHAR(1024) DEFAULT 'kmh' NOT NULL, latitude DOUBLE DEFAULT 0 NOT NULL, longitude DOUBLE DEFAULT 0 NOT NULL, zoom INT DEFAULT 0 NOT NULL, CONSTRAINT PK_USER PRIMARY KEY (id), UNIQUE (email))]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [Mifos-developer] Please help! (Urgent)

    Google Groups | 4 years ago | adamu aliyu
    liquibase.exception.DatabaseException: Error executing SQL PREPARE stmt FROM @mifosquery: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1:          Caused By: Error executing SQL PREPARE stmt FROM @mifosquery: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1:          Caused By: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
  6. 0

    Create function from SQL script by Liquibase

    Stack Overflow | 11 months ago | Newbie
    liquibase.exception.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER // CREATE FUNCTION rad2deg(rad DOUBLE) RETURNS DOUBLE BEGIN ' at line 3 [Failed SQL: DROP FUNCTION IF EXISTS rad2deg; DELIMITER // CREATE FUNCTION rad2deg(rad DOUBLE) RETURNS DOUBLE BEGIN RETURN (rad * 180 / PI()); END // DELIMITER ;]

  1. tvrmsmith 6 times, last 3 weeks ago
  2. Seungwan 1 times, last 5 months ago
  3. Kialandei 1 times, last 2 weeks ago
  4. davidvanlaatum 4 times, last 2 months ago
  5. tvrmsmith 1 times, last 3 months ago
27 more registered users
61 unregistered visitors
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. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Table 'users' already exists

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    4 frames
  3. MySQL jdbc
    StatementImpl.execute
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    2. com.mysql.jdbc.Util.getInstance(Util.java:387)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
    10. com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
    11. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739)
    11 frames
  4. Liquibase Core
    Liquibase.update
    1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:299)
    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:1273)
    5. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1255)
    6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:568)
    7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
    8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:79)
    9. liquibase.Liquibase.update(Liquibase.java:214)
    10. liquibase.Liquibase.update(Liquibase.java:192)
    11. liquibase.Liquibase.update(Liquibase.java:188)
    11 frames
  5. org.traccar.database
    DataManager.<init>
    1. org.traccar.database.DataManager.initDatabaseSchema(DataManager.java:141)
    2. org.traccar.database.DataManager.<init>(DataManager.java:67)
    2 frames
  6. org.traccar
    Main.main
    1. org.traccar.Context.init(Context.java:150)
    2. org.traccar.Main.main(Main.java:35)
    2 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  8. Java Service Wrapper
    WrapperSimpleApp.run
    1. org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:325)
    1 frame
  9. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame