Could the script be hitting it's head on the ceiling and then pooping the
bed?
I've had a similar problem, when the script exceeds the (default) 8M mem
limit. Could it be that because of the size of the file?

-db

Tobyn Baugher wrote:

> Hi All,
>
> Normally I try not to take work home with me, mainly because I'm good
> enough at breaking my own code. In this case, however, I think it might
> be a good idea if I knew the answer to the question I was asked.
>
> Basically, there's a PHP script. This script is a rather kludgy way of
> keeping a bunch of data in a flat file generated on a certain server
> reasonably up to date with the data in a MySQL database on the frontend
> webserver. The script's responsibility is to go through this file line
> by line (some 8000 of them), parse the data on each line, perform a
> simple transform or two on that data, create a query to REPLACE that
> data into the database (the flat file and the backend server are
> authoritative over the MySQL server), execute the statement and then
> move on to the next line.
>
> The problem is, somewhere in the middle of this script (more like
> closer to the beginning) the script just *dies*. I say that because
> there's no error message, no warnings, no footer content that's
> included after the processing is done, nothing. It just dies in the
> middle of the while loop that reads the file and executes the
> statements.
>
> Some rather exhaustive checking by both myself and the actual owner of
> the script indicate that there are no glaring errors in the PHP or the
> SQL the PHP generates, and the lack of an error message of any kind
> indicates the same thing.
>
> That said, here's where I'm sitting currently: I think it's a matter of
> some limitation in the system. Almost certainly not one that's
> hardcoded in there by anyone, but perhaps along the line of some sort
> of system-dependent limit that needs to be increased. I think it'll
> probably be hard to give a definitive answer right out off the bat (and
> that's not what I'm looking for), but I'd like some ideas as to
> possible places I could start looking.
>
> Here are the details I _do_ have:
> OS: BSD/OS
> MySQL: 3.22 (Upgrading isn't much of an option, or I would have)
> PHP: 4.0 (Might be 4.0.1. Same situation as above, but perhaps a CGI
> version can be built if this is the limitation)
>
> The data file is right around 8600 lines, and all told the script is
> executing just over 1 statement per line.
>
> Any light someone could shed on the situation would be much appreciated.
>
> Cheers,
>
> Toby
>
> --
> Tobyn Baugher <[EMAIL PROTECTED]>
> http://www.cartoonviolence.net/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]

--
----------
Dan Barton
Terrestrial Program Biologist
Asst. Data Manager
Point Reyes Bird Observatory
http://www.prbo.org
[EMAIL PROTECTED]
[EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to