I didn't see this already submitted, so sorry if it is a duplicate...

I received the following error after deleting all of my form submissions:

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 = 2 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /home/myaccount/public_html/h/mydomain.com/sites/all/modules/webform/webform_submissions.inc on line 168.

"clear" seems to provide the same error.

The only time I see the error is on the "form submission / webform-results" page. It otherwise, appears to be working normally.

While I am not a big fan of the e-mail output of the webform, I LOVE this module! It has provided to be a VERY useful tool for building exceptional Drupal websites :)

Keep it up!

Comments

Peter van den Heuvel’s picture

I can confirm this issue.

How do I solve it?

quicksketch’s picture

Status: Active » Closed (duplicate)