Thread Details
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 367 subscribers
  • Views 122 views
  • Users 0 members are here
Forum Actions

user gets 500 error on all modules due to broken query, How do I debug?

Francesca Shiekh

I already opened a case but thought I would see if any ideas come here since I don't have a resolution yet.

I have a single user who can log in but gets a 500 error on every dashboard and module, list views and record views....

She basically can't use Sugar at all.

The fatal error is:

Fullscreen
1
2
3
4
5
[FATAL] An exception occurred while executing a query:
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 '' at line 1;
Query: SELECT id, first_name, last_name, user_name FROM users WHERE status = ? AND portal_only=0 ORDER BY ; Params: array (
0 => 'Active',
)
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Which is clearly missing the Order by clause parameter

The user used to be Admin, we changed from Admin to Regular User and added a Role many others have to deny access to two modules.
That seems to be when her access broke.

I tried: removing the access denial Role.

Removing both roles and re-adding one by one.

I repaired Teams and Roles, did a QRR, checked that a new user with the same credentials can access things.

Her account in TST also works fine with the same changes, it's just Production that broke.

From the console. can see that the errors are all on Dashboard APIs:

Fullscreen
1
2
3
4
5
6
7
sugarcrm/rest/v11_24/Dashboards/?fields=&max_num=-1&filter%5B0%5D%5Bdashboard_module%5D=Contacts&filter%5B0%5D%5B%24or%5D%5B0%5D%5B%24favorite%5D=&filter%5B0%5D%5B%24or%5D%5B1%5D%5Bdefault_dashboard%5D=1&filter%5B1%5D%5Bview_name%5D=records
sugarcrm/rest/v11_24/Dashboards/5a3068f4-e494-11e8-89ea-001a4a160206?fields=&max_num=-1&filter%5B0%5D%5Bdashboard_module%5D=Leads&filter%5B0%5D%5B%24or%5D%5B0%5D%5B%24favorite%5D=&filter%5B0%5D%5B%24or%5D%5B1%5D%5Bdefault_dashboard%5D=1&filter%5B1%5D%5Bview_name%5D=records
sugarcrm/rest/v11_24/Dashboards/5a28bfaa-e494-11e8-805f-001a4a160206?fields=&max_num=-1&filter%5B0%5D%5Bdashboard_module%5D=Accounts&filter%5B0%5D%5B%24or%5D%5B0%5D%5B%24favorite%5D=&filter%5B0%5D%5B%24or%5D%5B1%5D%5Bdefault_dashboard%5D=1&filter%5B1%5D%5Bview_name%5D=records
sugarcrm/rest/v11_24/Dashboards/5a27818a-e494-11e8-afcd-001a4a160206?fields=&max_num=-1&filter%5B0%5D%5Bdashboard_module%5D=Contacts&filter%5B0%5D%5B%24or%5D%5B0%5D%5B%24favorite%5D=&filter%5B0%5D%5B%24or%5D%5B1%5D%5Bdefault_dashboard%5D=1&filter%5B1%5D%5Bview_name%5D=records
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

I appreciate any ideas you may have

Thanks

FrancescaS