Closed (duplicate)
Project:
Webform
Version:
6.x-2.4
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Anonymous (not verified)
Created:
12 Feb 2009 at 22:23 UTC
Updated:
12 Oct 2018 at 22:11 UTC
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
Comment #1
thebuckst0p commentedI'm getting the same error with a fresh copy of Webform installed, and forms don't save or send.
Comment #2
cdale commentedThere are several posts in this queue that have this same error. Marking this as another dupliacte. #360443: Empty results tab generates SQL error