Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

WAMPServer phpMyadmin Maximum execution time of 360 seconds exceeded

I just installed WampServer. It works when I visit my project page but when I try to navigate phpMyAdmin i get this error:

Maximum execution time of 360 seconds exceeded

What is the problem?

like image 306
Kvasir Avatar asked Apr 28 '15 10:04

Kvasir


People also ask

How do you fix maximum execution time of 60 seconds exceeded?

Look for : $cfg['ExecTimeLimit'] = 600; You can change '600' to any higher value, like '6000'. Maximum execution time in seconds is (0 for no limit). This will fix your error.

How can you increase the maximum execution time of a script in PHP?

To increase the script execution time, you can use the following snippet at the top of your script. ini_set ( 'max_execution_time' , '300' ); In the above example, it would set the max_execution_time directive to 300 seconds.


2 Answers

A better solution here is to change the config that controls phpMyAdmin and not the php.ini file.

If you change the php.ini file you effect everything in PHP and should you write that infinite loop that we all do from time to time it will take longer to terminate your infinite loop than is sensible.

Note: If you are using the 64bit WAMPServer the base folder name will be wamp64 instead of wamp so please amend the below folder names accordingly.

So change \wamp\alias\phpmyadmin.conf. By default it will look something like this although your version of phpMyAdmin will probably be different:

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/"  <Directory "c:/wamp/apps/phpmyadmin4.1.14/">    Options Indexes FollowSymLinks MultiViews    AllowOverride all   <IfDefine APACHE24>     Require local   </IfDefine>   <IfDefine !APACHE24>     Order Deny,Allow       Deny from all       Allow from localhost ::1 127.0.0.1     </IfDefine>   php_admin_value upload_max_filesize 128M   php_admin_value post_max_size 128M   php_admin_value max_execution_time 360   php_admin_value max_input_time 360 </Directory> 

To extend the maximum time limit for importing a database, change the php_admin_value max_execution_time parameter. You may also need to change the other parameters as larger databases tend to come in larger files and take longer to read as well. Example:

  php_admin_value upload_max_filesize 1024M   php_admin_value post_max_size 1024M   php_admin_value max_execution_time 1800   php_admin_value max_input_time 1800 

Don't forget to restart Apache after making changes to this file.

like image 132
RiggsFolly Avatar answered Sep 19 '22 19:09

RiggsFolly


In your php/php.ini change max_execution_time = 360 to 99999.

OR

You can add ini_set('max_execution_time', 600); //600 seconds = 10 minutes line on top of your php file.

See, if that works.

like image 20
Gaurav Dave Avatar answered Sep 19 '22 19:09

Gaurav Dave