Francis Guchie created FINERACT-1054:
----------------------------------------
Summary: 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.5.0
Reporter: Francis Guchie
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)
