Install SuiteCRM. I finish the installation, log in for the first time, go to “project module” and view the “project → project tasks” that came with demo data, I get this error “Database failure. Please refer to suitecrm.log for details.”
Fresh install (formated disk)
Ubuntu 22.04
SuiteCRM 7.13.1
php 8.0
MySQL 8.0
------ suitecrm.log when ------
Mon Feb 20 12:48:56 2023 [844][1][FATAL] Mysqli_query failed.
Mon Feb 20 12:48:56 2023 [844][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='84ec12a7-a9ef-1f19-d001-63f36c58a389') 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 12:48:56 2023 [844][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
Mon Feb 20 12:58:02 2023 [1183][1][FATAL] Mysqli_query failed.
Mon Feb 20 12:58:02 2023 [1183][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='84ec12a7-a9ef-1f19-d001-63f36c58a389') 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 12:58:02 2023 [1183][1][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.
------ end suitecrm.log ------
.
.
