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.
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
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 )
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.
Sorry Michael,
I forgot to add semicolons at the end of each sentence. Let me see if that solved the problem.
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.