Hello @OPS-Hesham
This is precisely the same issue and the fix is the same.
Note the error in the subpanel at the bottom of the screenshot.
This issue impacts subpanels in every module as all the subpanels use SugarBean.php when pulling data. Where the user first encounters the error depends on what part of the CRM they use after the MySQL environment on their server is updated.
To fix:
In SuiteCRM/data/SugarBean.php
Comment out lines 876 & 930
Line 876: // $final_query = ‘(’ . $tmp_final_query . ‘)’;
…
Line 930: // $query = ‘(’ . $query . ‘)’;
I hope this is helpful.
Thanks.