• Resolved bushbird

    (@bushbird)


    Hi I created a contact form using contact form 7. the form doesn′t submit anything to the database though. I click on the database link but comes up.

    No form submissions in the database

    The form send emails perfect though.

    Is there a basic tutorial for the plugin?

Viewing 6 replies - 1 through 6 (of 6 total)
  • govpatel

    (@govpatel)

    I do not think it is set up to save the submission in database.

    If this is version 1.4, there was a bug when you install it fresh instead of an upgrade. I fixed it so you now have to re-download 1.4 again and install. But you may need to wait for a few hours for this to be up to date on the www.remarpro.com site.

    Thread Starter bushbird

    (@bushbird)

    I submitted this info and still don′t see anything in database. I reinstalled version 1.4 about an hour after your reply
    If you could help I will gladly make a donation…

    This is what I have in form

    <p>Your Name (required)
    [text* your-name] </p>

    <p>Your Email (required)
    [email* your-email] </p>

    <p>Subject
    [text your-subject] </p>

    <p>Your Message
    [textarea your-message] </p>

    <p>Attachment
    [file your-file filetypes:pdf|gif|png|jpg|jpeg|doc|txt]
    [file your-file2 filetypes:pdf|gif|png|jpg|jpeg|doc|txt]
    [file your-file3 filetypes:pdf|gif|png|jpg|jpeg|doc|txt]</p>

    <p>[captchac captcha-909]
    [captchar captcha-909]</p>
    <p>Verification – Please insert the code shown above</p>

    <p>[submit “Send”]</p>


    THIS IS WHAT I HAVE IN MESSAGE BODY

    <table width=”100%” border=”0″><tr><td>
    From: [your-name] <[your-email]>
    Subject: [your-subject]

    Message:
    [your-message]

    Attachment:
    [your-file][your-file2][your-file3]</td></tr></table>

    This mail is sent via contact form on The Newman Clan https://www.thenewmanclan.com/thenewmanclan

    I think the likely problem is the database table needed for this plugin is missing or did not pick up the new fields needed for version 1.4.

    If you can get to a MySQL Admin page to look at your database, check this:

    1. Does this table exist: wp_CF7DBPlugin_SUBMITS ?
    — If not, create it using SQL:

    CREATE TABLE IF NOT EXISTS wp_CF7DBPlugin_SUBMITS (
                submit_time INTEGER NOT NULL,
                form_name VARCHAR(127) CHARACTER SET utf8,
                field_name VARCHAR(127) CHARACTER SET utf8,
                field_value LONGTEXT CHARACTER SET utf8,
                field_order INTEGER,
                file LONGBLOB)
    ALTER TABLE wp_CF7DBPlugin_SUBMITS ADD INDEX  submit_time_idx ( submit_time )

    2. If may exist, but not have new fields “field_order” and “file”.
    — If this is the case run SQL:

    ALTER TABLE wp_CF7DBPlugin_SUBMITS ADD COLUMN field_order INTEGER
    ALTER TABLE wp_CF7DBPlugin_SUBMITS  ADD COLUMN file LONGBLOB
    ALTER TABLE wp_CF7DBPlugin_SUBMITS ADD INDEX  submit_time_idx ( submit_time )

    Thread Starter bushbird

    (@bushbird)

    Thanks for the update. I checked out the database and saw the field

    “file LONGBLOB”

    I changed it to VARCHAR(255) and saved. The form now works perfect.

    I can access the database and see everything.

    if you change that field to VARCHAR instead of a BLOB, then if you have a file upload on a form it will probably not work. I don’t understand why you had to change the definition of that field.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Plugin: Contact Form 7 to Database Extension] Dont See Any data at all’ is closed to new replies.