> From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Van Mittal-Henkle > Sent: Tuesday, 8 January 2008 13:08 > To: Developer > Subject: Re: [Mifos-developer] Problem Upgrading to Revision > 12244 and higher > > Hi Graeme, > > > I've been lurking for a month or so, running up a trial system for a > > potential new MFI (NOT in New Zealand :). > > Glad to know that you are interested in Mifos!
Thanks Van, and for your prompt and informative response. > > The Problem > > ----------- > > Connecting to Mifos after the upgrade returns the information below, > > rather than the logon screen. > > When changes are made to the Mifos schema or default SQL > data, there are 2 possible paths and upgrade can follow: > > 1) execute a sql script of the form "upgrade_to_xyz.sql" > where "xyz" is a database revision number like 169. > 2) execute a Java upgrade method which is defined in a class > file built into Mifos. > > In the case of database revision 169, the upgrade is implemented in > java, so you won't find any upgrade_to_169.sql file. That's ok, since > the upgrade is performed in Java rather than SQL. One thing to note > about this, is that attempting to apply SQL upgrade scripts manually > will not work correctly since you will miss any java upgrades. > > You will note in the error message you gave the following: > > > org.mifos.application.master.persistence.Upgrade169.upgrade(Up > > grade169.java:68) > > at org.mifos.framework.persistence.DatabaseVersionPersistence.upg > > radeDatabase(DatabaseVersionPersistence.java:404) > > This indicates that the Java Upgrade169 class was attempting > to run when you got your error. > > The other thing to note is the error: > > > Caused by: java.sql.SQLException: Duplicate entry '8' for key 1 > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) > > This alone doesn't tell you the exact problem, but from the > Java code, I can tell you the the issue is that upgrade 169 adds new > entries into the the database table COUNTRY. In this case the entry > being added is colliding with another entry in that table. The missing link! :-) > Currently we don't support changes made to this table outside of the > Mifos software development process. My guess is that an > entry was added to this table with a COUNTRY_ID of 8 which conflicts > with the value that upgrade 169 is attempting to insert. If you can > confirm that there is a row in the COUNTRY table in the database you > are attempting to upgrade with a COUNTRY_ID of 8, then we can verify > that this is the issue. Spot on. I have deleted the offending row, the update has completed, and we're back in action. > If this is the case, and you were interested in adding support to > Mifos for another country/language please let us know via the > mailing list. Will do once the project comes out of stealth mode. > We are currently in the process of doing a full implementation of > internationalization for Mifos initially to support Spanish and French > localizations and open the door to future additional language support. We'll be operating in an English-English speaking country, so it shouldn't be a big deal. Thanks again for your prompt and accurate response. Regards Graeme ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
