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
Priority: Major
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
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
