[
http://mifosforge.jira.com/browse/MIFOS-3517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=60122#action_60122
]
Jakub Sławiński commented on MIFOS-3517:
----------------------------------------
This bug is caused by the invalid date in database.
When I enabled date type additional fields there was a short time period when
it was possible to save date to database in wrong format (you can check, that
it is not possible now). Unfortunately, three accounts were created with
invalid date type additional field:
- Timothy Samson (0005-000000090)
- sakuntala behera (0015-000000100)
- sunita sahoo (0015-000000105)
You can fix those accounts with the following sql statement:
UPDATE customer_custom_field SET FIELD_VALUE='2010-12-15' where FIELD_VALUE =
'15/12/2010';
We have two choices now:
- fix the database and close this bug (because it is not possible to enter
invalid date data now and because this wrong behaviour was never visible to our
clients)
- add a special handling to jsp for the wrongly formatted additional date
fields
What should I do next?
> stacktrace trying to view client details for sakuntala behera on head/master
> deploy
> -----------------------------------------------------------------------------------
>
> Key: MIFOS-3517
> URL: http://mifosforge.jira.com/browse/MIFOS-3517
> Project: mifos
> Issue Type: Bug
> Components: Clients
> Affects Versions: Release E
> Reporter: Adam Monsen
> Assignee: Jakub Sławiński
> Priority: Major
> Fix For: Release E - Iteration 7, Release E
>
>
> h3. Repro
> # login to head/master test deploy (http://ci.mifos.org:8085/mifos/)
> # search for 0015-000000100
> h3. Expected Results
> see client details page for sakuntala behera
> h3. Actual Results
> JSP stack trace
> h3. Additional Information
> * See attached
> * Call to
> {{${userdatefn:getUserLocaleDate(sessionScope.UserContext.preferredLocale,customField.fieldValue)}}}
> seems to be where the exception occurs
> * down in the stacktrace, I see {{java.text.ParseException: Unparseable date:
> "15/12/2010"}} from {{DateHelper}} / {{DateUtils}}
> * [current data set used by head/master
> deploy|http://ci.mifos.org/2010-08-04_hudson_mifos_gazelle_trunk-db_dump.sql.gz]
> (right-click, "save as...")
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
