cleaner.php failed

[Gary Fischman]

I tried using cleaner.php to substitute some of the smilies that failed on import. Here's where it got before failing:


Post done -> 246341
Post done -> 246342
Fatal error: Maximum execution time of 30 seconds exceeded in /home/forum/www/vb/impex/db_mysql.php on line 248


What happened? How do I get around it?

[Steve Machol]

Your server timed out. To overcome this limit, add this line to your config.php file right under <?php

ini_set("max_execution_time", "120");

Then when you are done, immediately remove that line. Your host may not take kindly to you bypassing their limitations.

[Gary Fischman]

Happened again. Same line. :(

Fortunately, I am my own host, so no one to worry but me. :)

[Gary Fischman]

Tried again - this time:

Post done -> 235421
Post done -> 235422
Fatal error: Maximum execution time of 30 seconds exceeded in /home/miataforum/www/vb/impex/db_mysql.php on line 248

[Marco van Herwaarden]

It still shows 30 seconds. Check that edit.

[Steve Machol]

Since this is your server, you should change the max_execution_time setting in php.ini to '120'. You need to restart Apache after making that change.

[Gary Fischman]

I'll try it - but dollars to donuts, it will time out again after 120.

[Gary Fischman]

Thanks! (BTW - just to be sure, I also increased the maximum script memory to 128M.)

[Gary Fischman]

Post done -> 1222841
Post done -> 1222842
Fatal error: Maximum execution time of 120 seconds exceeded in /home/forum/www/vb/impex/db_mysql.php on line 248


What else might be going on here? It worked once on a prior test import. Not working on the latest.

[Zachery]

Set it to 180. I'd change the script memoryu back to 16 or 32, 128 is excessive.

[ajaspers]

You can set it to 0 to disable the limitation (for both memlimit and max_execution_time)

[Gary Fischman]

Not being a big fan of "throw more resources at it", I'm actually more interested in understanding why this occurs. Does it have to do with the way the script is written, or is there a problem somewhere?

[Jerry]

Not being a big fan of "throw more resources at it", I'm actually more interested in understanding why this occurs. Does it have to do with the way the script is written, or is there a problem somewhere?

The script is very basic to be honest, it attempts to disable the time out then goes through all the post in a linear fasion.

So on a board of your size it will time out before it gets to the end.

I need to change it to do the per page actions like the rest of the impex.

[Gary Fischman]

Fair enough - I can live with that. :)

[Gary Fischman]

FYI - I figured out why it times out. There's so much data streaming into my browser, my machine runs out of memory while parsing through the 1.3 million posts, and eventually goes into swap-hell, slowing it to a crawl until it eventually times out.

[Jerry]

Ok, well you can run it via the command line if that is an option and pipe the output to a file.

Do you have PHP on the command line ?