liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: 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 'clob' 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 Jason Duke, 1 year ago
Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: 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 'clob' at line 1
via JIRA by Jason Duke, 1 year ago
Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: 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 'clob' at line 1
via Stack Overflow by sathish kumar
, 1 year ago
Error executing SQL CREATE TABLE [ASSET_ATTRIBUTE] ([ASSET_ATTR_ID] BIGINT IDENTITY (1, 1) NOT NULL, [ASSET_GUID] UNIQUEIDENTIFIER NOT NULL, [APP_ID] VARCHAR(30), [ATTR_TYPE] VARCHAR(30) NOT NULL, [ATTR_NAME] VARCHAR(50) NOT NULL
via Stack Overflow by Dave
, 1 year ago
Error executing SQL ALTER TABLE organization MODIFY COLUMN ACTIVE BIT(1) NOT NULL DEFAULT 1: Data truncated for column 'ACTIVE' at row 1
via GitHub by ojhunt
, 2 years ago
Error executing SQL ALTER TABLE commafeed.FEEDENTRYTAGS ADD CONSTRAINT fk_entry_id FOREIGN KEY (entry_id) REFERENCES commafeed.FEEDENTRIES (id): Can't create table 'commafeed.#sql-3e1_87a6' (errno: 150)
via GitHub by csiebert
, 1 year ago
Error executing SQL ALTER TABLE `osm`.`ev ent_result` DROP FOREIGN KEY `FK3CA811623AA7BDEF`: Table 'osm.event_result' does n't exist
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: 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 'clob' at line 1
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1341)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1325)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:28)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:135)

Users with the same issue

Once, 1 year ago

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