Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1054

Error at Loan Repayments

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.4.0
    • Component/s: Loan
    • Labels:
    • Flags:
      Important

      Description

      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"

        Attachments

          Activity

            People

            • Assignee:
              francisguchie Francis Guchie
              Reporter:
              francisguchie Francis Guchie
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: