Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
When displaying empty results of a webform eg. "http://www.mydomain.com/node/1045/results" the follow error is reported;
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 = 1045 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /home/mydomain/public_html/includes/database.mysql.inc on line 174.
Comments
Comment #1
revo2wheels CreditAttribution: revo2wheels commentedResolved after upgrade to 2.6.