[FX.php List] 5 minute timeout?

[David Ness]

Dale, thanks for the suggestion.

Moving the 'set_time_limit' outside the loop had no effect. Also, I see
that I was mistaken in my belief that the log error quoted below was
thrown upon 'timeout'. It isn't. The error came from some other
condition not related to this problem.

During my latest test, the 'timeout' did occur, and the php error log
remained clear.

I'm re-reading the additional comments on
http://us2.php.net/set_time_limit and I think the solution is there. You
can't leave a browser waiting for new data for 5 minutes. I'm going to
try some solutions which involve flushing output to the browser
periodically. Something like:

ob_start();
While loop
{
	Do the things that take a log time
	echo ".";
	flush();
	ob_flush();
}

I'll report back later after trying a few potential solutions.


--
David Ness,
Database Systems Programmer
 
Bonded Builders Warranty Group
1500 Kings Highway
Port Charlotte, FL 33980
800.749.0381 x3123 (National Toll Free)
941.255.3274 x3123 (Local)
 

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale Bengston
Sent: Tuesday, August 29, 2006 11:20 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] 5 minute timeout?

Hi David,

Try using set_time_limit at the top of the html page being loaded
instead of within the while loop. I think it's designed to work per-
script, not per-iteration of a loop.

Regards,
Dale

On Aug 29, 2006, at 10:12 AM, David Ness wrote:

> My fx.PHP solution has a feature where the user can 'batch upload'  
> data
> to a FileMaker table using a properly formatted csv file. I've got 
> everything working great, except I can't get the page to stop timing 
> out after 5 minutes. I get about 320 records posted (of a test set of 
> 1000), then the script stops, throwing the following error to the php 
> error
> log:
>
> [29-Aug-2006 10:53:48] PHP Warning:  fsockopen() [<a
> href='function.fsockopen'>function.fsockopen</a>]: unable to connect 
> to 10.10.10.4:80 (A connection attempt failed because the connected 
> party did not properly respond after a period of time, or established 
> connection failed because connected host has failed to respond.
>
> 10.10.10.4 being my FM WPE.
>
> The basic structure of the php code is:
>
> $handle = fopen("uploadedfilename.csv", "r"); while (($importdata = 
> fgetcsv($handle, 0, ",")) != FALSE) {
> 	set_time_limit( 50000 );
> 	$newApplication->AddDBParam('builder_reference_number',
> $importdata[0]  );
> 	$newApplication->AddDBParam('builder_number', $importdata[1] );
> 	$newApplication->AddDBParam('homeowner_firstname',
> $importdata[2]  );
> 	$newApplication->AddDBParam('homeowner_lastname', $importdata[3]
);
> 	$newApplicationResult = $newApplication->FMNew(); } // end of
while 
> fclose($handle);
>
>
> As you can see, I've tried playing around with the usual subjects;
> max_execution_time, max_input_time, and set_time_limit.
>
> My ini info is located at:
> http://www.bondedbuilders.com/builderportal_development/phpinfo.php
>
>
> I use a MS IIS v6 server, and don't see any options there (though I'm
> not ruling out the solution being there), and I also wondered if the
> solution lies in placing some statement in the HTML HEADER of the  
> page,
> which I haven't found.
>
> If you know of any potential solutions to this timeout problem, please
> offer them up!
>
> Thanks!
>
> --
> David Ness,
> Database Systems Programmer
>
> Bonded Builders Warranty Group
> 1500 Kings Highway
> Port Charlotte, FL 33980
> 800.749.0381 x3123 (National Toll Free)
> 941.255.3274 x3123 (Local)
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list