Thanks you so so much Martin for taking your time to try it out and giving us feedback!!!
On Wed, Apr 4, 2012 at 9:59 AM, Ketta Levi Martin <[email protected]>wrote: > The upgrade from 1.8.0 to 1.9 has been successful. > Thanks to you all. > > > > On Tue, Apr 3, 2012 at 5:00 PM, Ketta Levi Martin <[email protected]>wrote: > >> Hi Dan, >> I have made an observation that the "concept_reference_source" had >> "float" for datatype. I just changed it to "tinyint" and it proceeded. Up >> to now, I am still running the update, atleast it went beyond the point at >> which it was stuck. I will keep you posted on the progress of this upgrade. >> >> >> On Tue, Apr 3, 2012 at 3:36 PM, Daniel Kayiwa <[email protected]>wrote: >> >>> >>> Hi Martin, >>> >>> Can you check your "concept_source" or "concept_reference_source" table >>> and check if the "retired" column has any values other than 1 or 0 >>> >>> >>> >>> On Tue, Apr 3, 2012 at 2:44 PM, Ketta Levi Martin >>> <[email protected]>wrote: >>> >>>> Hi Dan, >>>> Yes, after getting that email yesterday about the release of RC2 I had >>>> to download it and attempted to do the upgrade. >>>> You can also see the tomcat log file here http://pastebin.com/LQXSFh0J >>>> The version of tomcat I am using is 5.5.17 >>>> MSQL Version is 5.0 >>>> >>>> >>>> >>>> On Tue, Apr 3, 2012 at 10:48 AM, Daniel Kayiwa >>>> <[email protected]>wrote: >>>> >>>>> >>>>> Hi Martin, >>>>> >>>>> Did you use RC2? >>>>> If yes, can you pastebin the contents of the tomcat log and send us >>>>> the url? >>>>> >>>>> On Tue, Apr 3, 2012 at 10:26 AM, Ketta Levi Martin < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi, while running an upgrade from OpenMRS 1.8.0 to 1.9 I get this >>>>>> error message below >>>>>> >>>>>> - ??? Reason: liquibase.exception.DatabaseException: Error >>>>>> executing SQL ALTER TABLE `concept_reference_source` MODIFY `retired` >>>>>> TINYINT(1) NOT NULL DEFAULT 0: Data truncated for column 'retired' at >>>>>> row >>>>>> 1:??? >>>>>> - ??? Caused By: Data truncated for column 'retired' at row 1??? >>>>>> - ??? Caused By: Error executing SQL ALTER TABLE >>>>>> `concept_reference_source` MODIFY `retired` TINYINT(1) NOT NULL >>>>>> DEFAULT 0: >>>>>> Data truncated for column 'retired' at row 1:??? >>>>>> - ???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::20090316-1008-fix::sunbiz:??? >>>>>> - Unable to update the database. See server error logs for the >>>>>> full stacktrace. >>>>>> >>>>>> Anything I should do? >>>>>> >>>>>> >>>>>> -- >>>>>> Martin Levi Ketta >>>>>> P.O. Box 1292 >>>>>> Masaka - Uganda >>>>>> Mob: +256 752808383 >>>>>> >>>>>> ------------------------------ >>>>>> 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 >>>> >>>> >>>> >>>> >>>> -- >>>> Martin Levi Ketta >>>> P.O. Box 1292 >>>> Masaka - Uganda >>>> Mob: +256 752808383 >>>> >>>> ------------------------------ >>>> 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 >>> >> >> >> >> -- >> Martin Levi Ketta >> P.O. Box 1292 >> Masaka - Uganda >> Mob: +256 752808383 >> >> > > > -- > Martin Levi Ketta > P.O. Box 1292 > Masaka - Uganda > Mob: +256 752808383 > > ------------------------------ > 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]
