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. You'll find that the table stores the data as a longtext instead of a varchar(341), and "voila," you'll see all of the data that was entered in the text area.

Bigger point: Why would we need to be doing a GROUP_CONCAT anyway? For a given (sid,cid) combination there would only be ONE data field, right?? All submissions (sid's) in the webform tables are unique, after all.

Comments

mudsurfer’s picture

mudsurfer commented

Hi wdseelig, thanks for this post. I have webform data exposed via views and having same issue with truncated text displayed in the view. I'm actually seeing this is in D7 - 7.x-1.0