Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-3031

Liquibase changeset 20100426-1947 fails when upgrading from 1.6

    XMLWordPrintable

Details

    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

      Gliffy Diagrams

        Attachments

          Activity

            People

              dkayiwa Daniel Kayiwa
              lara.kellett Lara Kellett
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: