[Plugin: Contact Form 7 to Database Extension] Data Submissions Not Appearing

  • Resolved tsmulugeta

    (@tsmulugeta)


    13 years ago

    Hi,

    When I submit a form I receive an email but the form submissions do not appear under DATABASE in the WordPress Admin area.

    I have Contact Form 7 and Contact Form 7 DB Extension, and I have WordPress 3.1 on a Linux Server. I am not getting any data written to the database. Also, I installed Contact Form 7 DB Extension but I don’t seem to have wp_CF7DBPlugin_SUBMITS in my PhpMyAdmin.

    I don’t know php or WordPress very well so any help is very much appreciated. I am willing to provide back-end passwords and the like if you need to see what is going on.

    Thanks!!!!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Md Mahmudur Rahman

    (@mamun155)

    13 years ago

    Hi,

    Please check whether you have installed the Contact Form 7 DB Extension plugin correctly. You should see the wp_CF7DBPlugin_SUBMITS table if you have installed the plugin correctly.

    Try re-installing the plugin (Contact Form 7 DB Extension) instead.

    Good luck.

    Thread Starter tsmulugeta

    (@tsmulugeta)

    13 years ago

    Hi Mamum,

    Thanks for your response. I have de-installed and re-installed the plugin several times with no luck. I am very confused as to what is going on. Here is my personal email address (tsmulugeta@yahoo.com). I would be happy to email you the info to the back-end so you could take a look at it if you want because currently I am very stuck.

    Thanks again Mamun for your response.

    Best Regards, Rosa

    Plugin Author Michael Simpson

    (@msimpson)

    13 years ago

    The following is what the install runs on the DB to create the table. Try running these commands directly from PhpMyAdmin

    CREATE TABLE IF NOT EXISTS wp_CF7DBPlugin_SUBMITS  (
            submit_time DECIMAL(16,4) 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 )

ALTER TABLE wp_CF7DBPlugin_SUBMITS  ADD INDEX form_name_idx ( form_name )

ALTER TABLE wp_CF7DBPlugin_SUBMITS  ADD INDEX form_name_field_name_idx ( form_name, field_name )
    Thread Starter tsmulugeta

    (@tsmulugeta)

    13 years ago

    Hi Michael,

    Thanks for your response. I ran this command into my PhpMyAdmin in several different ways but I keep getting a syntax error:

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IF NOT EXISTS wp_CF7DBPlugin_SUBMITS ( submit_time DECIMAL(16,4) N’ at line 1

    I have pasted the code in several different ways and I keep getting different types of syntax errors.

    Thread Starter tsmulugeta

    (@tsmulugeta)

    13 years ago

    Sorry Michael,

    I forgot to add semicolons at the end of each sentence. Let me see if that solved the problem.

    Thread Starter tsmulugeta

    (@tsmulugeta)

    13 years ago

    IT IS WORKING!!!!!!! Michael and Mamun thank you for all your help. I really appreciate it. YOU GUYS ROCK AND THIS PLUGIN ROCKS!!!!! I hope one day soon I can help you guys with any questions you guys might have.

    Take Care!

    (for anyone who might have this problem in the future: You need to login to your C-panel for your website and click PhpMyAdmin and then select the database that corresponds to your WordPress site (that you created on installation), select it, and then press the SQL button and type the code above but make sure to add a semi-colon after each line). Everything should then work.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Plugin: Contact Form 7 to Database Extension] Data Submissions Not Appearing’ is closed to new replies.