Details
-
Bug
-
Status: Closed
-
TBD
-
Resolution: Fixed
-
None
-
None
-
None
-
Low
Description
When upgrading from 1.6 openmrs the liquibase changeset 20100426-1947 fails because the person_id column on the users table is set to not nullable. The following error is produced
There was an error while updating the database to the latest. file: liquibase-update-to-latest.xml. Error: Migration failed for change set liquibase-update-to-latest.xml::20100426-1947::syhaas: Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO `users` (`creator`, `date_created`, `retired`, `system_id`, `username`, `uuid`) VALUES (1, '2010-04-26 13:25:00.0', 0, 'daemon', 'daemon', 'A4F30A1B-5EB9-11DF-A648-37A07F9C90FB'): Field 'person_id' doesn't have a default value: Caused By: Error executing SQL INSERT INTO `users` (`creator`, `date_created`, `retired`, `system_id`, `username`, `uuid`) VALUES (1, '2010-04-26 13:25:00.0', 0, 'daemon', 'daemon', 'A4F30A1B-5EB9-11DF-A648-37A07F9C90FB'): Field 'person_id' doesn't have a default value: Caused By: Field 'person_id' doesn't have a default value Error while trying to update to the latest database version