After clearing the Results report of WebForm, I receive the following error message;

user warning: 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 ') ORDER BY sid ASC, cid ASC, no ASC' at line 1 query: SELECT s.*, sd.cid, sd.no, sd.data, u.name, u.mail, u.status FROM webform_submissions s LEFT JOIN webform_submitted_data sd ON sd.sid = s.sid LEFT JOIN users u ON u.uid = s.uid WHERE sd.nid = 16 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /home3/xxxxx/public_html/website/sites/all/modules/webform/webform_submissions.inc on line 168.

Comments

thebuckst0p’s picture

I'm getting the same error with a fresh copy of Webform installed, and forms don't save or send.

cdale’s picture

Status: Active » Closed (duplicate)

There are several posts in this queue that have this same error. Marking this as another dupliacte. #360443: Empty results tab generates SQL error