Web Server: Linux 3.4.48-45.46.amzn1.x86_64
PHP 5.3.27
Drupal 7.22
Browser: Firefox 23, Explorer 10, Chrome

When I try to download all submissions (more than 10) from the result page in the Excel format and with label header format. It doesn't download and give the following notice:
"No export file ready for download. The file may have already been downloaded by your browser. Visit the download export form to create a new export."

I tried this method on several webforms and the ones that had more than 10 were unable to download to excel or even to tab delimited file.
The only one I succeeded to download was submissions from a form that had Max of 7 submissions.

CommentFileSizeAuthor
#9 webform_export_notice-2076761.patch2.93 KBquicksketch
#5 node_add_webform.png46.8 KBinbalj
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

quicksketch’s picture

quicksketch
he/him
CreditAttribution: quicksketch commented

Hi @inbalj, thanks for opening this ticket.

I can't reproduce this issue on my installations of Webform. Could you answer the following questions to narrow down the problem?

- Is there anything unique about the forms that aren't working? How many fields are on each one?
- Can you make a form with just a single textfield and populate it with submissions. How many submissions does it take before the download stops working?
- Is the result of the download not working the same in different browsers?

The message you're getting should only happen if you click the message at the top of the page after requesting a download. At the same time, your browser should also have started generating a download, so clicking on the message shouldn't be necessary. Could you open the "Network" tab in your browsers console and see if the download request (which is done via AJAX) is generating an error?

inbalj’s picture

inbalj CreditAttribution: inbalj commented

Hi quicksketch,

Sorry for the late replay.
The forms aren't unique and it happened with most of them.
1. Simple form with 2 text fields and one email field:name, email and phone.
2. form that contains selection box, checkbox and many text fields that are collapsed and open up when clicking the link.
3. A complex form that includes conditions and contain many fields - long form.
4. Simple form with 3 textfield and one areafield

I checked it in IE10, chrome and Firefox and in all it didn't download.

I can try to create a new form and see when it's stop working and let you know.
The message disappear so quickly that I can hardly see it not to mention capturing it.

Regarding the Ajax thing, I need explanation of how to get it.

Thanks,
Inbal

vernond’s picture

vernond CreditAttribution: vernond commented

