Subject: RE: [FIX YOUR SUBJECT !] php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992

Hi - Suggestions : 1) Turn on error_reporting in your PHP script : <?php

        error_reporting(E_ALL);

?> 2) Load page, and go to browser's View->Source menu, to see if you actually got malformed HTML or anything at all. Cheers - Neil

From: Cosman CUSCHIERI <cosman.cuschieri@st.com> To: <php-db@lists.php.net> Date: Wed, 22 Jun 2005 15:29:47 +0200 Message-ID: <002c01c5772e$76284a00$fc9e82a4@kir.st.com> MIME-Version: 1.0 Content-Type: text/plain;

        charset="us-ascii"

Subject: RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992 I make part of a team where we have created a system which produces reports. The reports are produced based on selection criteria which the user sets from an oracle database. The problem we are facing is that when the users selects a big time frame the report just freezes, the status bar displays 'done' the IE (our preferred browser) window flag stops animating and report does not show anything, only a blank page. I am suspecting a time out somewhere. I am using the function set_time_limit and some of the reports did improve but still facing the problem with others. Each report has a main SQL based on which the report is generated. I am guessing setting set_time_limit prolongs the timeout of the generation of the report by php, but i am suspecting, either:

        1 - The sql is taking too much time to get back with some data on

which php will still time out.

        2 - Some other time out exists (e.g. Apache).

if so 1 can somebody advice how to set this other time out if it exists or some other way to workaround this. if so 2 do somebody knows how to override this through php or some other way to workaround this. Any feedback / ideas are very much welcomed Cosman

======================================================== CaptionKit http://www.captionkit.com : Production tools for accessible subtitled internet media, transcripts and searchable video. Supports Real Player, Quicktime and Windows Media Player. VideoChat with friends online, get Freshly Toasted every day at http://www.fresh-toast.net : NetMeeting solutions for a connected world.