fineract-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ed Cable <edca...@mifos.org>
Subject Re: [Mifos-users] Problem with client loan data
Date Mon, 13 Nov 2017 14:10:17 GMT
Adding the Apache Fineract User Mailing list so this thread can take place
there too.

Ed

On Fri, Oct 27, 2017 at 3:30 AM, hamza smaiti <hamza.smaiti@gmail.com>
wrote:

> 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
>
>


-- 
*Ed Cable*
President/CEO, Mifos Initiative
edcable@mifos.org | Skype: edcable | Mobile: +1.484.477.8649

*Collectively Creating a World of 3 Billion Maries | *http://mifos.org
<http://facebook.com/mifos>  <http://www.twitter.com/mifos>

Mime
View raw message