On Tue, 2008-03-04 at 10:45 -0800, Adam Monsen wrote: > On Tue, 2008-03-04 at 09:23 -0800, Adam Monsen wrote: > > Database upgrade #176 is broken... please manually execute > > sql/upgrade_to_176_conditional.sql against the database and restart the > > test server. > > On second thought, don't bother running that script, it won't work due > to foreign key constraints. I'll provide some custom SQL to fix the > problem and check in a fix to Upgrade176 as soon as possible.
Upgrade176 has been fixed, committed as trunk revision 12372. Please perform an svn update to pull in the latest code (or merge to your branch, as appropriate). One step that Van suggests before committing schema changes is downloading the latest database snapshot from ftp://test.mifos.org and deploying against that. The SQL to fix the test server is as follows: ALTER TABLE coa ADD COLUMN CATEGORY_TYPE VARCHAR(20); UPDATE coa SET category_type = 'ASSET' WHERE COA_Name = 'ASSETS'; UPDATE coa SET category_type = 'LIABILITY' WHERE COA_Name = 'LIABILITIES'; UPDATE coa SET category_type = 'INCOME' WHERE COA_Name = 'INCOME'; UPDATE coa SET category_type = 'EXPENDITURE' WHERE COA_Name = 'EXPENDITURE'; -- Adam Monsen ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
