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
Thanks,
Sravani.Tedla