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