Henrik,
You don't need to do a new install for 2.1.3. Your problem is because mifos
thinks the database is 2.0 and is trying to apply database upgrades (in this
case a table that you already created).
Mifos should upgrade itself from 2.0.0 to 2.1.3 when you deploy and run the
2.1.3. war file. There may be a need to upgrade to 2.0.2 first (I just
don't know for sure) but you can do this interim upgrade only if you get a
problem with simply deploying and running 2.1.3
John
On Sat, Jun 25, 2011 at 1:03 PM, Henrik Esbensen <hen...@creocore.org>wrote:
> Hi there,****
>
> ** **
>
> I’m trying to upgrade from Mifos 2.0.0 to 2.1.3, but I’m getting the error
> below (full stack attached).****
>
> ** **
>
> Here’s what I’m doing (which is likely wrong):****
>
> **1) **Creating new mifos database, following the 2.1.3 instructions
> as if I were creating a new clean installation. I.e., I’m creating the
> ‘mifos’ database, a ‘mifos’ user, and loading the three sql files (new
> schema etc) which comes with 2.1.3. After doing this, Mifos will start and
> is working nicely (but contains no data, of course).****
>
> **2) **Then I dump the mifos volcano from my 2.0.0 installation
> (mysqldump) and load it into my new 2.1.3 installation.****
>
> **3) **When firing up mifos 2.1.3, I now see the error below.****
>
> ****
>
> I’ve looked at the 2.1 upgrade instructions:
> http://mifosforge.jira.com/wiki/display/MIFOS/Mifos+2.1+Upgrade+Instructions
> ****
>
> and I do have known issue Mifos-4892 about question groups, but I think
> that’s unrelated – it looks like I can fix that problem by following the
> instructions.****
>
> ** **
>
> Any help is greatly appreciated.****
>
> ** **
>
> Thanks a lot!****
>
> ** **
>
> **- **Henrik****
>
> **- **CreoCore, www.creocore.org****
>
> ** **
>
> ** **
>
>
> ================================================================================
> ****
>
> *Mifos Database Error*
>
> A database error occurred. Correct the error and restart the application.
> Details:****
>
> *Failed to upgrade database. Unable to apply database upgrades*
>
> More details:****
>
> *Not implemented - check local.properties file for local overrides*
>
> Stack trace:****
>
> java.sql.BatchUpdateException: Table 'variable_installment_details' already
> exists****
>
> at
> com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1067)****
>
> at
> com.mchange.v2.c3p0.impl.NewProxyStatement.executeBatch(NewProxyStatement.java:743)
> ****
>
> at
> org.mifos.framework.persistence.SqlExecutor.execute(SqlExecutor.java:57)**
> **
>
> at
> org.mifos.framework.persistence.SqlUpgrade.runScript(SqlUpgrade.java:46)**
> **
>
> ** **
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense..
> http://p.sf.net/sfu/splunk-d2d-c1
> _______________________________________________
> Mifos-users mailing list
> Mifos-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense..
http://p.sf.net/sfu/splunk-d2d-c1
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
