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

Liquibase changeset 20100426-1947 fails when upgrading from 1.6

    XMLWordPrintable

    Details

    • Complexity:
      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

        Attachments

          Activity

            People

            Assignee:
            dkayiwa Daniel Kayiwa
            Reporter:
            lara.kellett Lara Kellett [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: