Hello @Marty42
This is precisely the same issue and the fix is the same.
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
Replace
$final_query = ‘(’ . $tmp_final_query . ‘)’;
With
$final_query = $tmp_final_query ;
AND on line number 930
comment out:
$query = '(' . $query . ')';
Both changes are required to fix this issue.
The $final_query variable is used further in the code.
I hope this is helpful.
Thanks.