Adding the Apache Fineract User Mailing list so this thread can take place there too.
Ed On Fri, Oct 27, 2017 at 3:30 AM, hamza smaiti <[email protected]> wrote: > in the log, i got this message: > > {timestamp: 1509099806863, status: 500, error: "Internal Server Error",…} > > error:"Internal Server Error" > > exception:"org.springframework.jdbc.BadSqlGrammarException" > > > message:"PreparedStatementCallback; bad SQL grammar [select dd.id as > id,dd.expected_disburse_date as expectedDisbursementdate, > dd.disbursedon_date as actualDisbursementdate,dd.principal as > principal,sum(lc.amount) chargeAmount, lc.amount_waived_derived > waivedAmount,group_concat(lc.id) loanChargeId from m_loan l inner join > m_loan_disbursement_detail dd on dd.loan_id = l.id left join > m_loan_tranche_disbursement_charge tdc on tdc.disbursement_detail_id=dd.id > left join m_loan_charge lc on lc.id=tdc.loan_charge_id and lc.is_active=1 > where dd.loan_id=? group by dd.id order by dd.expected_disburse_date]; > nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Expression #6 <https://github.com/openMF/community-app/pull/6> of SELECT > list is not in GROUP BY clause and contains nonaggregated column > 'mifostenant-sav.lc.amount_waived_derived' which is not functionally > dependent on columns in GROUP BY clause; this is incompatible with > sql_mode=only_full_group_by" > > status:500 > timestamp:1509099806863 > > > > > > > > Le mardi 24 octobre 2017 19:24:51 UTC+1, hamza smaiti a écrit : >> >> Hello, >> The connection is working. >> >> I have it working well on another computer, but i think the probleme here >> is some access rights that i didnt' give to somes files, or the deploiement >> of the application on the server. I'm not really sure. >> >> Le samedi 21 octobre 2017 11:05:19 UTC+1, Gopala Krishnan a écrit : >>> >>> Hi, >>> >>> I believe that is because the data is not loaded yet or you might have >>> some internet connection problem. In any case, please do mention the steps >>> to reproduce this so that someone can confirm it if it is a bug. >>> >>> On Fri, Oct 20, 2017 at 8:01 PM, hamza smaiti <[email protected]> >>> wrote: >>> >>>> When i create a new loan for a client, and i want to approuve the loan, >>>> i can't see the menu and the data are all corrupted. >>>> >>>> here is a screenshot of the view: >>>> >>>> >>>> <https://lh3.googleusercontent.com/-DFGVKFpIw3k/WeoIrdR18-I/AAAAAAAAC30/rsc7YCa03TINHx2CC05V4JygrFtI_sv8wCLcBGAs/s1600/Capture%2Bdu%2B2017-10-20%2B15-24-24.png> >>>> >>>> >>>> ------------------------------------------------------------ >>>> ------------------ >>>> Check out the vibrant tech community on one of the world's most >>>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >>>> _______________________________________________ >>>> Mifos-users mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>> >>>> >>> >>> >>> -- >>> Regards, >>> GopalaKrishnan P >>> GitHub <http://www.github.com/gkrishnan724> | Blog >>> <http://gkrishnan724.wordpress.com> | FOSS@Amrita >>> <http://foss.amrita.ac.in/> >>> >> > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > > -- *Ed Cable* President/CEO, Mifos Initiative [email protected] | Skype: edcable | Mobile: +1.484.477.8649 *Collectively Creating a World of 3 Billion Maries | *http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos>
