[plugin: Contact Form 7 2.0] Upgrade fails?

I tried updating to version 2.0.1 but still I have a problem.
“The database table for Contact Form 7 does not exist. You must create the table for it to work.”
When i click “create the table”
nothing happens, continue to display the information to create a table.

@maestro2012 what version of WordPress, MySQL and PHP do you use? And didn’t you see any other messages?

As I wrote above I use WordPress 2.8.2,
MySQL Version: 5.0.51b
PHP Version: 5.2.10.
The problem with the installation occurs on an external server. On the localhost I don’t have any problems with the update.
No other messages. There are no PHP errors.

Regards.

@maestro2012 thank you. I think this issue is related to MySQL, if you are not using some kind of unusual plugins.

If you know about database, could you execute this SQL on the database and tell me the result, please?

SHOW TABLES LIKE '%contact_form_7'

I fixed. I did not have that table …contact_form_7 on an external server. It may have been deleted in the unsuccessful attempts to update.
I copied this table from my localhost wordpress and updated plugin. Now it works. Thank you for your help in finding a solution.

I have exactly the same problem as maestro2012. I get these msg’s in my error_log. By the way I get the same kind of msg from Twitter Tools – it seems that some of my plugins are unable to create tables. Though I see tables from NextGen Gallery and Wassup existing and working.

Here is error_log:

WordPress database error Table 'mydb.wp_contact_form_7' doesn't exist for query SELECT * FROM wp_contact_form_7 WHERE cf7_unit_id = 1 made by require, require_once, include, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, wpcf7_contact_form_tag_func, wpcf7_contact_form

Takayukister

Sorry for my very late reaction, due to holiday etc. I deleted Contact Form 7 every where I could without results. Finally I rebuild the complete website with a new database and all problems are gone (even for WP-table-reloaded).

Thanks for the suggestions.
Jan

Yes and any ideas for these who do not wish to rebuild the site?

I tried deleting, re-uploading with and without disabling CF7 first and both give the same result:

The database table for Contact Form 7 does not exist. You must create the table for it to work.

NOTE: I checked my database and there is no contact_form_7 or whatever the plugin’s associated table is called there. There are only:

wp_cformsdata
wp_cformssubmissions
wp_comments
wp_links
wp_options
wp_postmeta
wp_posts
wp_terms
wp_term_relationships
wp_term_taxonomy
wp_usermeta
wp_users

I am guessing the CFORMS plugin I used as an alternative for Contact Form 7 caused the conflict, but I have disabled CFORMS before trying to get Contact Form 7 working, so I assume it is not CFORMS fault.

I was also having trouble upgrading/installing Contact Form 7 on one of my sites, because it wasn’t creating the database table for me.

Another site did successfully install so my resolution to the problem was in copying the database table from the one site to the other using PHPMyAdmin… here’s the code I used:

CREATE TABLE
wp_contact_form_7` (
  cf7_unit_id bigint(20) unsigned NOT NULL auto_increment,
  title varchar(200) NOT NULL default '',
  form text NOT NULL,
  mail text NOT NULL,
  mail_2 text NOT NULL,
  messages text NOT NULL,
  additional_settings text NOT NULL,
  PRIMARY KEY  (cf7_unit_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

Not sure if that will work as pasted above because it’s removing some of the formatting… so, here’s a link to a sql with the correctly formatted code in it, open it then run the query in MySQL or via PHPMyAdmin: https://www.weblifellc.com/images/wp_contact_form_7.sql

@brmecham – Thanks mate. This worked a treat. Not sure what happened with my install? I retried it several times and got the same error:

‘The database table for Contact Form 7 does not exist. You must create the table for it to work.’

I installed the latest WP (2.9.1) and the latest Contact Form 7 (2.1) on my other machine last night (PC) – no problem.

Yet tonight on my Mac I have to run your SQL to get the CF7 up and running. Weird.

Cheers,

Just disable the plugin before upgrading to avoid this problem.