liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE organization MODIFY COLUMN ACTIVE BIT(1) NOT NULL DEFAULT 1: Data truncated for column 'ACTIVE' at row 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 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 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 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 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
via GitHub by seewhydee
, 2 years ago
Error executing SQL DROP INDEX `subscription_id` ON `FEEDENTRYSTATUSES`: Cannot drop index 'subscription_id': needed in a foreign key constraint
liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE organization MODIFY COLUMN ACTIVE BIT(1) NOT NULL DEFAULT 1: Data truncated for column 'ACTIVE' at row 1
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1206)

Users with the same issue

Once, 1 year ago

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