Mathew, Which version of MySQL are you running? Do you have any anti virus software running? If yes, does the upgrade work after you temporarily turn it off?
On Fri, Apr 13, 2012 at 2:39 PM, Matthew Ssemakadde <[email protected]>wrote: > am now trying to update from 1.8 to 1.9.0RC3 > and am getting the following error > > > - ??? Reason: ??? > - ??? Caused By: Precondition Error??? > - ???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::201011051300::bwolfe:??? > - Unable to update the database. See server error logs for the full > stacktrace. > - ??? liquibase-update-to-latest.xml : Table > 'openmrs.visit_attribute_type' doesn't exist ??? > - ???:??? > > > the paste bin links is http://pastebin.com/8MFc5Y3k > > > Matthew > Masaka(Ug) > > > > On Thu, Apr 12, 2012 at 5:35 AM, Ben Wolfe <[email protected]> wrote: > >> Very interesting Mathew. Thanks for the pastebin. Can you do a >> "describe notification_alert" in your mysql command line? And "show create >> table notification_alert" >> >> I think this is a bug in liquibase in how it is looking up and reporting >> indexes. The 201011051300 changeset deals with the notification_alert >> table, not the patient_flags table. (patient_flags is never referred to >> from core as its a module) >> >> Ben >> >> >> On Wed, Apr 11, 2012 at 1:02 AM, Matthew Ssemakadde <[email protected] >> > wrote: >> >>> Daniel, >>> Am trying 1.9RC2 >>> >>> >>> On Tue, Apr 10, 2012 at 4:25 AM, Daniel Kayiwa >>> <[email protected]>wrote: >>> >>>> >>>> Mathew, >>>> >>>> Are you trying out 1.9 RC2? >>>> Am still wondering since we do not reference the "patientflags_flag" >>>> table anywhere in that liquibase file. >>>> >>>> >>>> On Tue, Apr 10, 2012 at 2:32 PM, Matthew Ssemakadde < >>>> [email protected]> wrote: >>>> >>>>> pesetebin link http://pastebin.com/a2i1QnAe >>>>> >>>>> >>>>> >>>>> On Tue, Apr 10, 2012 at 2:02 AM, Matthew Ssemakadde < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi All >>>>>> >>>>>> am getting the flowing error while updating? >>>>>> >>>>>> >>>>>> - ??? Reason: ??? >>>>>> - ??? Caused By: Precondition Error??? >>>>>> - ???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::201011051300::bwolfe:??? >>>>>> - ??? liquibase-update-to-latest.xml : Table >>>>>> 'openmrs.patientflags_flag' doesn't exist ??? >>>>>> - Unable to update the database. See server error logs for the >>>>>> full stacktrace. >>>>>> - ???:??? >>>>>> >>>>>> >>>>>> any help?? >>>>>> >>>>>> >>>>>> Matthew >>>>>> Masaka(Ug) >>>>>> >>>>> >>>>> ------------------------------ >>>>> Click here to >>>>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>>>> OpenMRS Implementers' mailing list >>>>> >>>> >>>> >>>> >>>> -- >>>> If we keep uppermost in our minds the unkind and unjust acts of others, >>>> we shall find it impossible to love them as Christ has loved us; but if our >>>> thoughts dwell upon the wondrous love and pity of Christ for us, the same >>>> spirit will flow out to others. >>>> ------------------------------ >>>> Click here to >>>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>>> OpenMRS Implementers' mailing list >>>> >>> >>> ------------------------------ >>> Click here to >>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >>> OpenMRS Implementers' mailing list >>> >> >> ------------------------------ >> Click here to >> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from >> OpenMRS Implementers' mailing list >> > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list > -- If we keep uppermost in our minds the unkind and unjust acts of others, we shall find it impossible to love them as Christ has loved us; but if our thoughts dwell upon the wondrous love and pity of Christ for us, the same spirit will flow out to others. _________________________________________ 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]

