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

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


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

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?

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,

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