I've cleared every cache I can find, and this module STILL does not display all fields in all Webforms. VERY frustrating.

CommentFileSizeAuthor
#3 webform_submitted_views-node_grouping-1841758-3.patch5.16 KBtlupfer
#2 webform_views_submitted-missing_nid-1841758-2.patch3.1 KBtlupfer

Comments

wdseelig’s picture

wdseelig commented
Title: Not all fields displayed » Textarea field data not displayed

This module will not display data entered into a textarea field in a webform.

Very frustrating.

tlupfer’s picture

tlupfer commented
Status: Active » Needs review
StatusFileSize
new webform_views_submitted-missing_nid-1841758-2.patch3.1 KB

Information was being grabbed via a cid associated with wrong node id. This affected only sites with webforms on multiple nodes. Attached patch added a node id. Also using patch http://drupal.org/files/nid-fix-1321432-3.patch

tlupfer’s picture

tlupfer commented
StatusFileSize
new webform_submitted_views-node_grouping-1841758-3.patch5.16 KB

Still experiencing issues with node overlap when they shared a field key. Patched to group things by node. note: includes previous patch and http://drupal.org/files/nid-fix-1321432-3.patch

wdseelig’s picture

wdseelig commented

Here was my "fix" for this ...

This issue is not completely fixed -- at least not as of 6.x-1.3.

If you can't change group_concat_max_len [and godaddy will not let me do so] then you have no way of getting around this problem.

EXCEPT. The place in the webform_mysql_views module that retrieves the webform data is around line 352 and contains the following code:

$component = sprintf("(SELECT GROUP_CONCAT (data) FROM {webform_submitted_data} AS child WHERE child.sid = parent.sid AND cid = %d) AS `%s`, ", $row['cid'], $row['form_key']);

Simply remove the GROUP_CONCAT from this code, and you'll find that the table stores the data as a longtext instead of a varchar(341).

Bigger point: Why would be need to be doing a GROUP_CONCAT anyway? For a given (sid,cid) combination there would only be ONE data field, right??

escoles’s picture

escoles commented

After applying these patches, I get 27 empty results pages, with the following error:

user warning: Unknown column 'unknown' in 'order clause' query: SELECT webform_submissions.sid AS sid FROM webform_submissions webform_submissions ORDER BY unknown ASC LIMIT 2600, 100 in /Users/username/Sites/@webroot/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150

EDIT: I applied only the last patch from #1321432: No values for fields and the error goes away. so, caused by something in the last patch from this issue (or some interaction with something else, but I guess that goes without saying).

lizac’s picture

lizac commented

I applied the patches but it only worked for a certain webform submitted results.
We have several webforms and the one I'm trying to retrieve is mot displaying any submitted data.
Anyone can help me understand why?