API V8 getRecords error when disable_count_query is true #5117

New issue

Open

opened 2026-02-20 16:29:55 -05:00 by deekerman · 1 comment

deekerman commented

2026-02-20 16:29:55 -05:00

Owner

Originally created by @ckangwei83 on GitHub (Oct 19, 2023).

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

Configure $sugar_config['disable_count_query'] = true in config_override.php
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

Originally created by @ckangwei83 on GitHub (Oct 19, 2023). #### 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

deekerman added the

Type: Bug

Priority:Important

Area: API

labels

2026-02-20 16:29:55 -05:00

deekerman commented

2026-02-20 16:29:56 -05:00

Author

Owner

@SuiteBot commented on GitHub (Oct 19, 2023):

This issue has been mentioned on SuiteCRM. There might be relevant details there:

https://community.suitecrm.com/t/suitecrm-api-v8-query-error/75706/3

@SuiteBot commented on GitHub (Oct 19, 2023): This issue has been mentioned on **SuiteCRM**. There might be relevant details there: https://community.suitecrm.com/t/suitecrm-api-v8-query-error/75706/3