Fatal error: Maximum execution time of 300 seconds exceeded

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Fatal error: Maximum execution time of 300 seconds exceeded

Postby citabriabob » 04. December 2008 02:12

I have installed XAMPPlite on WinXP Pro SP3 for testing only and seems to work well.

When trying to import a SQL file of about 26mb, dowloaded from Linux server, I get this message:
Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampplite\phpMyAdmin\libraries\string_mb.lib.php on line 47

I have already changed several parameters in PHP.INI (in apache\bin\) and was successful in removing the 16mb limit, but not the execution time limit.

Thank you for any help.
citabriabob
 
Posts: 2
Joined: 04. December 2008 02:06
Location: Beautiful Hudson Valley of New York

Re: Fatal error: Maximum execution time of 300 seconds exceeded

Postby Sharley » 04. December 2008 02:40

Take a look in .\xampp\phpMyAdmin for config-inc.php file.

Look for this line and adjust as required:
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)

If your config-inc.php file is small and missing the above line or missing altogether then the file config.default.php in the .\xampp\phpMyAdmin\libraries folder is used.
The line in config-default.php may look similar to this:
Code: Select all
/**
 * maximum execution time in seconds (0 for no limit)
 *
 * @global integer $cfg['ExecTimeLimit']
 */
$cfg['ExecTimeLimit'] = 300;

Copy this file in to the phpMyAdmin main folder and rename it config-inc.php or copy the contents into the existing config-inc.php file and then do your editing in this new file not in the config-default.php file - this procedure makes it easier, as now all phpMyAdmin configs will be in the one place not in 2 locations with one being editable (config-inc.php) and the other not editable (config-default.php).
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Fatal error: Maximum execution time of 300 seconds exceeded

Postby citabriabob » 04. December 2008 22:34

Dear Sharley:

That is GREAT!!! Worked a treat. Thank you ever so much.

Robert
citabriabob
 
Posts: 2
Joined: 04. December 2008 02:06
Location: Beautiful Hudson Valley of New York

Re: Fatal error: Maximum execution time of 300 seconds exceeded

Postby Defcon » 08. May 2009 12:44

Thanxs. It help me a lot.
Defcon
 
Posts: 1
Joined: 08. May 2009 12:41


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests