[phpesp-general] Re: CSV timeout error

[Christopher R. <ri...@uw...>]

On 11/16/05 10:20 PM, php...@li...
<php...@li...>:

> After using phpESP for a couple of years, I have gotten an error that
> occurs when I try to download a survey results text file:
> 
> Fatal error: Maximum execution time of 30 seconds exceeded in
> F:\wwwroot\home\survey\admin\admin\include\function\survey_export_csv.inc
> on line 112
> 
> I haven't noticed anywhere in the php.ini where that 30 second timeout
> is set.
> 
> Knowing the survey id, is it possible to use an SQL statement to extract
> the data?  Can someone share that with me?

I actually figured out what was causing my CSV timeout error above.  (I
don't know if this is something the developers would like to fix
programmatically or if it would just be helpful to have a record of this in
the listserv archives.)

Anyhow...

The survey that I was having the trouble was 64 questions in length with
only 141 responds.  Reviewing the data, I realized that approximately 20 of
the questions all had the same question variable name (assigned
automatically by the question editing interface).  Changing these questions
to each have a unique variable name, solved the problem, and I was able to
successfully download the CSV file.