Cannot download results of webform

This is typically caused by Webform running out of memory while compiling all the results together. You should increase the memory and/or max_execution_time to your PHP installation. See #309019: Downloads break (too many records) .

Open up your .htaccess file that comes with Drupal. It's got lines sort of like this:

# PHP 5, Apache 1 and 2.
<IfModule mod_php5.c>
  php_value magic_quotes_gpc                0
  php_value register_globals                0
  php_value session.auto_start              0
  php_value mbstring.http_input             pass
  php_value mbstring.http_output            pass
  php_value mbstring.encoding_translation   0
  # New settings:
  php_value max_execution_time              60
  php_value memory_limit                    128M
</IfModule>

Add the new lines from above for max_execution_time and memory_limit.

If this doesn't work, I know BlueHost allows you to set PHP settings via a php.ini file located in the root of your home directory on the server. See http://helpdesk.bluehost.com/kb/index.php?id=124&mod_id=2&x

I made this change and even upped the max_execution_time to 300 and it still timed out. I'm running Drupal 5.11, so I'm not sure if that makes a difference.

Do you have any other suggestions? I need to get to this data.

I get the same error (running my Drupal on Dreamhost). I have 600 records in my web form. Here is the form in question.

http://www.reignministries.org/apply

I have attempted the following solutions.

#1 htacess fix as mentioned above

#2 site/default/settings

ini_set('memory_limit', '128M');
ini_set('max_execution_time', '120');
ini_set('max_input_time', '120');

Neither solved the issue. I can view results but am unable to download them. Is this a situation where Dreamhost is NOT accepting these changes?

I contacted Dreamhost and they have me messing about with this...

http://wiki.dreamhost.com/PHP.ini

Is there any work around it getting this data downloaded? Right now I'm viewing the table, copying and pasting the table manually into an Excel spreadsheet.

I'm trying to cover all timeout-related bugs in #423350: Improve efficiency of options in select.inc, please take further discussions to that ticket.

I dont get the out of mem white screen but no data is in the downloaded csv. latest release of both drupal and webform and my limits are cranked up???

Eric

adding the following

 # New settings:
  php_value max_execution_time              60
  php_value memory_limit                    128M

to htaccess worked great for me thanks.

FWIW, I had to increase the php memory limit to 512MB to be able to download the my webform submissions. This also got rid of the "unexpected error message" that I used to get when installing modules.

I had the same problem as reported by #11 but the issue persisted after the php version was updated.

[SOLVED]: I found the problem when looking at the admin/reports/status - It said the temp folder does not exist so when looking at the path to the temp folder, I found it was incorrect.

Hope this helps someone else.

Hi,
I have not been able to resolve this issue. I updated .htaccess and php.ini.
When I click to download the webform results (URL: .../webform-results/download), I get the error "sorry, the requested page cannot be found on our server."
Perhaps it's related to an issue with the temp folder. Where should the temp folder (for webforms) live?

@gregwbourne - Does comment #12 help you?

@DanChadwick - I checked the reports URL referenced in #12 and don't see anything related to a temp folder. What specifically would I see (do you know)? Also, where does the temp folder generally live? Thanks.

Check Configuration / Media / File System.

Please try the Drupal support forums or IRC for further help. This is beyond the scope of support provided in the webform issue queue. Best of luck to you!