When Center is moved to new Loan Officer, subordinate accounts are not updated

Hi Chico, Sorry I wasn't more clear. Here's the situation: a few micro-finance
institutions have been using Mifos 1.0 for a while and have already moved
centers between loan officers. So now in their databases they have accounts
which do not have the correct loan officer and they will need to run a script on
the database to update all of those accounts with the proper loan officer id. I
am hoping that you or one of the software developers who worked on this issue
could provide the script, if possible. Thanks!

From my perspective, two things would be ideal:
1. A script which identifies and cleans up this issue which can be run by our
existing deployments (i.e. Jitegemea) until v1.1 ships and the underlying bug is
resolved.

2. (Lower priority) Potentially a similar script that is executed as part of the
upgrade scripts so that this issue is identified and cleaned up one final time
when Jitegemea and GK upgrade from their current versions to v1.1.

Definitely #1 would be very useful for Jitegemea immediately and they can always
run the same script one final time prior to upgrading if we don't want to do #2.

Created an attachment (id=645)
SQL Script which fixed problem at the database level

Hi Bart,

I've attached a SQL file (Issue1804_DatabaseFix.sql) which fixes this issue in
existing deployments.

Cheers
Chico

Thanks for the script Chico! I'll try it out today.