Articles - Joomla Web Development Articles

User Rating: / 0
PoorBest 

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\mysql.dbi.lib.php on line 175

XAMPP apps versions

XAMPP version 1.7.7
+ Apache 2.2.21
+ MySQL 5.5.16 (Community Server)
+ PHP 5.3.8 (VC9 X86 32bit thread safe) + PEAR
+ XAMPP Control Panel Version 2.5 from www.nat32.com

1. Find in C:\xampp\php\php.ini below line / setting and change the 30 to a higher value as needed and required:
   
   max_execution_time = 30
2. Find the line in C:\xampp\phpMyAdmin\config.inc.php, or C:\xampp\phpMyAdmin\config-inc.php, and change setting / value as required: 
   
   $cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
   
   If config-inc.php file is missing the above line or missing altogether then the file config.default.php in C:\xampp\phpMyAdmin\libraries folder is used, edit value in below block
   
   /** 
   * maximum execution time in seconds (0 for no limit)
   * 
   * @global integer $cfg['ExecTimeLimit']
   */ 
   $cfg['ExecTimeLimit'] = 300;
   
   
3. Try also adjusting maximum execution time in C:\xampp\apache\bin\php.ini 
   
   ini_set('max_execution_time', 0)
   
   
4. Create your own php.ini and put the first line below and save it and put the file in your root folder of your application: max_execution_time=0

Use and apply above setting changes if managing your own server. Increasing the max exec time for loading and running scripts more than the usual, required time increases the risks of running malicious codes and scripts.