[
https://issues.apache.org/jira/browse/FINERACT-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17148179#comment-17148179
]
Francis Guchie commented on FINERACT-1054:
------------------------------------------
[~vorburger] thank you for this observation. I have edited
And Yes i am using https://github.com/apache/fineract i forked it here
https://github.com/francisguchie/fineract
what i do every 2-3 days is pull the develop branch to keep my fork up to-date
and then i build a war file and use it on 2 computers for testing ( on a
windows Server OS and Ubuntu 18.04 Lts) both on cloud
SQL- Yes i do know how to write SQL and i can interpret errors with some good
level of ease.
PRs - I have made a few PRs on the UI and fineract before but i must admit am a
beginner at raising PRs nevertheless i am deeply happy to contribute to this
great and mighty Mifos
THE CODE
org.apache.fineract.portfolio.loanaccount.service.LoanReadPlatformServiceImpl.RepaymentTransactionTemplateMapper.schema()
I have already picked out the SQL and i thought someone was working on but if
no one is and if this is the only SQL without the "full_group_by", then i will
get it sorted out soon and raise a PR
> 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
>
> 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)
