Reports not returning results for custom modules

👨‍💻 Development Help
1

Hi,
I have created some custom modules but when I select them in reports without any conditions I get zero results returned

Any ideas?

Thanks

2

Can you please show the edit view of this report?

3

I am experiencing a similar issue but i have some additional info.
First i have a few custom modules and a few reports that work like a charm with admin.
If i try to run the same report with a regular user i get no results.
Also when i check the crm log i got this:

Thu Dec 15 10:50:11 2016 [49638][e6c6bf1e-7a49-b81f-fbbb-57ea3e337b35][FATAL]  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 MariaDB server version for the right syntax to use near ') as n' at line 1
Thu Dec 15 10:50:11 2016 [49638][e6c6bf1e-7a49-b81f-fbbb-57ea3e337b35][FATAL]  Query Failed:  LIMIT 0,50: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0,50' at line 1

If the regular user switched to System Administrator User then it works again. :blink:

4

I solved it.
I did a “Repair Roles” and set the appropriate persmissions on the “Role Management”

5

Edit view attached