Migration from SuiteCRM 7.14.x to 8.4.1 finished, but does not look OK :(

[OPS-Hesham]

I did change in “data/sugarbean.php” following this reply:

Cannot view Project tasks in Project module [8.2.3] “Database failure. Please refer to suitecrm.log for details.”

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/S…