Fatal error: Maximum execution time of 300 seconds exceeded

daisyhead
(@daisyhead)

18 years, 4 months ago

I recently upgraded to WP 2.0 and then decided I wanted to go back to 1.5. Everything has gone smoothly except for importing of my SQL database. I am currently getting the following error:

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91

I saw in another post that someone made mention of overriding PHP’s default execution time by adding the following to the wp-config.php file:

set_time_limit(‘120’);

But I’m unsure how or where to add this to the wp-config file. Can someone help me out? I also have a support ticket out to my host to see if they can temporarily up the limit but with it being a holiday weekend I don’t know if they will respond any time soon and I’d really like to get my blog back up and running.

Thank you in advance!

Viewing 11 replies - 1 through 11 (of 11 total)

Moderator James Huff
(@macmanx)

Volunteer Moderator

18 years, 4 months ago

What you are seeing is a server report, not a WordPress error. Most hosting providers set maximum PHP execution times to prevent system abuse. Your server’s maximum is set to 300 seconds, and a large database may take more than 300 seconds to upload. You may have to contact your hosting provider and ask them to restore your database backup for you, or temporarily increase the maximum PHP execution time.

Out of curiosity, why do you want to go back to v1.5?

Thread Starter daisyhead
(@daisyhead)

18 years, 4 months ago

Thanks for the info. I have a ticket out to my host but I don’t think it will get answered any time soon.

I just didn’t like the interface with 2.0 or the functionality, not to mention a lot of my plugins didn’t work with 2.0 including the CG-Archives plugin I use to do my archives. I realized I was quite happy with the version I was running and thought it would be a snap to revert back to. Boy was I wrong.

Thread Starter daisyhead
(@daisyhead)

18 years, 4 months ago

So adding the following line: set_time_limit(‘5000’);

To my wp-config.php isn’t going to fix the problem either? Dammit.

Moderator James Huff
(@macmanx)

Volunteer Moderator

18 years, 3 months ago

So adding set_time_limit('5000'); to my wp-config.php isn’t going to fix the problem either?

No, because the “problem” is related to your server’s configuration of PHP, not WordPress.

Mark (podz)
(@podz)

18 years, 3 months ago

Daisyhead – an alternative is to open the .sql file in something like WordPad, Notepad++ or another plaintext editor and then copy and paste huge chunks into the SQL query box.
Laborious but it works.

Another method is to upload the sql file into your website and then use the command line to import it.

Better still, upoad the sql file and then send the location of that file to your host and ask them to import it for you.

linuxale
(@linuxale)

18 years, 2 months ago

Hi Guys,
somebody have a definitive solutions for this problem?

Thanks
Linuxale

vkaryl
(@vkaryl)

18 years, 2 months ago

The definitive solution is to either:

1. Get your host to increase the server time limit;
2. Upload the sql file and ask your host to do the db import for you from the file;
3. Use the “chunks of text in the sql query field” option (I’ve been able to do up to 7000 lines before the server timeout lands);
4. Download BigDump from http://www.ozerov.de/bigdump and see if that is workable on your server.

linuxale
(@linuxale)

18 years, 1 month ago

Hi vkaryl,
Hi don’t know how to do the point 2 and 3!

Can you explain its!

Thanks
Linuxale

linuxale
(@linuxale)

18 years, 1 month ago

I’v tried the bigdump script and it works perfectly! But after a dump/restore the upload continue to fail!

I installed WP2 too! But the problem persist. So I think the problem itsn’t WP but some mine configuration! But Which conf!?!

Fatal error: Maximum execution time of 30 seconds exceeded in /var/wp2/wp-admin/admin-functions.php on line 1754

Thanks
Linuxale

linuxale
(@linuxale)

18 years, 1 month ago

I’v found a workaround!

So what I do.
I Dump all the db and only the wp_personal_options table.
I reset the db and reconfigure wordpress1.5 with :
http://myblog/wp-admin/install.php

Ok at this point a retry to upload a file and I get a success! Uahuuu.
Ok so I dump only the wp_personal_options table and restore the old one. The Upload begin to fail.

So I think There is something in the wp_personal_options table!
I like to understand what. I’v look to the differece between the table but I have no idea of this behaviour.
If somebody can help me to understand why… I will be happy!

See You
Linuxale

webmedi
(@webmedi)

17 years, 10 months ago

I need increase execution time. Please give me process.
Error Massage occured like this:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/herboint/public_html/admin/admin_bonus.php on line 185

Regards,
Dilip