Fatal error: Maximum execution time of 300 seconds exceeded

Question

I keep getting this PHP error:

Fatal error: Maximum execution time of 300 seconds exceeded

I have tried setting my max_execution_time and my max_input_time settings in php.ini (both apache and cli) to 0, -1 and 4000 seconds each.

And i still get the error saying:

Fatal error: Maximum execution time of 300 seconds exceeded

As well my script runs over 300 seconds before i get this message

I am running the script through command line.

I also checked my phpinfo() so see which php.ini I am using.

Even more interesting I have tried setting max_execution_time and max_input_time settings to 5 second and my script will run way beyond 5 seconds before I get the:

Fatal error: Maximum execution time of 300 seconds exceeded

This is so strange i have same issue on apache 2.4.18 and php 7... Using PHPMyAdmin to import sql.. phpinfo(); reports different time.. Will try the ini setting I guess :( — Michael Fever, Feb 25 '16 at 21:29
the same issue, I try to set set_time_limit(3603); ini_set('max_execution_time', 3604); but both have no effect, max execution time still is 360. — Infor Mat, Feb 05 '20 at 14:26

score 106 · Answer 1 · edited Jul 21 '14 at 19:50

106

If you are using WAMP Go to :

Increase the max_execution_time in php.ini then go to

C:\wamp\apps\phpmyadmin3.4.10.1\libraries (change path according to your installation)

open config.default.php and change value for $cfg['ExecTimeLimit'] to 0:

$cfg['ExecTimeLimit'] = 0;

This will resolve the issue for PhpMyAdmin imports.

edited Jul 21 '14 at 19:50

yarl

3,107
1
22
28

answered Jul 04 '13 at 09:33

Vipin Dubey

1,393
3
10
13

@Vipin, you solution helped me, especially that config.default.php ;-) – Rishi Kulshreshtha Feb 18 '14 at 05:16
thank you, after hrs and hrs of frustration trying to upgrade a 500 MB DB to a newer version of moodle......I have success. Specifically moodle 2.2 - 2.6. – jamesTheProgrammer Apr 04 '14 at 20:03
THIS is the answer I've been looking for! – jdstankosky Jun 17 '14 at 11:28
2

Thanks for this answer! Helped out my problem after realizing that setting the max execution time in php.ini wasnt enought! – Rimble Oct 04 '14 at 14:48
1

`config.default.php` is very explicit about not editing it, telling us to edit `config.inc.php` instead. I tried to find it and could not, so I made my own and added ``. This did nothing. I decided to try and do it in `config.default.php` and it worked!! How are we supposed to make the `config.inc.php` work?!? – BillyNair Feb 15 '15 at 09:20
Hi, in WAMP 3.x what I had to do was finding the phpmyadmin.conf file and edit the "max_execution_time" variable there. – Emanuele Ciriachi Nov 15 '17 at 21:41
2

@BillyNair config.inc.php is in the phpmyadmin root directory – Tschallacka Aug 22 '19 at 07:12

Technotronic · Answer 2 · 2022-02-28T12:16:28.587

89

Xampp Users

Go to xampp\phpMyAdmin\
Open config.inc.php
Search for $cfg['ExecTimeLimit'] = 300;
Set a larger value or change to 0 for unlimited
If not found add $cfg['ExecTimeLimit'] = 900; (or 0 for unlimited)
Save the file and restart the server

Important: setting the execution time limit to unlimited is not recommended.

edited Feb 28 '22 at 12:16

answered Jan 10 '14 at 18:21

Technotronic

8,424
4
40
53

10

This is literally the only thing that worked for me. So thanks for posting. In my setup, $cfg['ExecTimeLimit'] = 300; didn't exist in config.inc.php so I added it there rather than changing the value in config.default.php--there is a rather large message stating not to touch the code in that file ;) – Ian Mar 28 '14 at 15:07
6

thanks for highlighting **restart the server**. most important forgettable point. – Pradeep Kumar Jul 01 '15 at 07:14
4

There is a note in the config.default.php file that says "No!! Do Not Edit". I added $cfg['ExecTimeLimit'] = 0; to my config.inc.php file since it didn't exist and it seemed to work. – brandozz Mar 08 '16 at 17:04
1

this post save my day and helped me for second time !!! how can i plus one after 3 month??? – saber tabatabaee yazdi Jan 14 '20 at 17:27

score 76 · Accepted Answer · edited Oct 31 '18 at 19:39

76

At the beginning of your script you can add.

ini_set('MAX_EXECUTION_TIME', '-1');

edited Oct 31 '18 at 19:39

reformed

4,505
11
62
88

answered Oct 06 '11 at 21:23

Tules

4,905
2
27
29

2

add it at the very top of your php file – Tules Oct 06 '11 at 21:24
2

This line of code will drop the max execution time restriction of a code, allowing a php code to run forever (theoretically). – Technotronic May 20 '15 at 13:09
2

in which script? – Sagar Kodte Jan 20 '18 at 07:31
1

Or `set_time_limit(0);` = same. – Íhor Mé Aug 09 '19 at 11:46
What if you're trying to do this within PHPMyAdmin? ?How can you add this to the top of your php file? – Lee Jul 13 '21 at 18:00

score 25 · Answer 4 · answered Apr 17 '13 at 03:50

25

I encountered a similar situation, and it turns out that Codeigniter (the PHP framework I was using) actually sets its own time limit:

In system/core/Codeigniter.php, line 106 in version 2.1.3 the following appears:

if (function_exists("set_time_limit") == TRUE AND @ini_get("safe_mode") == 0)
{
    @set_time_limit(300);
}

As there was no other way to avoid changing the core file, I removed it so as to allow configuration through php.ini, as well as give the infinite maximum execution time for a CLI request.

I recommend recording this change somewhere in the case of future CI version upgrades however.

answered Apr 17 '13 at 03:50

xiankai

2,773
3
25
31

8

OH. MY. GOODNESS. I cannot believe this. Why is the bloody world would they limit execution time on top of all the other limits of execution time that already exist? I have wasted hours on this. Thank you for posting. – fool4jesus Nov 04 '13 at 22:42
1

That's unbelievable. Commented out the line and works! Why would CI overwrite the default PHP default, and not provide documentation on it?! – Phil Cross Apr 14 '14 at 12:24
If you're reading this and you're using ExpressionEngine (which is built on CodeIgniter)... Well - guess what - EE overrides CI's override! You'll need to edit both /system/codeigniter/system/core/Codeigniter.php line 106, AND /system/expressionengine/libraries/Core.php, line 64. That was a fun three hours of my life discovering that... – Jack Mar 04 '15 at 16:27
@PhilCross if you know the function that needs to execute more time, you can use [Jess' suggestion](http://stackoverflow.com/questions/7680572/fatal-error-maximum-execution-time-of-300-seconds-exceeded#comment10645588_7680610) and place `set_time_limit(0);` inside that function. You don't need to change the core: this instruction will reset the time limit, so you don't need to worry about other lines in the core or in other packages while running that specific function. – Armfoot Oct 09 '15 at 16:44

score 12 · Answer 5 · answered Jun 16 '19 at 07:27

For Xampp Users

1. Go to C:\xampp\phpMyAdmin\libraries
2. Open config.default.php
3. Search for $cfg['ExecTimeLimit'] = 300;
4. Change to the Value 300 to 0 or set a larger value
5. Save the file and restart the server
6. OR Set the ini_set('MAX_EXECUTION_TIME', '-1'); at the beginning of your script you can add.

score 10 · Answer 6 · answered Oct 06 '11 at 21:22

10

Try something like the following in your script:

set_time_limit(1200);

answered Oct 06 '11 at 21:22

Darth Egregious

18,184
3
32
54

3

`set_time_limit(0);` makes your script run forever. – Jonathon Oct 06 '11 at 21:39
27

`set_time_limit(0);` _allows_ your script to run forever. – Jess Telford Dec 21 '11 at 00:13

score 9 · Answer 7 · edited Feb 08 '17 at 18:54

9

go to the xampp/phpmyadmin/libraries/config.default.php

and make the following changes

from  $cfg['ExecTimeLimit'] = ’300′;
to  $cfg['ExecTimeLimit'] = ’0′;

edited Feb 08 '17 at 18:54

maazza

7,016
15
63
96

answered Feb 08 '17 at 18:35

Gaurav Arora

121
1
3

score 7 · Answer 8 · edited Oct 09 '13 at 15:57

7

This is the the right answer:

go to

c:\wamp\apps\phpmyadmin3.4.10.1\libraries\config.default.php

find and set

$cfg['ExecTimeLimit'] = 0;

restart all services and done.

edited Oct 09 '13 at 15:57

CRUSADER

5,486
3
28
64

answered Oct 09 '13 at 15:40

llioor

5,804
4
36
44

score 4 · Answer 9 · edited Jan 31 '18 at 01:38

4

For Local AppServ

Go to C:\AppServ\www\phpMyAdmin\libraries\config.default.php

Find $cfg['ExecTimeLimit'] and set value to 0.

So it'll look like

$cfg['ExecTimeLimit'] = 0;

edited Jan 31 '18 at 01:38

davidkonrad

83,997
17
205
265

answered Jan 31 '18 at 01:32

Zunnie Kanittika

41
1

score 3 · Answer 10 · answered Oct 04 '21 at 06:39

3

If xampp in localserver Goto C:\xampp\phpMyAdmin\libraries\config.default.php

//find $cfg['ExecTimeLimit']= 300;
//increase this value 
$cfg['ExecTimeLimit'] = 3000;

answered Oct 04 '21 at 06:39

MOAZZAM RASOOL

159
1
3

Imran_Developer · Answer 11 · 2022-12-28T10:54:49.783

3

So, after spending hours, this works for me (2023)

adding $cfg['ExecTimeLimit'] = 6000; into xampp/phpMyAdmin/config.inc.php
also I change $cfg['ExecTimeLimit'] = 6000; in xampp/phpMyAdmin/libraries/configdefault.php

edited Dec 28 '22 at 10:54

answered Jun 09 '22 at 19:06

Imran_Developer

343
5
13

score 1 · Answer 12 · answered Nov 09 '16 at 08:04

1

On Xampp, in php.ini you must check mysql.connect_timeout either. So, for example, change it to:

mysql.connect_timeout = 3600

That time will be always counted in seconds (so 1 hour in my example)

answered Nov 09 '16 at 08:04

andymnc

103
7

score 1 · Answer 13 · answered Dec 02 '16 at 18:25

MAMP USERS editing php.ini solves this - there is a line:

max_execution_time = 30 ; Maximum execution time of each script, in seconds

setting this to a higher value worked.

the file is in php/php5.6.25/conf/php.ini (obviousl you need to wet the file for the php version you are using - you can find this out from the MAMP preferences.

score 1 · Answer 14 · answered Nov 07 '19 at 09:31

If you are on xampp and using phpMyadmin to import large sql files and you have increased max_execution time, max file upload limit and everything needed And If none of the above answers work for you come here

Go to your xampp folder, in my case here is the relative path to the file that I need to modify: C:\xampp\phpMyAdmin\libraries\config.default.php

/** * maximum execution time in seconds (0 for no limit) * * @global integer $cfg['ExecTimeLimit'] * by defautlt 300 is the value * change it to 0 for unlimited * time is seconds * Line 709 for me */ $cfg['ExecTimeLimit'] = 0;

score 1 · Answer 15 · answered Oct 06 '11 at 21:35

PHP's CLI's default execution time is infinite.

This sets the maximum time in seconds a script is allowed to run before it is terminated by the parser. This helps prevent poorly written scripts from tying up the server. The default setting is 30. When running PHP from the command line the default setting is 0.

http://gr.php.net/manual/en/info.configuration.php#ini.max-execution-time

Check if you're running PHP in safe mode, because it ignores all time exec settings when on that.

score 0 · Answer 16 · answered Dec 09 '13 at 15:43

0

WAMP USERS:

1) Go to C:\wamp\apps\phpmyadmin

2) Open config.inc

