During update of webform module sql error appear. This error appear when there are permissions with single quotes in permission name in your database.
The way to resolve this problem it's to add addslashes() function in needed places of webform.install code. I suggest you patch which can resolve problem with single quotes in permission name during updating from previous versions.
| Comment | File | Size | Author |
|---|---|---|---|
| #6 | webform_permission_escape_fix.patch | 1.11 KB | quicksketch |
| #3 | Screen-shot-1.jpg | 58.81 KB | Anonymous (not verified) |
| #3 | Screen-shot-2.jpg | 182.5 KB | Anonymous (not verified) |
| #2 | webform.install.patch | 897 bytes | vitvas |
Comments
Comment #1
quicksketchAny idea which update caused this problem?
Comment #2
vitvas commentedHere's the patch
Comment #3
Anonymous (not verified) commentedThe following error appeared when I updated from Webform 6.x-3.1 to 6.x-3.4. My webforms are no longer functioning after this update. This is a major bug which should be fixed as soon as possible. I'm going to apply the patch and hope this fixes the problem.
Comment #4
Anonymous (not verified) commentedI applied the patch, but it did not fix the problem. I'm still getting the error. This appears to be a separate issue, so I've posted a new bug report here:
http://drupal.org/node/1003400
Comment #5
quicksketchThanks for the patch vitvas. Rather than using addslashes(), the proper Drupal function is probably db_escape_string(). But in any case this is close enough I should be able to figure it out next time I'm working on Webform.
Comment #6
quicksketchI've committed this patch which uses the correct escaping function for MySQL queries.