Thanks for the good advice Darius. I will report my results.
Regards, Rob On 9/27/2011 7:25 PM, Darius Jazayeri wrote:
Can you try something like "select user_id from user where user_id not it (select person_id from person)" and see what that looks like? It shouldn't have been possible for you to have users whose user_id was not equals to the person_id of a person before 1.6, even though there was no db constraint for this. -Darius On Tue, Sep 27, 2011 at 10:02 AM, Rob Borland <[email protected] <mailto:[email protected]>> wrote: Upgrading OpenMRS 1.4.6 to 1.6.3 fails with this error: OpenMRS Installation Wizard * 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::200912031846-3::__djazayeri: Reason: liquibase.exception.__JDBCException: Error executing SQL ALTER TABLE `users` ADD CONSTRAINT `person_id_for_user` FOREIGN KEY (`person_id`) REFERENCES `person`(`person_id`): Caused By: Error executing SQL ALTER TABLE `users` ADD CONSTRAINT `person_id_for_user` FOREIGN KEY (`person_id`) REFERENCES `person`(`person_id`): Caused By: Cannot add or update a child row: a foreign key constraint fails (`openmrs`.`#sql-3ed_59`, CONSTRAINT `person_id_for_user` FOREIGN KEY (`person_id`) REFERENCES `person` (`person_id`)) Error while trying to update to the latest database version I can force the change by disabling foreign key checks but I get the same error when I reopen the web app. I'd appreciate any advice. Regards, Rob ___________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] <mailto:[email protected]> with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:LISTSERV@LISTSERV.__IUPUI.EDU <mailto:[email protected]>?body=SIGNOFF%__20openmrs-implement-l] ------------------------------------------------------------------------ Click here to unsubscribe <mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l> from OpenMRS Implementers' mailing list
_________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
