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

Liquibase changeset 20100426-1947 fails when upgrading from 1.6

    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

        Gliffy Diagrams

          Attachments

            Attachments-Category-Modification

              Activity

                People

                • Assignee:
                  dkayiwa Daniel Kayiwa
                  Reporter:
                  lara.kellett Lara Kellett
                  Watchers:
                  Ben Wolfe, Daniel Kayiwa, Darius Jazayeri, Lara Kellett
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: