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

Liquibase upgrade failure with users.user_id foreign key

    XMLWordPrintable

    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: