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