concept_reference_source is new in 1.9, so its not like you have bad data. This must be something strange with mysql 5.0. Which exact version are you using?
Ben On Tue, Apr 3, 2012 at 7:44 AM, 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 > _________________________________________ 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]
