I read in the README.txt that all the submitted data are collected in a database table. Our webform has multiple data to be submitted, which is very important to us.

When I check the database, the only thing I find is five columns: sid, nid, uid, submitted, remote_addr. Their content provides no useful data (numbers and an IP). There's also a warning that says: PRIMARY and INDEX keys should not both be set for the column 'sid'.

I've tested the contactform for a couple of times now and I still can't find any of the data I submitted, not in webform_submissions or any other webform table.

Can you help me out?

Comments

knalstaaf’s picture

knalstaaf commented

P.S.: Accessing the submitted data through the Drupal admin is no problem. I'm strictly talking about the database and its tables. The data must be in there, but where?

It's mandatory that we have these data in a solid database in order to export these data for other applications.

djalloway’s picture

djalloway commented

What form are you referring to when you say "contact form" ?
Is it the core Drupal Contact Form? or a custom Webform you created to be the Contact Form?

The Webform module has a few key tables that deal with data it collects.

webform_submissions
webform_submitted_data

The submissions table keeps records of the who and where the form was submitted and the submitted data table contains the actual data that was submitted, the records are tied together via the SID column.

But the ONLY data it collects is data submitted via a Webform node.

Just trying to clarify a bit as your post is a bit confusing when I'm trying to figure what it is you're doing exactly.

knalstaaf’s picture

knalstaaf commented

I'm talking about webform indeed. Thanks for your reply. I believe that's the very answer to my question.

djalloway’s picture

djalloway commented
Status: Active » Closed (fixed)

glad I could help