Forms Not Submitting [#365061]

I am not able to submit forms... I do not get any error messages except for this log entry:

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 = 25 AND s.sid IN () ORDER BY sid ASC, cid ASC, no ASC in [...]/modules/webform/webform_submissions.inc on line 168.

When I hit submit a form the page just reloads with all the values I entered filled in.

Comments

Comment #1

strategictech commented 27 January 2009 at 17:40

Priority:

Critical

» Normal

I'm still not sure what caused this but I disabled then uninstalled webform then re-enabled webform and I was able to submit a simple form with a single textfield...

Disabling then re-enabling does not work.

Updated this to normal because it is a pain to rebuild all the form components but since it can be corrected easily it is not "critical."

Comment #2

tom friedhof commented 29 January 2009 at 01:41

I'm having the same exact issue except that I when I uninstall the module and re-enable it, a form with a single textfield still does not submit. The form throws validation errors when i submit forms with mandatory fields, but it won't actually process the form if the form passes validation.

It seems like the issue is in webform_client_form_submit because the form does not redirect after the submission either. I just get the form returned to me with the values that I entered in.

Comment #3

tom friedhof commented 29 January 2009 at 04:12

After looking into the issue, I realized that I had another module causing the issue.

I had a module removing the #value of the submit button in a form_alter, so that I could theme the button with an image and not see the text. Webform needs this value to detect multi-step forms, and since the submit button value did not equal submit, or what I defined the submit button to say within the webform module, the webform_client submit handler was returning the form prematurely.