FWIW - We also had issues with the downloads from our online servers but it worked fine on local machines. It turned out that gzip (or another zip type of module/extension - don't recall exactly which one it was) wasn't enabled in PHP on the online machines. Once we fixed that the downloads were cool.

inbalj’s picture

inbalj CreditAttribution: inbalj commented

It will really help if you told me what to fix. Or even tell the developer how to recreate the problem so a fix/patch could be sent.
Thanks,
Inbal

inbalj’s picture

inbalj CreditAttribution: inbalj commented
Version: 7.x-4.0-alpha10 » 7.x-4.0-beta1
FileSize
node_add_webform.png46.8 KB

Hi,
I upgraded the module and now I can't create new forms. it sent an error msg (see attached image).
Also, All my placeholders have disappeared.
Do you have any solution for that?
10x,
Inbal

mraichelson’s picture

mraichelson CreditAttribution: mraichelson commented

Hitting this issue in a local install here as well.

MAMP w/ PHP 5.3.20

Tried with two different webforms: one with 10 entries, one with 60k.

Both threw a 500 error when trying to do the batch processing.

For each attempt to download there's four entries in the reports/dblog listing, they all contain the same information...

Type: theme
Location: http://the.hostname/node/12345/webform-results/download
Referrer: http://the.hostname/batch?op=start&id=12345678
Message: Theme hook webform_inline_radio_label not found.

EDIT: Should have run drush cc all. Still having periodic 500 errors on batch processing for downloads, will update with better description of the logs and error messaging.

mraichelson’s picture

mraichelson CreditAttribution: mraichelson commented

For a webform with 10k entries, choosing to download the last 100:

No 500 error, following error message appears after batch is complete:

Notice: Undefined index: completion_type in webform_download_sids() (line 1495 of /blah/blah/blah/modules/webform/includes/webform.report.inc).

Log message appears in dblog 3 times.

Type: php
Location: http://the.hostname/batch?id=12345678&op=do
Referrer: http://the.hostname/batch?op=start&id=12345678

For a webform with 10k entries, choosing to download the last 1000:

Same as above.

For a webform with 10k entries, choosing to download 5k+:

Ajax 500 error, error message "An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=12345678&op=do StatusText: error ResponseText:"

No messages in dblog.

netikseo’s picture

netikseo CreditAttribution: netikseo commented

Yep, getting the same error (Notice: Undefined index: completion_type in webform_download_sids() (line 1495 of /blah/blah/blah/modules/webform/includes/webform.report.inc).) even on the webform with low number of submissions when trying to download x number of latest submissions.

Download works though...

quicksketch’s picture

quicksketch
he/him
CreditAttribution: quicksketch commented
Issue summary: View changes
FileSize
webform_export_notice-2076761.patch2.93 KB

Hi guys, thanks for the reports. I've solved this latter problem of the "Notice: Undefined index: completion_type" by ensuring that all exports have defaults merged in. I've committed this patch which solves this problem in the 4.x branch.

Unfortunately, I can't reproduce the problem where downloads actually fail. Anyone else who has insights as to how to reproduce the problem, please post as much information as possible. From the descriptions listed so far, I'm tempted to think that PHP ran out of memory (though we specifically try to avoid that problem with the batched operations in the first place).

  • Commit 2458f7f on 7.x-4.x by quicksketch: 
    Issue #2076761: Undefined index when exporting range of submissions.
fenstrat’s picture

fenstrat
he/him
Primary language English
Location Australia
CreditAttribution: fenstrat commented
Version: 7.x-4.0-beta1 » 8.x-4.x-dev
Assigned: Unassigned » fenstrat
Status: Active » Patch (to be ported)

#9 needs porting to 8.x-4.x.

fenstrat’s picture

fenstrat
he/him
Primary language English
Location Australia
CreditAttribution: fenstrat commented
Version: 8.x-4.x-dev » 7.x-4.x-dev
Assigned: fenstrat » Unassigned
Status: Patch (to be ported) » Active

Committed and pushed 2458f7f to 8.x-4-x. Thanks!

Moving back to Active as per #9.

  • Commit c517978 on 8.x-4.x authored by quicksketch, committed by fenstrat: 
    Issue #2076761 by quicksketch: Undefined index when exporting range of...
DanChadwick’s picture

DanChadwick CreditAttribution: DanChadwick commented
Status: Active » Closed (cannot reproduce)

No further information or reproduction instructions. I'm closing this. If someone can reproduce the problem with the latest dev, please provide as much information as possible.

suparnaa.dey’s picture

suparnaa.dey CreditAttribution: suparnaa.dey commented
Status: Closed (cannot reproduce) » Closed (outdated)

I have faced the same problem. From my local machine I can easily download all the 170 results but from the test server, I got "No export file ready for download. The file may have already been downloaded by your browser. Visit the download export form to create a new export." In my case, it was a max_execution_time issue. After increase the time its working fine on my both site.

crutch’s picture

crutch CreditAttribution: crutch commented

Running into this issue now. We are trying to clear out and backup old data. Starting with form #1 when attempting to download all submissions, results

Issue 1: "An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=1424&op=do StatusText: Internal Server Error ResponseText:"

Issue 2: When trying to download a partial set of 600 records, it goes through the process and downloads the .csv but it is 0 bytes.

Live server PHP settings should be able to cover the demand so this shouldn't be the issue.

max_execution_time 360
max_input_time 60
max_input_vars 5000
memory_limit 128M

---

The only work around found was to load latest data on local dev and then exports/downloads work as expected.