Error retrieving Project list: Query Failed: #10515
Labels
Area: Databases
Issues & PRs related to all things regarding databases
Status:Requires Updates
Issues & PRs which requires input or update from the author
Status: Stale
For issues & PRs that have had no activity
Type: Bug
Bugs within the core SuiteCRM codebase
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
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
The text was updated successfully, but these errors were encountered: