You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@fineract.apache.org by Mexina Daniel <me...@singo.africa> on 2019/09/02 12:36:55 UTC

RE: Help on the error i get

Hello Devs

I have creare a PR https://github.com/apache/fineract/pull/631

Kindly help me to check can could cause the join of many tables.

Thanks in advance.
Best Regards

> On July 31, 2019 at 5:45 PM hu6mhg+1kbb1ne8d2x7pdjio1ogbn8i@guerrillamail.com wrote:
> 
> 
> Your problem is: „Too many tables; MySQL can only use 61 tables in a join“ (http://bit.ly/61TblLmt). There's a join that uses sixty-nine tables (t69):
> 
> „...t69.total_pending_shares, t67.unit_price, t67.status_enum, t67.total_shares, t67.transaction_date, t67.type_enum FROM m_account_transfer_transaction t0 INNER JOIN m_account_transfer_details t1 ON t0.account_transfer_details_id = t1.id...“
> 
> You might want to look at either o.a.f.p.l.s.LoanWritePlatformServiceJpaRepositoryImpl.undoLoanDisbursal or o.a.f.p.a.s.AccountTransfersWritePlatformServiceImpl.reverseAllTransactions.
> 
> 
> 
> 
> 
> ----
> Sent using Guerrillamail.com
> Block or report abuse: https://www.guerrillamail.com//abuse/?a=RURiJQsJTbEHiQ2gvn8PcxfPSISfwNA%3D
> 
>

Mexina Daniel


Singo Africa Limited

Mbezi Beach "B"  | Mwai Kibaki Road | 6 Wasafi Str.
P.O BOX 78908 | 14121 Dar es salaam

+255 71 211 0791 | +255 22 261 8511

amala.co.tz | singo.africa