[
http://mifosforge.jira.com/browse/MIFOS-2871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Udai Gupta updated MIFOS-2871:
------------------------------
Attachment: patch-MIFOS-2871.txt
In upgrade 227 a column in Fee table with FK to Currency was added and upgrade
232 is removing that column because later we decided not to have that column.
The fix is straight forward, just deleted the addition and deletion of that
column from respective upgrades as they are both in same release.
The patch for this is attached with this issue. let me know if we want this to
go in 1.5.x.
I will also commit this patch in `trunk if we decide to commit it in 1.5.x
> Upgrade error on upgrade to version 232 with GK data
> ----------------------------------------------------
>
> Key: MIFOS-2871
> URL: http://mifosforge.jira.com/browse/MIFOS-2871
> Project: mifos
> Issue Type: Bug
> Components: Database
> Affects Versions: Release 1.5
> Environment: http://testgreen.mifos.org:8087/mifos/
> Reporter: jbrewster
> Assignee: Udai Gupta
> Priority: Major
> Attachments: patch-MIFOS-2871.txt, screenshot-1.jpg
>
>
> Upgrading the latest backup of GK database to version 1.5 encounters an error
> in the version 232 upgrade:
> Error on rename of '.\mifos\#sql-fa8_35d5' to '.\mifos\fees' (errno: 150)
> See attached screenshot for the full error. I haven't encountered this error
> on other databases I've tested. Here is the content of upgrade_to_232.sql
> file:
> ALTER TABLE FEES DROP FOREIGN KEY fees_ibfk_10;
> ALTER TABLE FEES DROP COLUMN CURRENCY_ID;
> UPDATE DATABASE_VERSION SET DATABASE_VERSION = 232 WHERE DATABASE_VERSION =
> 231;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
