webform content not getting saved to db, not showing up on "results this webform"
clairej - August 26, 2008 - 18:33
My site is in Drupal 5.7 and have converted all my surveys to webforms using the survey_webform_migrate module. I have a webform with several form components. When I look at the webform_submitted_data table using MySQLadmin, I can see that data from only three fields is being saved to the database (my webform has 5 fields), and there is no obvious logic to how the module is assigning cids (which I assume stands for component ids). Also, when I click on "results this webform" while logged in as an admin, I see only the data from those same three elements (which I guess is not so surprising if the data is not in the db).
Has anyone else experienced either of these problems with webforms? I am concerned that I am losing data.
Have you checked your log to
Have you checked your log to see what, if any, errors are recorded there?
Checked the log...
Didn't see anything that had anything to do with webforms. Do you have any other ideas?
No MySQL errors?
Usually when I see something like this, there's a SQL error in the log that pertains to the Email field type for CCK. I'm not familiar with the webform module but I thought it might use the CCK fields.
Anyway, if that's what it is, I fix it by going into the table for that content type and setting the default value for the email field as NULL.
Hmm, no mysql errors.
And the email functionality is working fine. That is, all data is sent intact to the mailto address specified. But some of it never makes it into the db...
Install Devel module and look at the queries
Then you can see what it's trying to do, anyway.
The Devel module broke my site...
When I installed it I got the old white screen. I was really hoping that would work because it looked really useful...
data loss when saving webform
This looks like a problem I had and was helped with the advice of upgrading to webform 2.2 (5.x-2.2 in your case)
-Brad