[
https://issues.apache.org/jira/browse/FINERACT-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17161087#comment-17161087
]
Michael Vorburger commented on FINERACT-1054:
---------------------------------------------
[~francisguchie] FYI I have just granted you Contributur permission on the ASF
JIRA, so now you can assign issues to yourself, and close them.
I'll do it for you for this one, but in the future you can do it yourself: 1.
assign what you are actively working on to yourself, 2. Set Fix Version to
1.4.0, 3. click Start Progress, 4. Resolve when the PR is merged.
> 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
> 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)
