Duplicate column issue

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.

Thank you! The option_value for CF7DBPlugin__version was blank. Once set it works well again.

Thank you very much, Michael.

Best regards,

Roberto

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

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);
        }
    }

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!

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?

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 [email protected] and I’ll see if I can debug it.

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 (2.8.4RC1)

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