SuiteCRM API V8 Query error

ckangwei · 19 October 2023 05:54

For anyone facing the same issue.

This still happen in SuiteCRM 7.13.3

Issue and suggested fixes is reported below

github.com/salesagility/SuiteCRM

API V8 getRecords error when disable_count_query is true

opened 05:54AM - 19 Oct 23 UTC

ckangwei83

#### Issue API return DB error and further check in log file, getting error as …below in suitecrm.log 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 '-98' at line 7 #### Expected Behavior When $sugar_config['disable_count_query'] = true, API should return the result without issue. #### Possible Fix Change the default limit to -99 in API BeanManager resolve the issue. ``` /* File: /Api/V8/BeanDecorator/BeanManager.php Line: 10 */ const DEFAULT_LIMIT = -99; ``` #### Steps to Reproduce 1. Configure $sugar_config['disable_count_query'] = true in config_override.php 2. Make an API call to V8. Eg. {{suitecrm.url}}/Api/V8/module/Account #### Context We are dealing with millions of data and to optimize the interface response time, we are disable the count query as advise in CRM doc but that is causing the API to fail #### Your Environment SuiteCRM 7.13.3