Matthew,
Its possible that somehow the mifos database you have is not what is
expected (somehow different).
the sql that is being executed is:
ALTER TABLE loan_activity_details
DROP FOREIGN KEY `loan_activity_details_ibfk_10` ,
DROP FOREIGN KEY `loan_activity_details_ibfk_3` ,
DROP FOREIGN KEY `loan_activity_details_ibfk_4` ,
DROP FOREIGN KEY `loan_activity_details_ibfk_5` ,
DROP FOREIGN KEY `loan_activity_details_ibfk_6` ,
DROP FOREIGN KEY `loan_activity_details_ibfk_7` ,
DROP FOREIGN KEY `loan_activity_details_ibfk_8` ,
DROP FOREIGN KEY `loan_activity_details_ibfk_9`
, DROP INDEX `balance_fee_amount_currency_id`
, DROP INDEX `balance_interest_amount_currency_id`
, DROP INDEX `balance_penalty_amount_currency_id`
, DROP INDEX `balance_principal_amount_currency_id`
, DROP INDEX `fee_amount_currency_id`
, DROP INDEX `interest_amount_currency_id`
, DROP INDEX `penalty_amount_currency_id`
, DROP INDEX `principal_amount_currency_id` ;
Note the lowercase table and foreign key/index names.
Coming from the windows environment, possibly your mysql doesnt have
all lowercase tablenames or foriegn keys/indices?
Can you check this?
Trying running the sql statement from mysql workbench to see what
error message appears?
Keith.
On Fri, Jan 20, 2012 at 2:28 AM, Matthew Laurenson
<matt...@laurenson.name> wrote:
> 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
------------------------------------------------------------------------------
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
