The cause:
In MySQL 8.0.31 something has been changed so the SQL queries that pull data for subpannels fail. The current code in SuiteCRM adds the outer ( ) to the query. If the outer ( ) is removed from the query, the SQL query will complete normally.
I hope in future releases [>8.2.3] of SuiteCRM this bug is fixed - so that it works on all MySQL 8.0.xx versions.
This fix worked for me
https://github.com/salesagility/SuiteCRM/issues/9788
As pstevens71 wrote:
In file
/public/legacy/data/SugarBean.php
comment out:
$query = '(' . $query . ')';
AND
remove the brackets and quotations:
$final_query = '(' . $tmp_final_query . ')';
to
$final_query = $tmp_final_query;