SuiteCRM Scheduled reports issue

Hi All,

We are on SuiteCRM Version 7.7.6 . We have few reports which are scheduled(Using scheduled reports) to trigger emails on weekly basis.

There’s as an issue which raised all of sudden…

The reports are sending data which is present in the report to respective emails ids as per the scheduled time and date.

Now the issue is the report is sending empty data even though data is present in the report , but scheduled report is getting triggered on correct scheduled time and date, the only issue is the sent report on the mail is empty

Below is the screenshot of the empty data which we receive on the email

Below is the screenshot of the report which is having data on the crm

And nothing has been changed with respect to reports or scheduled reports , but this things used to wrok as expected before lastweek…

There are no errors on the apache or php logs ,

But when wrote few debug logs , I can see this below error on the suitecrm log

Query Failed: SELECT count(*) c FROM () as n: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) as n’ at line 1 suitecrm

Which I believe triggering from the function build_report_html at modules/AOR_Reports/AOR_Report.php… But no recent changes made to this file too by anyone…

Unable to figure out whats the issue causing to send the empty data on the email even though the report has data on the crm… Kindly please guide me


Hello Team,

Can anyone please advice… its an critical issue we are facing in.


I don’t have many ideas to suggest to you. Can you set up XDEBUG and hook up and IDE and debug through the code?