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 _________________________________________ 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]
