Project Hours Report Fails to Run

Environment: Cloud Hosted Linux 7.1 Kernel 3.10.0-229.el7, MySQL 5.5.48, PHP 5.5.32, SuiteCRM migrated over time from 6.5 to 7.8.2

I have a very simple report that ran through version 7.7.9 with minor tweaks to the AOR_Report.PHP for reporting issues. Now the report is giving me Fatal MySQL Errors.

There is 1 custom relationship created through Studio: Projects - One to Many - PTT_Project_Hours. I can scap the report and relationships if needed.

The report has been deleted and recreated several times with Quick Repair and Rebuild along with Rebuild Relationships done each time.

Any suggestions or pointers would be great. Thanks. :huh:

Since I can’t add the txt file I’ll past it here (sorry):

Thu Apr 13 08:38:15 2017 [20929][1][FATAL] Query Failed: SELECT count(*) c FROM (SELECT project.id AS ‘project_id’, project.name AS ‘Name0’, project:project_ptt_project_hours_1_cstm.labor_type_c AS ‘labor_type1’, SUM(project:project_ptt_project_hours_1.labor_hours) AS ‘Labor_Hours2’ FROM project LEFT JOIN project_ptt_project_hours_1_c project|project:project_ptt_project_hours_1 ON project.id=project|project:project_ptt_project_hours_1.project_ptt_project_hours_1project_ida AND project|project:project_ptt_project_hours_1.deleted=0

LEFT JOIN ptt_project_hours project:project_ptt_project_hours_1 ON project:project_ptt_project_hours_1.id=project|project:project_ptt_project_hours_1.project_ptt_project_hours_1ptt_project_hours_idb AND project:project_ptt_project_hours_1.deleted=0
LEFT JOIN ```project:project_ptt_project_hours_1``_cstmproject:project_ptt_project_hours_1_cstmONproject:project_ptt_project_hours_1.id =project:project_ptt_project_hours_1_cstm.id_c WHERE (project.name = 'Element / Burl Oaks Office Wiring' AND ( (project.assigned_user_id = '822dfefa-2e9c-7af2-2ca0-52f2dbc32305') AND (project.status = 'Not_Started' ORproject.status = 'In_Projgress' ORproject.status = 'Billing' ORproject.status = 'Invoiced') ) AND project.deleted = 0 ) GROUP BYproject.name,project.id,project:project_ptt_project_hours_1_cstm.labor_type_c ) as n: MySQL error 1146: Table 'sugarcrm.project:project_ptt_project_hours_1_cstm' doesn't exist Thu Apr 13 08:38:15 2017 [20929][1][FATAL] Query Failed: SELECTproject.id AS 'project_id',project.name AS 'Name0',project:project_ptt_project_hours_1_cstm.labor_type_c AS 'labor_type1', SUM(project:project_ptt_project_hours_1.labor_hours) AS 'Labor_Hours2' FROMprojectLEFT JOIN project_ptt_project_hours_1_cproject|project:project_ptt_project_hours_1ONproject.id=project|project:project_ptt_project_hours_1.project_ptt_project_hours_1project_ida ANDproject|project:project_ptt_project_hours_1`.deleted=0

LEFT JOIN ptt_project_hours project:project_ptt_project_hours_1 ON project:project_ptt_project_hours_1.id=project|project:project_ptt_project_hours_1.project_ptt_project_hours_1ptt_project_hours_idb AND project:project_ptt_project_hours_1.deleted=0
LEFT JOIN ```project:project_ptt_project_hours_1``_cstmproject:project_ptt_project_hours_1_cstmONproject:project_ptt_project_hours_1.id =project:project_ptt_project_hours_1_cstm.id_c WHERE (project.name = 'Element / Burl Oaks Office Wiring' AND ( (project.assigned_user_id = '822dfefa-2e9c-7af2-2ca0-52f2dbc32305') AND (project.status = 'Not_Started' ORproject.status = 'In_Projgress' ORproject.status = 'Billing' ORproject.status = 'Invoiced') ) AND project.deleted = 0 ) GROUP BYproject.name,project.id,project:project_ptt_project_hours_1_cstm.labor_type_c ORDER BYproject.name ASC LIMIT 0,200: MySQL error 1146: Table 'sugarcrm.project:project_ptt_project_hours_1_cstm' doesn't exist Thu Apr 13 08:38:15 2017 [20929][1][FATAL] Query Failed: SELECT count(*) c FROM (SELECTproject.id AS 'project_id',project.name AS 'Name0',project:project_ptt_project_hours_1_cstm.labor_type_c AS 'labor_type1', SUM(project:project_ptt_project_hours_1.labor_hours) AS 'Labor_Hours2' FROMprojectLEFT JOIN project_ptt_project_hours_1_cproject|project:project_ptt_project_hours_1ONproject.id=project|project:project_ptt_project_hours_1.project_ptt_project_hours_1project_ida ANDproject|project:project_ptt_project_hours_1`.deleted=0