in the log, i got this message:
{timestamp: 1509099806863, status: 500, error: "Internal Server Error",…}
error:"Internal Server Error"
exception:"org.springframework.jdbc.BadSqlGrammarException"
message:"PreparedStatementCallback; bad SQL grammar [select dd.id as
id,dd.expected_disburse_date as expectedDisbursementdate,
dd.disbursedon_date as actualDisbursementdate,dd.principal as
principal,sum(lc.amount) chargeAmount, lc.amount_waived_derived
waivedAmount,group_concat(lc.id) loanChargeId from m_loan l inner join
m_loan_disbursement_detail dd on dd.loan_id = l.id left join
m_loan_tranche_disbursement_charge tdc on tdc.disbursement_detail_id=dd.id
left join m_loan_charge lc on lc.id=tdc.loan_charge_id and lc.is_active=1
where dd.loan_id=? group by dd.id order by dd.expected_disburse_date];
nested exception is
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #6
<https://github.com/openMF/community-app/pull/6> of SELECT list is not in
GROUP BY clause and contains nonaggregated column
'mifostenant-sav.lc.amount_waived_derived' which is not functionally
dependent on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by"
status:500
timestamp:1509099806863
Le mardi 24 octobre 2017 19:24:51 UTC+1, hamza smaiti a écrit :
>
> Hello,
> The connection is working.
>
> I have it working well on another computer, but i think the probleme here
> is some access rights that i didnt' give to somes files, or the deploiement
> of the application on the server. I'm not really sure.
>
> Le samedi 21 octobre 2017 11:05:19 UTC+1, Gopala Krishnan a écrit :
>>
>> Hi,
>>
>> I believe that is because the data is not loaded yet or you might have
>> some internet connection problem. In any case, please do mention the steps
>> to reproduce this so that someone can confirm it if it is a bug.
>>
>> On Fri, Oct 20, 2017 at 8:01 PM, hamza smaiti <hamza....@gmail.com>
>> wrote:
>>
>>> When i create a new loan for a client, and i want to approuve the loan,
>>> i can't see the menu and the data are all corrupted.
>>>
>>> here is a screenshot of the view:
>>>
>>>
>>> <https://lh3.googleusercontent.com/-DFGVKFpIw3k/WeoIrdR18-I/AAAAAAAAC30/rsc7YCa03TINHx2CC05V4JygrFtI_sv8wCLcBGAs/s1600/Capture%2Bdu%2B2017-10-20%2B15-24-24.png>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Check out the vibrant tech community on one of the world's most
>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>>> _______________________________________________
>>> Mifos-users mailing list
>>> mifos...@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>
>>>
>>
>>
>> --
>> Regards,
>> GopalaKrishnan P
>> GitHub <http://www.github.com/gkrishnan724> | Blog
>> <http://gkrishnan724.wordpress.com> | FOSS@Amrita
>> <http://foss.amrita.ac.in/>
>>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
