Project tasks do now show in project

SuiteCRM Forum - English Language
1

Log in for the fist time, go to projects and select the project (demo data) and view the Porject Task. It returns error “Database failure. Please refer to suitecrm.log for details.”

Any help would be apreciated.

Fresh install (formated disk)
Ubuntu 22.04
SuiteCRM 8.0.4
php 8.0
MySQL 8.0

sutecrm.log

Mon Feb 20 09:27:26 2023 [39683][1][FATAL] User update error: Temp User is not retrieved at ID 1, boolean given
Mon Feb 20 09:27:26 2023 [39683][1][FATAL] Email address save error
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] User update error: Temp User is not retrieved at ID seed_jim_id, boolean given
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] Email address save error
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] User update error: Temp User is not retrieved at ID seed_sarah_id, boolean given
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] Email address save error
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] User update error: Temp User is not retrieved at ID seed_sally_id, boolean given
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] Email address save error
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] User update error: Temp User is not retrieved at ID seed_max_id, boolean given
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] Email address save error
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] User update error: Temp User is not retrieved at ID seed_will_id, boolean given
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] Email address save error
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] User update error: Temp User is not retrieved at ID seed_chris_id, boolean given
Mon Feb 20 09:27:32 2023 [39683][1][FATAL] Email address save error
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Setting logger_file_name to ''.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Invalid ext  logger_file_ext : ''.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Setting logger_file_ext to ''.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Log file extension can't be blank.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Log file extension can't be blank.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Setting logger_file_name to ''.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Invalid ext  logger_file_ext : ''.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Setting logger_file_ext to ''.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Log file extension can't be blank.
Mon Feb 20 09:28:01 2023 [39683][1][SECURITY] Log file extension can't be blank.
Mon Feb 20 09:29:25 2023 [39682][1][FATAL] Error: File [modules/SavedSearch/metadata/editviewdefs.php] is missing. Unable to create because no corresponding HTML file was found.
Mon Feb 20 09:29:28 2023 [39679][1][FATAL] Mysqli_query failed.
Mon Feb 20 09:29:28 2023 [39679][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

  where ( project_task.project_id='1b8732a7-a9ef-1f19-d001-63f33d58a389') AND project_task.deleted=0) ORDER BY project_task.project_task_id asc LIMIT 0,10: MySQL error 1250: Table 'project_task' from one of the SELECTs cannot be used in global ORDER clause
Mon Feb 20 09:29:28 2023 [39679][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Mon Feb 20 09:30:28 2023 [39700][1][FATAL] Mysqli_query failed.
Mon Feb 20 09:30:28 2023 [39700][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

  where ( project_task.project_id='1b8732a7-a9ef-1f19-d001-63f33d58a389') AND project_task.deleted=0) ORDER BY project_task.project_task_id asc LIMIT 0,10: MySQL error 1250: Table 'project_task' from one of the SELECTs cannot be used in global ORDER clause
Mon Feb 20 09:30:28 2023 [39700][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.

error.log
-empty-

I have also tried on
Fresh install (formated disk)
Ubuntu 22.04
SuiteCRM 8.2.3
php 8.0
MySQL 8.0
… it gives the same error.

2

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;

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.

1 Like