I am using several webforms on my site and they seem to work flawlessly until I click the Results tab - Analysis link on all of my webforms. They each throw the following error:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) GROUP BY data' at line 1: SELECT wsd.data AS data, COUNT(data) AS datacount FROM {webform_submitted_data} wsd WHERE (nid = :db_condition_placeholder_0) AND (cid = :db_condition_placeholder_1) AND (data <> :db_condition_placeholder_2) AND (data IN ()) GROUP BY data; Array ( [:db_condition_placeholder_0] => 18 [:db_condition_placeholder_1] => 13 [:db_condition_placeholder_2] => ) in _webform_analysis_select() (line 641 of /home/barton/www/las/drupal/sites/all/modules/webform/components/select.inc).

Comments

quicksketch’s picture

Status: Active » Postponed (maintainer needs more info)

I feel link we've solved this problem before recently. Are you sure you're on the latest version of Webform (4.0-alpha6)?

This error occurs on all webforms on your site, even a brand new one with nothing but a textfield? From the error description it sounds like this problem is coming specifically from select list components, most likely a select list component that doesn't have any options (which shouldn't be possible, Webform throws a validation error preventing this). If this problem occurs on all Webforms, do you have any other webform-related modules on your site?

fgyangqing’s picture

I have this error too.
If I use the admin account to view,it work well,
but when I use other account to view,it will get this error.
It's to strange.

quicksketch’s picture

@fgyangqing: Could you answer the same questions I asked in #1? We can't solve this problem if we don't know how to reproduce it.

quicksketch’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Closing after lack of activity.