Support » Plugin: Contact Form 7 » field data in database, but not showing in form fields

  • Resolved mixette

    (@mixette)


    Hello,

    My websites has about 20 forms, most of them with form, mail and mail 2.
    I don’t now exactly how, but I suspect after a wordpress update (to 3.4.1) These fields were all empty. When I look into the databse I can see all the form data is still in wp-posts (post type wpcf7_contact_form). I did not change database or migrate the website.
    The names and id of the data stored in the database is correct and somehow when clicking the form settings all fields are empty now.

    I tried downgrading and upgrading the contact form 7 plugin already, but that’s not changing anything.

    Does anyone have any clue what might cause this?

    Thanks,
    Britt

    http://wordpress.org/extend/plugins/contact-form-7/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Takayuki Miyoshi

    (@takayukister)

    Can you see the titles of the forms in the Contact Form 7’s management page?

    What happens if you deactivate all other plugins and switching to the default theme?

    And, can I see the site?

    Hello Takayuki Miyoshi,

    Deactivating all plugins and switching to Twenty Eleven does not change anything.
    I can see the titles, they match the titles in the database. Id’s and othe fields seem to be correct and are show in the settings page in wordpress. So in fact it’s only the post_content field that fails to show.
    Is it correct that all text from the fields in the form section, the mail section and the mail2 section is stored in the “post_content” field? How is this spliced up into fields?

    Can I send the website link to your gmail address?

    Thanks for looking into this!
    Britt

    Plugin Author Takayuki Miyoshi

    (@takayukister)

    OK. Maybe serialized data in the wp_postmeta table got broken somehow. Do you have any idea of the cause?

    Form, Mail, Mail2, Messages and Additional Settings data are stored in the wp_postmeta table. Form and Additional Settings are plain text, but Mail, Mail2 and Messages are stored as serialized array values.

    I don’t have any idea of the cause.
    I can see the data in the wp-postmeta table, it’s there.
    Post_id matched the id of the form and there are 5 fields: _form, _mail, _messages, _additional_settings, _mail_2. These fields have content, except for additional settings.

    An example of the content of a _mail_2 field:

    a:8:{s:6:"active";s:1:"1";s:7:"subject";s:14:"[your-subject]";s:6:"sender";s:28:"Company email <info@company.be>";s:4:"body";s:156:"Bonjour [your-name]
    
    Nous vous remercions pour votre demande. Nous vous contacterons le plus vite possible.
    
    Sincères salutations,
    Company name";s:9:"recipient";s:12:"[your-email]";s:18:"additional_headers";s:0:"";s:11:"attachments";s:0:"";s:8:"use_html";s:1:"1";}
    Plugin Author Takayuki Miyoshi

    (@takayukister)

    a:8:{s:6:"active";s:1:"1";s:7:"subject";s:14:"[your-subject]";s:6:"sender";s:28:"Company email <info@company.be>";s:4:"body";s:156:"Bonjour [your-name]
    
    Nous vous remercions pour votre demande. Nous vous contacterons le plus vite possible.
    
    Sincères salutations,
    Company name";s:9:"recipient";s:12:"[your-email]";s:18:"additional_headers";s:0:"";s:11:"attachments";s:0:"";s:8:"use_html";s:1:"1";}

    This serialized value seems corrupted. Maybe something (other plugin or theme?) has changed the text directly. Unfortunately, you can’t repair it automatically. You need to make new forms again if you don’t have backup (export file).

    Could it be possible that using a hypen (like this: – ) in the name of the contact form would cause the plugin to go crazy?
    If I upgrade from wordpress 3.4.1 to 3.4.2 and contact form 7 3.3.1 I manage to recover a part of the data of the forms, but those with a hypen in the title have empty fields.

    Plugin Author Takayuki Miyoshi

    (@takayukister)

    No. There is no relation between form title and currupted serialized value.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘field data in database, but not showing in form fields’ is closed to new replies.