[jira] [Assigned] (FINERACT-1054) Error at Loan Repayments

["Michael Vorburger (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FINERACT-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Vorburger reassigned FINERACT-1054:
-------------------------------------------

    Assignee: Francis Guchie

> Error at Loan Repayments
> ------------------------
>
>                 Key: FINERACT-1054
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1054
>             Project: Apache Fineract
>          Issue Type: Bug
>          Components: Loan
>    Affects Versions: 1.4.0
>            Reporter: Francis Guchie
>            Assignee: Francis Guchie
>            Priority: Critical
>              Labels: beginner
>             Fix For: 1.4.0
>
>
> GET https://<server>/fineract-provider/api/v1/loans/3/transactions/template?command=repayment
>     	
>     timestamp	1592952834187
>     status	500
>     error	"Internal Server Error"
>     message	"PreparedStatementCallback; bad SQL grammar [select if(max(tr.transaction_date)>ls.dueDate,max(tr.transaction_date),ls.dueDate) as transactionDate,ls.principal_amount - IFNULL(ls.principal_writtenoff_derived,0) - IFNULL(ls.principal_completed_derived,0) as principalDue,ls.interest_amount - IFNULL(ls.interest_completed_derived,0) - IFNULL(ls.interest_waived_derived,0) - IFNULL(ls.interest_writtenoff_derived,0) as interestDue,ls.fee_charges_amount - IFNULL(ls.fee_charges_completed_derived,0) - IFNULL(ls.fee_c…N ls.loan_id = l.id AND ls.completed_derived = 0 join( (select min(ls.duedate) datedue,ls.loan_id from m_loan_repayment_schedule ls where ls.loan_id = ? and ls.completed_derived = 0) )asq on asq.loan_id = ls.loan_id and asq.datedue = ls.duedate where l.id =?]; nested exception is java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'fineract_default.ls.principal_amount'; this is incompatible with sql_mode=only_full_group_by"
>     path	"/fineract-provider/api/v1/loans/3/transactions/template"



--
This message was sent by Atlassian Jira
(v8.3.4#803005)