Error retrieving Project list: Query Failed:

[puchongtv]

Issue

Opening "Project Overview" page, it failed to display Project Task list.

Following error are recorded in SuiteCRM log:

[215742][1][FATAL] Error retrieving Project list: Query Failed: (SELECT project_task.id , project_task.name , project_task.date_start , project_task.date_finish , project_task.assigned_user_id , 'projecttask' panel_name FROM project_task INNER JOIN project projecttask_rel ON project_task.project_id=projecttask_rel.id AND projecttask_rel.deleted=0

Possible Fix

Remove '(' . and . ')' on line 891, 892, 946, 4137, 4138 in /public/legacy/data/SugarBean.php

example Line 891, 892
$final_query_rows = '(' . $parentbean->create_list_count_query($tmp_final_query, $parameters) . ')';
$final_query = '(' . $tmp_final_query . ')';
$first = false;

Steps to Reproduce the Issue

1.fresh install of SuiteCRM 8.6.2, PHP8.2, Mysql 8.0.39
2.logged in SuiteCRM as Admin
3.Create a new Projet
4.Create a Project Task
5.From "Projects" pull-down menu, select "View Project List"
6.Click the Project name in Project List.
7.Error message appears below "Project Tasks" pane. Project task list are not displayed and asked to view SuiteCRM log

Context

No response

Version

8.6.2

What browser are you currently using?

Chrome

Browser Version

Chrome Version 128.0.6613.120

Environment Information

MySQL 8.0.39, PHP 8.2

Operating System and Version

Ubuntu 24.04

[chris001]

Would this bug be fixed by this PR:
#9843

[chris001]

@puchongtv
The error shouldn't happen on newer version of MySQL than your 8.0.39, it is reported a bug in MySQL causes this error, see here for test results on newer MySQL versions: #9843 (comment)

Would you be able to upgrade your MySQL to 8.1, 8.2, 8.3, or 8.4 LTS, then go to Open "Project Overview" page, observe if it failed to display Project Task list, or if it succeeds to display Project Task list, and post back your results here?