Title: Duplicate column issue
Last modified: August 21, 2016

---

# Duplicate column issue

 *  Resolved [robert.glez](https://wordpress.org/support/users/robertglez/)
 * (@robertglez)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/)
 * Hello,
 * despite updating to the latest plugin version 2.8.1., supposed to address this
   bug, I’m still affected by it. I believe the error was caused by previous versions
   and it persists because of them although the bug is fixed by the latest vesion.
 * How can I solve it? This is a screenshot of my site whenever I activate the plugin:
   
   [http://oi60.tinypic.com/2q1bdab.jpg](http://oi60.tinypic.com/2q1bdab.jpg)
 * Many thanks!
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088214)
 * That is actually a different issue. 2.8.1 fix was duplicate column appearing 
   in short code output.
 * Your install seems to think it needs to upgrade from a previous version. Run 
   this query in your DB:
 * `select * from wp_options where option_name = 'CF7DBPlugin__version'`
 * You should have 2.8.1 a the value. If set to something else, run:
 * `update wp_options set option_value = '2.8.1' where option_name = 'CF7DBPlugin__version'`
 * if it is not there, insert it:
 * `insert into wp_options (option_name, option_value) values ('CF7DBPlugin__version','
   2.8.1')`
 * Similarly check:
 * `select * from wp_options where option_name = 'CF7DBPlugin__installed'`
    Value
   should be 1.
 *  Thread Starter [robert.glez](https://wordpress.org/support/users/robertglez/)
 * (@robertglez)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088260)
 * Thank you! The option_value for CF7DBPlugin__version was blank. Once set it works
   well again.
 * Thank you very much, Michael.
 * Best regards,
 * Roberto
 *  Thread Starter [robert.glez](https://wordpress.org/support/users/robertglez/)
 * (@robertglez)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088338)
 * Two days later the same problem has occured, the option_value for CF7DBPlugin__version
   gets blank and then that error shows up on frontend again.
 * Any idea on how to solve it permanently?
 * Many thanks
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088351)
 * Try this: Edit the plugin, find the file **CF7DBInstallIndicator.php**
 * Scroll to the bottom of the file and find:
 *     ```
       protected function saveInstalledVersion() {
               $this->setVersionSaved($this->getVersion());
           }
       ```
   
 * change it to:
 *     ```
       protected function saveInstalledVersion() {
               $version = $this->getVersion();
               if ($version) {
                   $this->setVersionSaved($version);
               }
           }
       ```
   
 *  Thread Starter [robert.glez](https://wordpress.org/support/users/robertglez/)
 * (@robertglez)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088353)
 * Thank you, Michael. That change kept the error showing up, even after disabling/
   reenabling the plugin.
 * What I did is to backup the site, disable and DELETE the plugin, and install 
   it again. The problem has disappeared so far and happily the database with all
   the forms was kept.
 * I will keep an eye on the issue for a couple days to see if the error returns
   and I’ll let you know.
 * Many thanks!
 *  Thread Starter [robert.glez](https://wordpress.org/support/users/robertglez/)
 * (@robertglez)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088362)
 * Unfortunately the error has come back again and have had to disable the plugin,
   even in the latest version 2.8.3.
 * May my database be corrupted? Perhaps I’ll have to erase all cf7db registers?
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088364)
 * This isn’t a data issue. It seems to be a weird issue where the plugin can’t 
   tell what version it is or can’t save it to the DB. The plugin has a file indicate
   which version it is and it saves that also to the DB. When it activates, it checks
   if the version in the code file is different from what is in the DB. If so, it
   runs update actions. Seems like yours keeps getting deleted.
 * If you like, send me a login to your site at [info@cfdbplugin.com](https://wordpress.org/support/topic/duplicate-column-issue/info@cfdbplugin.com?output_format=md)
   and I’ll see if I can debug it.
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088368)
 * I can’t reproduce this problem, especially since it seems only to turn up after
   a while. But I changed some code to try to detect the situation and avoid getting
   the error text on the page that you are seeing. Please download and try the [latest development version](http://downloads.wordpress.org/plugin/contact-form-7-to-database-extension.zip)(
   2.8.4RC1)
 *  Thread Starter [robert.glez](https://wordpress.org/support/users/robertglez/)
 * (@robertglez)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088387)
 * It’s been working alright for these 4 days with 2.8.4RC1 🙂 I’ve updated now 
   to 2.8.5 and also updated and reenabled the plugin on another site that had the
   same error.
 * I’ll be checking on it for some more days but now it seems resolved (fingers 
   crossed).
 * Thank you very much for all your help.
 * Kind regards,
 * Roberto

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Duplicate column issue’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 9 replies
 * 2 participants
 * Last reply from: [robert.glez](https://wordpress.org/support/users/robertglez/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/duplicate-column-issue/#post-5088387)
 * Status: resolved