Project task causes database failure citing unknown table 'project_task' in SuiteCRM 8.5.0

[reggieeuser]

NOTE: This is a transfer of issue #10324 previously posted to the wrong place.

After creating a Project Template with one or more Tasks, when one then creates a Project it spawns a "Database failure" message under "Project Tasks". This also occurs if a Project is created without specifying a Project Template, then attempting to create a task.

SuiteCRM log shows:

Sun Jan 21 12:41:39 2024 [46076][8e9600ea-8210-9588-678b-65a59de942a4][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='89df78af-fb1d-f077-a94a-65ad46c309c8') AND project_task.deleted=0) ORDER BY project_task.project_task_id asc LIMIT 0,10: MySQL error 1109: Unknown table 'project_task' in order clause

Sun Jan 21 12:41:39 2024 [46076][8e9600ea-8210-9588-678b-65a59de942a4][FATAL] [ListView::processUnionBeans] . Database failure. Please refer to suitecrm.log for details.

What should happen is that a list of tasks is displayed; what happens is the Database failure message.

Repairing the database doesn't cure the problem. The project_task table is present in the database.

SuiteCRM 8.5.0
Firefox 121.0.1/Chromium Version 120.0.6099.224
mysql Ver 8.0.35-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
PHP 8.1.27
Ubuntu 22.04

Thanks.

[reggieeuser]

On the off chance that my comment above about transferring this post from another thread suggested that the issue had been solved there, let me clarify that it had not.

Any thoughts, suggestions, ideas about how to cure this problem will be gratefully accepted!

Thanks!

[chris001]

I you can, you should set the status of the issue which was posted by mistake in 7.x repo salesagility/SuiteCRM#10324 as "Closed (duplicate)", not "Closed Fixed".