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_cstm
ON
project: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' OR
project.status = 'In_Projgress' OR
project.status = 'Billing' OR
project.status = 'Invoiced') ) AND project.deleted = 0 ) GROUP BY
project.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: 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
projectLEFT JOIN project_ptt_project_hours_1_c
project|project:project_ptt_project_hours_1ON
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_cstm
ON
project: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' OR
project.status = 'In_Projgress' OR
project.status = 'Billing' OR
project.status = 'Invoiced') ) AND project.deleted = 0 ) GROUP BY
project.name,
project.id,
project:project_ptt_project_hours_1_cstm.labor_type_c ORDER BY
project.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 (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
projectLEFT JOIN project_ptt_project_hours_1_c
project|project:project_ptt_project_hours_1ON
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