Closed (duplicate)
Project:
Webform
Version:
5.x-2.4
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 Jan 2009 at 19:47 UTC
Updated:
19 Jan 2009 at 00:55 UTC
If there are no submissions at all then when you go to the Results / Submissions tab you will see the following SQL error:
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 = 414 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /.../includes/database.mysqli.inc on line 156.
Comments
Comment #1
quicksketch#360443: Empty results tab generates SQL error.