I have been running Mifos (now up to 2.2.3) in a Windows environment, and have used Selenium to put active loans from our existing spreadsheet- based system into Mifos with the correct loan creation dates. I've now set up a copy of Mifos 2.2.3 in a hosted Linux environment, and want to move my data to it from Windows. I followed the MySQLDump- based backup and restore process outlined in the FAQs.
My problem is that, when I start Jetty in the Linux environment,Liquibase doesn't seem to recognise the existing database updates in the databasechangelog table, appears to recreate the table and then tries unsuccessfully to reapply all the updates to my already-updated database. Here is the relevant part of the logs: INFO 1/19/12 4:47 AM:liquibase: Successfully acquired change log lock INFO 1/19/12 4:47 AM:liquibase: Creating database history table with name: `DATABASECHANGELOG` INFO 1/19/12 4:47 AM:liquibase: Reading from `DATABASECHANGELOG` INFO 1/19/12 4:47 AM:liquibase: Reading from `DATABASECHANGELOG` INFO 1/19/12 4:47 AM:liquibase: Successfully released change log lock 2012-01-19/04:47:23.980/EST ERROR, org.mifos.framework.ApplicationInitializer, ?, ?, ?, Failed to upgrade database. liquibase.exception.MigrationFailedException: Migration failed for change set changesets/changelog-PreRelease_G.xml::MIFOS_4700_0a::John Woodlock: Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE loan_activity_details ... Could anyone suggest why this might be happening? I've tried to align the character set of the two databases to UTF-8, but that didn't seem to help. ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
