Max Execution Madness

[jaymc]

Hi, ok i'll make this as simple as possible

i have a website, 40,000 members all squeezed into a flat file database

im now in process of converting that to MYSQL, so ive wrote a simple PHP script out which uses a loop to dump each users details into the table

it works fine, the script is flawless, but after 30secs it stops processing

now obviously this is due to a PHP limit of MAX Execution Time

Noted, and altered to 700 secs, restarted apache, then the server, still no luck

any ideas

[StevenC]

run the script from ssh:

php -f script.php

[jaymc]

Exactly the same problem running the script via SSH as to a browser

any ideas ?

[dave9000]

Adjust the max amount of memory php can use up as much as you can and then rerun the script

Also make sure there is enough space in /tmp

[jaymc]

nope ! still no luck

doing the same thing no change

[lankyb]

Stupid suggestion, but when you have Zend Optimizer installed on your server, it changes the location of the php.ini file to /usr/local/Zend/etc/php.ini (or is atleast for me anyway)

Are you sure your updating the correct php.ini file?

[jaymc]

well as a matter of fact i was changing the wrong file

but ive just checked the php.ini located in Zend, and its exactly the same as the other 1

so i guess they are some how linked, but any way

still the same problem

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 2900 ; Maximum execution time of each script, in seconds
memory_limit = 150M ; Maximum amount of memory a script may consume (8MB)

just so you can see

additional information : when running the script, even when using an array instead of echoing, i get an OFSET error when it gets to about the 6000 folder that its reading from

ring any bells ?

get back asap please! cheers !!

[clickelement]

I am having the same problem. Changing the php.ini file does nothing. Could anyone shed some light?