issue with the reporting plugin, MySQ: SQL syntax error

Here my debug log: see attachment:

You see the two mistakes? How can I fix this?

Thank you very much?

reporting plugin? which one? you need to provide your SuiteCRM verions, server version, etc.

best regards


That was fast,

Version 7.6.5

Sugar Version 6.5.23 (Build 1061)

Module: RT_Report, reporting plugin 1.0.1

Thank you, but I think, that is not importent.

I now, it was the wrong SQL query, the system from the reporting forget some id’s.


the mistake is:
LEFT JOIN opportunities rt1 ON rt1. = rt0. AND

well, I don’t know that plugin and to be honest I don’t think that SuiteCRM devs will give support for 3rd party addons, why don’t you use the Reports module that is embedded in the SuiteCRM system?

best regards

1 Like

I have found a solution, Thank you