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

Liquibase upgrade failure with users.user_id foreign key

    Details

    • Complexity:
      Low

      Description

      During the upgrade this error is thrown:
      liquibase.exception.JDBCException: Error executing SQL ALTER TABLE `users` DROP FOREIGN KEY `person_id_for_user`

      The quick fix for this is to run this sql on your database so that the update can continue:

      ALTER TABLE `users` ADD CONSTRAINT `person_id_for_user` FOREIGN KEY (`user_id`) REFERENCES `person` (`person_id`);
      

        Attachments

          Activity

            People

            • Assignee:
              bwolfe Ben Wolfe
              Reporter:
              bwolfe Ben Wolfe
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: