WordPress.org

Ready to get started?Download WordPress

Forums

Contact Form 7
[resolved] field data in database, but not showing in form fields (8 posts)

  1. mixette
    Member
    Posted 1 year ago #

    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/

  2. Takayuki Miyoshi
    Member
    Plugin Author

    Posted 1 year ago #

    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?

  3. mixette
    Member
    Posted 1 year ago #

    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

  4. Takayuki Miyoshi
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  5. mixette
    Member
    Posted 1 year ago #

    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";}
  6. Takayuki Miyoshi
    Member
    Plugin Author

    Posted 1 year ago #

    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).

  7. mixette
    Member
    Posted 1 year ago #

    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.

  8. Takayuki Miyoshi
    Member
    Plugin Author

    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic