Error after update to Contact Form 7

  • Resolved Luke

    (@lhanyok)


    11 years, 5 months ago

    Not sure what’s going on, but I deactivate Contact Form 7 and still get these errors. Deactivate the DB plugin and they go away. Haven’t tried deleting and re-installing, don’t want to lose the database data.

    The plugin generated 957 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

    Also get these errors:

    WordPress database error: [Duplicate column name 'field_order']
ALTER TABLE <code>wp_cf7dbplugin_submits</code> ADD COLUMN <code>field_order</code> INTEGER

WordPress database error: [Duplicate column name 'file']
ALTER TABLE <code>wp_cf7dbplugin_submits</code> ADD COLUMN <code>file</code> LONGBLOB

WordPress database error: [Duplicate key name 'submit_time_idx']
ALTER TABLE <code>wp_cf7dbplugin_submits</code> ADD INDEX <code>submit_time_idx</code> ( <code>submit_time</code> )

WordPress database error: [Duplicate key name 'form_name_idx']
ALTER TABLE <code>wp_cf7dbplugin_submits</code> ADD INDEX <code>form_name_idx</code> ( <code>form_name</code> )

    https://www.ads-software.com/extend/plugins/contact-form-7-to-database-extension/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    Looks like it is trying to create or modify the database table it uses which already exists. After it is activated, does the error keep happening or does it go away?

    Thread Starter Luke

    (@lhanyok)

    Thanks for the quick reply.

    Even with Contact Form 7 deactivated I still get the errors from Contact Form DB when it’s reactivated.

    The errors are there as long as the plugin is activated. Right now I have it deactivated and everything is working normally. As soon as I activate it again it pops up with the the “plugin generated 957 characters” error and the other database errors as well.

    I tried deleting the plugin and re-installing, but still the same results.

    Plugin Author Michael Simpson

    (@msimpson)

    Deactivating Contact Form 7 should be irrelevant. Can you back up and tell me how this started? Was the plugin installed and activated and worked OK before? Then what changed? An upgrade?

    Thread Starter Luke

    (@lhanyok)

    I just did the upgrade to WP 3.5.2 and had a bunch of other plugin updates as well. Got those errors immediately after on the dashboard.

    I thought Contact Form 7 might have something to do with it since that just updated.

    Plugin Author Michael Simpson

    (@msimpson)

    The plugin keeps track of its version in the database and uses that to perform upgrade actions. Seems like that value is lost.

    He is what I want you to do:

    – In you WP admin panel -> Plugins
    — Locate Contact Form DB
    — Note the version number
    — click Edit link
    – Search for “CF7DBPlugin.php” and click on that link
    – Find this line:
    //'_version' => array('Installed Version'), // For testing upgrades
    Remove the leading // so it looks like:
    '_version' => array('Installed Version'), // For testing upgrades
    – Update File button
    – admin -> Contact Form DB -> Options
    – First thing should be “Installed Version”.
    – Make that match the version noted earlier, then Save

    Thread Starter Luke

    (@lhanyok)

    That did it. No more errors. Should I do anything else with this for now or do you need any more info?

    Plugin Author Michael Simpson

    (@msimpson)

    I think you are good to go now.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error after update to Contact Form 7’ is closed to new replies.