Use Basic SearchError: Query limit of 20000 reached for Home module.

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Hi all,

I get this occasionally, any suggestions on a cause / fix.

Version 7.8.17
Sugar Version 6.5.25 (Build 344)

A reboot fixes it.

Thanks for your help

Julian

#2

You’ll find many pages discussing this, with a simple solution

https://suitecrm.com/suitecrm/forum/advanced-opensales-workflow-portal-support/17065-error-query-limit-of-1000-reached-for-home-module

But I wonder if your database is in need of some cleaning up… is it an old install? Do you have a lot of data?

#3

Im getting same error. Are there any DB clean up tools available for the light dev. :rofl:

I’m already set set to this :

array (
‘special_query_limit’ => 50000,
‘special_query_modules’ =>
array (
0 => ‘Reports’,
1 => ‘Export’,
2 => ‘Import’,
3 => ‘Administration’,
4 => ‘Sync’,
),
‘default_limit’ => 20000,
),
:grimacing:

#4

You can start by running the query at the top of this post:

It tells a lot about where your problems might be coming from.

1 Like