Thread Details
  • State Verified Answer
  • Replies 28 replies
  • Subscribers 367 subscribers
  • Views 22762 views
  • Users 0 members are here
Forum Actions

How to modify the query limit in Cases?

Roland Cadavos

When i search in Cases and filtered Date Created is equal to 1 day. It gives me this error =>

HTTP: 500 Internal Server Error

Unknown error.

Then i created a file to override the config.php into config_override.php => 

<?php
/***CONFIGURATOR***/
$sugar_config['max_record_fetch_size'] = 2000;

since when i query it to MySQL it gives me 1,300+ rows. But still having the same error.

I then also added

$sugar_config['resource_management']['special_query_modules'][] = 'Cases';
$sugar_config['resource_management']['special_query_limit'] = 0;

still getting the same error.

I did Quick Repair and Rebuild everytime i do changes. Since i cannot do Rebuild Config File because it gives me this error when i click Rebuild => The config.php could not be rebuilt.

Can someone help me get through this?

Afterwards, i would like to fetch a month term query. In my SQL it gives me 45,000+ rows. What is the safe mac value to fetch?

Would this overriding fetch max value can possibly cause a slow performance in CRM?

Thanks in advance.

  • 0

    Hi Longki,

    The special_query_limit configuration value is for situations where loading a page causes more than 1,000 queries to be run. This is different than a query returning over 1,000 results. Since you are getting a 500 error when you try that filter, please check your PHP error log and see if there are any error messages that might help you debug the root cause of this issue. Feel free to share the error message here and I'll try to help you narrow down the root cause. I hope that helps!

    -Alan

  • 0 in reply to Alan Beam

    Its already saturday here in my timezone, i could get back to my computer at the office on monday. Can i ask what file is running when i hit [Select All] from the prompt that says [You have selected all 20 records in this view. Select all records in the result set.] when i tick the checkbox to select all?

  • 0 in reply to Alan Beam

    [Mon Jan 25 02:26:28 2016] [error] [client xxx.xx.xx.xxx] PHP Fatal error:  Maximum execution time of 30 seconds exceeded in ../SugarEnt761/data/SugarBean.php on line 3363,

  • 0 in reply to Roland Cadavos

    Hi Longki,

    I am not sure this is cause of max execution time.Can you try checking/changing value of max_execution_time in your php.ini.

    max_execution_time = 1000

    and restart your apache and check once.

  • 0 in reply to Ajay Kumar

    @ajay: ok ill try.. where can i usually find this file? xD

  • 0 in reply to Roland Cadavos

    Ajay Kumar wrote:

    Hi Longki,

    I am not sure this is cause of max execution time.Can you try checking/changing value of max_execution_time in your php.ini.

    1. max_execution_time = 1000 

    and restart your apache and check once.

    max_execution_time = 0 => 0

  • 0 in reply to Roland Cadavos

    If you are using ubuntu machine,php.ini file path will be in /etc/php5/apache2/php.ini

    To find file path location.

    If ubuntu,

    Create a file "phpinfo.php" in document root directory

    <php
phpinfo();
?>

    and execute this file in browser.There you will be having parameter like "loaded configuration file".Note that path,Then change in there.

  • 0 in reply to Ajay Kumar

    im using putty.. im in my root folder then at /etc i typed php -i
    then i found max_execution_time = 0 => 0

  • 0 in reply to Roland Cadavos

    Ok.what is your operating system? I meant sugar hosted operating system.

  • 0 in reply to Ajay Kumar

    here is the update when i googled to see my php.ini

    [root@server ~]# php -i | grep php.ini

    Configuration File (php.ini) Path => /etc

    Loaded Configuration File => /etc/php.ini

    [root@server ~]# grep -i max_execution /etc/php.ini

    max_execution_time = 30

1 2 3