...
In previous versions of Mifos, if client approval is automatic, savings accounts created during client creation were broken. Here is a query you can run to determine if this has happened, and remove the incorrect accounts.
Identify affected accounts:
| Code Block | ||
|---|---|---|
| ||
SELECT sa.account_id,a.global_account_num, a.customer_id FROM savings_account sa, account a where sa.account_id = a.account_id and a.global_account_num is null;
|
Delete affected accounts (assuming no transactions have been logged for the accounts):
| Code Block | ||
|---|---|---|
| ||
delete from savings_account
where exists
(select 'f' from account a
where a.account_id = savings_account.account_id
and a.global_account_num is null);
delete from savings_performance
where exists
(select 'f' from account a
where a.account_id = savings_performance.account_id
and a.global_account_num is null);
delete from saving_schedule
where exists
(select 'f' from account a
where a.account_id = saving_schedule.account_id
and a.global_account_num is null);
and finally, delete reference to account:
delete from account where account.global_account_num is null;
|
If transactions have been created for these accounts, then ask for help on the developer list.