liquibase.exception.DatabaseException: Error executing SQL UPDATE margn.DATABASECHANGELOG SET MD5SUM = '7:084b2408b34c86052b2d531e509e968d' WHERE ID='NEW TYPE's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/database/databaseChangelog.xml': 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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1

JIRA | Sigmar Muuga | 3 years ago
  1. 0

    My changeset looks like this: <changeSet id="NEW TYPE's (mythings) for SOMETHING" author="Sigmar"> <sql> // some sql here </sql> </changeSet> And the result: /project/build.xml:167: liquibase.exception.DatabaseException: Error executing SQL UPDATE margn.DATABASECHANGELOG SET MD5SUM = '7:084b2408b34c86052b2d531e509e968d' WHERE ID='NEW TYPE's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/database/databaseChangelog.xml': 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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64) at liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogTable(AbstractJdbcDatabase.java:700) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602) at liquibase.Liquibase.update(Liquibase.java:130) at liquibase.integration.ant.DatabaseUpdateTask.executeWithLiquibaseClassloader(DatabaseUpdateTask.java:45) at liquibase.integration.ant.BaseLiquibaseTask.execute(BaseLiquibaseTask.java:70) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:392) at org.apache.tools.ant.Target.performTasks(Target.java:413) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) at org.apache.tools.ant.Project.executeTarget(Project.java:1368) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1251) at org.apache.tools.ant.Main.runBuild(Main.java:811) at org.apache.tools.ant.Main.startAnt(Main.java:217) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2637) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2566) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49) ... 24 more Works with liquibase 2.0.5, so I suspect it to be a bug in 3.0.1

    JIRA | 3 years ago | Sigmar Muuga
    liquibase.exception.DatabaseException: Error executing SQL UPDATE margn.DATABASECHANGELOG SET MD5SUM = '7:084b2408b34c86052b2d531e509e968d' WHERE ID='NEW TYPE's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/database/databaseChangelog.xml': 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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1
  2. 0

    My changeset looks like this: <changeSet id="NEW TYPE's (mythings) for SOMETHING" author="Sigmar"> <sql> // some sql here </sql> </changeSet> And the result: /project/build.xml:167: liquibase.exception.DatabaseException: Error executing SQL UPDATE margn.DATABASECHANGELOG SET MD5SUM = '7:084b2408b34c86052b2d531e509e968d' WHERE ID='NEW TYPE's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/database/databaseChangelog.xml': 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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64) at liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogTable(AbstractJdbcDatabase.java:700) at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602) at liquibase.Liquibase.update(Liquibase.java:130) at liquibase.integration.ant.DatabaseUpdateTask.executeWithLiquibaseClassloader(DatabaseUpdateTask.java:45) at liquibase.integration.ant.BaseLiquibaseTask.execute(BaseLiquibaseTask.java:70) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:392) at org.apache.tools.ant.Target.performTasks(Target.java:413) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399) at org.apache.tools.ant.Project.executeTarget(Project.java:1368) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1251) at org.apache.tools.ant.Main.runBuild(Main.java:811) at org.apache.tools.ant.Main.startAnt(Main.java:217) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2637) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2566) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49) ... 24 more Works with liquibase 2.0.5, so I suspect it to be a bug in 3.0.1

    JIRA | 3 years ago | Sigmar Muuga
    liquibase.exception.DatabaseException: Error executing SQL UPDATE margn.DATABASECHANGELOG SET MD5SUM = '7:084b2408b34c86052b2d531e509e968d' WHERE ID='NEW TYPE's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/database/databaseChangelog.xml': 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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1
  3. 0

    Duplicate Upgrade Query in 3.1

    GitHub | 2 years ago | jtesser
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'language_id'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Sql syntax error running clean mysql instance

    GitHub | 5 years ago | jgambarios
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '0) not null, log_name varchar(30) not null, description varchar(50) n' at line 2
  6. 0

    Add 'show' to reserved MySQL keywords in mapper

    GitHub | 6 years ago | lkuczera
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'show BOOLEAN , description LONGTEXT) ENGINE = InnoDB' at line 1

  1. Kialandei 1 times, last 2 weeks ago
  2. tvrmsmith 6 times, last 3 weeks ago
  3. davidvanlaatum 4 times, last 2 months ago
  4. tvrmsmith 1 times, last 3 months ago
  5. qoomon 1 times, last 4 months ago
27 more registered users
62 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

    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 's (mythings) for SOMETHING' AND AUTHOR='Sigmar' AND FILENAME='src/main/resources/data' at line 1

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    4 frames
  3. MySQL jdbc
    StatementImpl.execute
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    2. com.mysql.jdbc.Util.getInstance(Util.java:381)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
    6. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
    7. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    8. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2637)
    10. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2566)
    11. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782)
    12. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:625)
    12 frames
  4. Liquibase Core
    BaseLiquibaseTask.execute
    1. liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49)
    3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98)
    4. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64)
    5. liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogTable(AbstractJdbcDatabase.java:700)
    6. liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:602)
    7. liquibase.Liquibase.update(Liquibase.java:130)
    8. liquibase.integration.ant.DatabaseUpdateTask.executeWithLiquibaseClassloader(DatabaseUpdateTask.java:45)
    9. liquibase.integration.ant.BaseLiquibaseTask.execute(BaseLiquibaseTask.java:70)
    9 frames
  5. Ant
    UnknownElement.execute
    1. org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:601)
    4 frames
  7. Ant
    Main.startAnt
    1. org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    2. org.apache.tools.ant.Task.perform(Task.java:348)
    3. org.apache.tools.ant.Target.execute(Target.java:392)
    4. org.apache.tools.ant.Target.performTasks(Target.java:413)
    5. org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
    6. org.apache.tools.ant.Project.executeTarget(Project.java:1368)
    7. org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    8. org.apache.tools.ant.Project.executeTargets(Project.java:1251)
    9. org.apache.tools.ant.Main.runBuild(Main.java:811)
    10. org.apache.tools.ant.Main.startAnt(Main.java:217)
    10 frames
  8. Apache Ant Launcher
    Launcher.main
    1. org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
    2. org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
    2 frames