How do i mass prune Posts without problems ? [TOM]

[Tom Dooley]

Hi,
when i mass prune Posts I can only prune app. 50 Posts not more but i have to prune about 15.000 Post. I tried to delete everything what is older then 150 Days but i get everytime
Fatal error: Maximum execution time of 90 seconds exceeded in /home/wbc/www/forum/admin/db_mysql.php on line 150

even if i increase the 90 Seconds to an higher it is not enough. And it is a hard work to delete 50 by 50 Postsings. Is there any posibility to get this better worked ?


Tom

[Steve Machol]

I haven't really had the need to mass prune posts, but what would happen if you moved the posts to a temporary forum then deleted that forum?

[Tom Dooley]

Hi,
maybe this is an idea, i try this an let you know.
thx

[George L]

if that doesn't work there may be another way ..

[Tom Dooley]

Fatal error: Maximum execution time of 90 seconds exceeded in /home/wbc/www/forum/admin/functions.php on line 1864


same error, no problem to move the posts, but then when i try to delete the error come.

[Steve Machol]

At least they're in this temporary form now. Perhaps you could now delete this forum via phpMyAdmin. Let's wait to see what eva suggests.

[George L]

first, please understand that web hosts and php have the max_execution limit to stop php scripts from taking up too much cpu resources

so what i'm about to suggest should be used only for this problem and the file then removed.. otherwise your web host will probably kick you off for server resource abuse

in .htaccess file placed in root of your web account place

php_value max_execution_time 150

after you pruned the threads remove the .htaccess file

[Tom Dooley]

my board stay´s on an dedicatet dual PIII 1000 with 1024 MB Ram, i incresed the execution limit to 600 sec. but still it is not enough to delete the posts. if i delete it day by day it works if i delete it 10 by 10 days i get the error.

[George L]

90 - 600 seconds not enough!!!!

i'm out of ideas right now.. how can any php script in vB need more than that time??

Tom and NYI Fan... i'm going to split this thread into 2 threads for each of your issues and handle each one separately okay

[George L]

Originally posted by Tom Dooley
my board stay´s on an dedicatet dual PIII 1000 with 1024 MB Ram, i incresed the execution limit to 600 sec. but still it is not enough to delete the posts. if i delete it day by day it works if i delete it 10 by 10 days i get the error.

actually if you don't mind... i'd be happy to check out your php/mysql config on your server ?

pm me or email me at geor[email protected]

[Tom Dooley]

oh see here
http://66.33.102.178/phpinfo.php

[George L]

Originally posted by Tom Dooley
oh see here
http://66.33.102.178/phpinfo.php

from that phpinfo it says your php max_execution time is = 30 seconds still not 600 ??

did you change it back ? or did you edit php.ini but forget to restart apache for it to take affect ?

[Tom Dooley]

no i put it back because it did not help

[George L]

try this

in php.ini

set

max_execution_time = 90
memory_limit = 16M

see if that helps

[Tom Dooley]

Hi
i tried thsi before increased to 16 M and increased until 600 sek
but still if there are more tha 100 Posts zu prune i get the error. Even i tried it on other servers the same problem.