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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via JIRA by Sigmar Muuga, 1 year ago
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
via JIRA by Sigmar Muuga, 1 year ago
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
via JIRA by Gábor Czigola, 1 year ago
Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL
via JIRA by Gábor Czigola, 1 year ago
Error executing SQL CREATE TABLE kirlko_xvanmit.DATABASECHANGELOG (ID VARCHAR(63) NOT NULL, AUTHOR VARCHAR(63) NOT NULL, FILENAME VARCHAR(200) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL
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 sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
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)
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 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.launch.Launcher.run(Launcher.java:280)

Users with the same issue

Samebug visitor profile picture
Unknown user
2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
13 times, 11 months ago
Samebug visitor profile picture
Unknown user
2 times, 1 year ago
7 times, 8 months ago
123 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.