Query Limit Error - Only Non-Admin Users

[Justinb]

We are using a fresh install of CE 5.2 and only have 100 leads and bout 250 call activies in our database. We only have three users (two admin and one non-admin). When attempting to close a call from anywhere in the system our non-admin users will always receive the following error (even though the call is actually closed successfully):

"Query limit of 1000 reached for calls module"

None of our admin users encounter this problem under any circumstance. So knowing this we switched our non-admin user to an admin user and attempted to close a call again. This time there was no error and the call closes successfully. We immediately switched this user back to non-admin status and retried closing a call and the same error came back.

We are aware that we can increase the default query limit in the config.php file to a larger number, but do not believe this should be necessary since it seems to only affect non-admin users. Because of this we believe that there must be some type of difference between non-admin and admin users that will cause the query limit to be reached.

Has anyone encountered this issue? Does anyone know a fix for it? Does anyone know why this would only occur for non-admin users?

We also have set our list view and subpanel to a limit of 25 and 5 respectively, as a previous thread on this issue suggested but did not notice any difference.

Here are our system specs as suggested:

OS - RHEL 5.2 i386
Sugar Version - 5.2 CE
Server type - Apache 2.2.3
PHP Version - 5.2.5
MySQL server version - 5.0.37

Please anyone help us out! We are surpirsed to not see anyone else reporting this issue recently and are hoping we are just missing something simple.

[breddy]

maybe there is an acl (access control list) restriction for the db users or roles that sets a query limit,
and specifies that the admin account/role is exempt ?

just a theory

[Justinb]

Thanks Breddry, that could be pointing to the direction of the issue. But I am hoping that someone with a bit more technical experience in this area would be able to confirm that?

We've tried a couple instances of Sugar CE and have always encountered the same problem with the query limits for different modules and I am surprised that there aren't more mentions of this in the forums. I mean this is a big problem for us and we are only trying to do very limited things within sugar.

Someone please help us get around this query limit issue for non-admin users!

[eggsurplus]

I believe we had the same error when saving calls and just turned off update_vcal. Open modules\Calls\Call.php and set the following variable to false:

 var $update_vcal = false; 
  

[mikesolomon]

In config.php query limits are set up

There is a default limit & a special query limit

You can alter then in the config file & add additional modules into the special array

array (
'special_query_limit' => 50000,
'special_query_modules' =>
array (
0 => 'Reports',
1 => 'Export',
2 => 'Import',
3 => 'Administration',
4 => 'Sync',
5 => 'Calendar',
),
'default_limit' => 1000,
),

[Justinb]

Thank you Mike and Eggsurplus, we will have a look at both of those options and will report back on Monday how it worked out.

Anybody know what a good value to use for the query limits are? What value does everyone use for their default query limit?

Thanks again! The professionals on this forum are great!

[mikesolomon]

Thank you Mike and Eggsurplus, we will have a look at both of those options and will report back on Monday how it worked out.

Anybody know what a good value to use for the query limits are? What value does everyone use for their default query limit?

Thanks again! The professionals on this forum are great!

I have query limit set @ 5000 and spical @ 120000

[jsaints]

Running sugarcrm 5.2 and I am seeing "Query limit of 1000 reached for Calendar module."

I have in Calls.php

 var $update_vcal = false; 
  

I also ran Repair and Rebuild and commented out all references to vcal in Calendar.php.

VCAL is still an issue. Is there a way to disable vcal for all modules? Or is there another place I am missing here.

Setting in config.php

 'default_limit' => 1000, 
  

to

 'default_limit' => 5000, 
  

fixed the problem for now, but this will break again when my users add enough calls.

I need a way to disable vcal far all modules. Any ideas?

[jcb23]

In config.php query limits are set up

There is a default limit & a special query limit

You can alter then in the config file & add additional modules into the special array

array (
'special_query_limit' => 50000,
'special_query_modules' =>
array (
0 => 'Reports',
1 => 'Export',
2 => 'Import',
3 => 'Administration',
4 => 'Sync',
5 => 'Calendar',
),
'default_limit' => 1000,
),

I was having this same problem and was able to fix it so that 'default_limit' => 50000, instead of 1000. It appears to fix the query limit error in all of the modules.

jcb23

[Geno]

I need a way to disable vcal far all modules. Any ideas?

You can disable VCAL altogether via Admin > System Settings > VCAL Updates Time Period = '0'

This link will provide more details on this issue:

http://developers.sugarcrm.com/wordp...tting-in-520c/

Thanks,
Geno