3) Add $cfg['ExecTimeLimit'] = ’3600′; to the file.

4) Save the file and restart the server.

This file overwrites the php.ini and will work for you!

answered Dec 09 '13 at 15:43

Asi

395
4
13

score 0 · Answer 17 · answered Mar 05 '14 at 09:41

0

In my case, when I faced that error in Phpmyadmin, I tried MySQL-Front and import my DB successfully.

Note: You can still use the provided solutions under this question to solve your problem in Phpmyadmin.

answered Mar 05 '14 at 09:41

Jamshid Hashimi

7,639
2
28
27

Hier gibt es nichts zu sehen... :-) – rahul Oct 15 '19 at 06:42

score 0 · Answer 18 · answered Mar 30 '15 at 04:58

0

If above answers will not work, try to check your code,,In my experience,having an infinite loop will also cause that problem.Check your else if statement.

answered Mar 30 '15 at 04:58

score 0 · Answer 19 · answered Oct 04 '16 at 09:13

In Codeignitor version 3.0.x the system/core/Codeigniter.php do not contain the time constraint as well as inserting

ini_set('MAX_EXECUTION_TIME', -1);

will not work since codeignitor will override that with its own function set_time_limit() . So either you have to delete that function from codeignitor or simply you can insert

set_time_limit('1000');

in the beginning of the php file if you wanna change that to 1000 seconds. Set the time to 0 (zero) if you want to run it as long as it want.

score 0 · Answer 20 · edited Jan 05 '21 at 02:49

0

On wamp in my configuration where I have multiple phpmyadmins, the values in config files were overwritten in wamp/alias/phpmyadmin.conf. I set up two lines there:

1. php_admin_value max_execution_time 3600

2. php_admin_value max_input_time 3600

... it finally worked!

edited Jan 05 '21 at 02:49

J. M. Arnold

6,261
3
20
38

answered Jan 05 '21 at 00:06

ferdinand64

1

score 0 · Answer 21 · answered Nov 08 '21 at 09:14

0

For OpenServer

modules\system\html\openserver\phpmyadmin\libraries\config.default.php

change

$cfg[‘ExecTimeLimit’] = 600

answered Nov 08 '21 at 09:14

YurgenTM

83
1
6

score -2 · Answer 22 · answered Sep 29 '15 at 05:02

-2

You can set time limit:

ini_set('max_execution_time', 1000000000000000);

answered Sep 29 '15 at 05:02

binhhoang18

589
6
9

Fatal error: Maximum execution time of 300 seconds exceeded

22 Answers22

Linked

Related