Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Email field with user email by default show "%useremail" to anonymous users into the textfield
Additionally:
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 = 4 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in /var/www/vhosts/httpdocs/sites/all/modules/webform/webform_submissions.inc on line 168.
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | webform-360443-1-D5.x.patch | 1.6 KB | cdale |
| #1 | webform-360443-1-D6.x.patch | 1.15 KB | cdale |
| 17-01-2009 09-07-55 p.m..png | 3.46 KB | alexanderceb |
Comments
Comment #1
cdale commentedFor the first problem you mention, I'm assuming that you are not logged in when you are viewing the form? (I hope so anyway, because that's the only way it makes sense:))
The second problem is a small bug where an empty value is not checked for. I've attached a patch that should fix both problems.
Comment #2
danielb commentedI am experiencing this exact same bug in Drupal 6. (for anonymous users only)
Comment #3
quicksketchThe first problem already has a patch at #357687: %username and %useremail not removed for anonymous users (Please only submit one problem per issue, to prevent this exact sort of duplication).
Marking #360686: empty results tab generates SQL error as duplicate of this issue, since this one has a patch for it.
Thanks cdale for another excellent fix. Committed to D5 and 6 branches.
Comment #4
danielb commentedI googled this problem, and this is the ONLY issue I found. The other issue you linked to was not found. I don't think anyone is intentionally trying to be a pain by reporting issues a second time. The first one was just not easily findable.
Comment #5
alexanderceb commentedSorry, title of previous post is not completely descriptive.
Thanks by fix.
Comment #6
quicksketchYou're right danielb. I was commenting in #3 just that issues should not be bundled together. This issue was posted before the other one, so jceballosr certainly isn't at fault for duplicating issues. The second user might have opened the duplicate issue because this issue covered two different problems.
So no worries all around. Sorry for any confusion.
Comment #8
quicksketchKeeping this open until the 2.5 release comes out.
#368008: MySQL error messages when using webform marked as duplicate.
Comment #9
Anonymous (not verified) commentedI appreciate your fixing this, however, I'm not familiar with the process of applying a patch.
Will this fix also be incorporated into the next update for WebForm?
Comment #10
quicksketchYou can always download the development version to get the latest fixes (Visit the project page, click "View all releases"). I'm planning on getting out a 2.5 version if I can figure out #358640: Date and Time Fields Loose Value in Multipage Forms.
Comment #11
Anonymous (not verified) commentedthanks for your efforts. using the dev version resolved the problem.
Regards,
Techgy
Comment #13
zedxprt commentedI am facing the same problem. I have created a webform and added the component. It was running fine, One of my client requested to limit the submissions to 100, so I got a PHP snippet and i inserted in "Advance form Processing" box in my webform settings and clicked save. Once saved, submissions got locked and throwing out the message that the submissions are closed. but, later i got the same error message and even if i am removing the php snippet, the error message remains same and anonymous users cannot able to see the form and the its Access Denied. I re-checked with permissions aswell.
Plz help.
Comment #14
quicksketchPlease file a new issue.