[Plugin: Contact Form 7 to Database Extension] Possible Bug with table prefix

Discovered this bug yesterday too. It appears because of a change in version 2.4 of the plugin within the ‘getSubmitsTableName’ function of CF7DBPlugin.php (line 821).

The line used to read:

return strtolower($this->prefixTableName('SUBMITS'));

but now it reads:

return $wpdb->prefix . strtolower($this->prefix('SUBMITS'));

Whereas the code used to look for it’s db table as “abcxyz_cf7dbplugin_submits” it now looks for it’s data in “abcXYZ_cf7dbplugin_submits”, except that table doesn’t exist (or at least it doesn’t if you used the plugin before version 2.4).

The bug obviously doesn’t appear if your WP prefix is all lowercase in the first place, and neither will it show if you only used the plugin at version 2.4.

Of course the bug doesn’t just appear when trying to view the saved form data, but also when saving the form submissions in the first place.

Regards

Hi David,
thanks for this detailed report on this bug – I had better stuff to do on the weekend and forgot about it. ??
best regards

Thanks for figuring that out. That change was to fix someone else’s bug, where they had a prefix with uppercase and the plugin was incorrectly using the lowercase prefix…and in fixing that I broke it for you guys.

Renaming your table in PHPMyAdmin should fix your problem.

Sorry for the inconvenience.

Although I can do the renaming (even though there’s quite a lot of sites built using this plugin) I’m concerned that this name change is likely to catch out quite a few people.

Previous to version 2.0 the plugin db tablename had mixed-case but the upgrade routine altered it. Wouldn’t it be easy enough to add in another check (like below) and then no-one will have this issue?

if ($this->isVersionLessThan($savedVersion, '2.4')) {
  // Version 2.4 upgrade
  $tableName = $this->getSubmitsTableName();
  $oldTableName = strtolower($tableName);
  $wpdb->query("RENAME TABLE '$oldTableName' TO '$tableName'");
}

Best regards

Yes, that is a good ideal. I’ll put that in.

Hi I also created a new post on the similar problem that the form does not seem to pick up the DB.

I checked my database now and my table is named correctly, my prefix is “cgc” in lower case and the table name is “cgcf7dbplugin_submits”.

but the plugin does not seem to save the data. Or it does not even see it to show the forms?

I solved it by replacing the code as it was previously and it worked

I am having the same problem, it seems — none of the form submissions are being saved to the database. I have just installed both plugins (Fast Secure Contact Form, and the Database extension) and have tested the form three times. Nothing shows up when I view the Database.

I do have the option selected in the settings to enable data export.

Worth mentioning, when I installed and activated the Database plugin, I received a message that said, “The plugin generated 1552 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.”

Could this be related to the problem? I have tried deactivating, deleting, and reinstalling the database plugin, and it still acts the same.

Any help would be appreciated.

check to see if the database table it uses is there. There may be error messages resulting from not having permission to create a table.

Is that the only thing it could be? I have limited access to this account (no FTP, no cPanel, no phpMyAdmin) so can only manage through the actual WordPress interface. With enough time and effort I could maybe get access, but just wondering if there’s any other advice in the meantime, as this is a fairly time sensitive issue.

If not, any recommendations for another plugin that gives a database functionality I can use with Fast Secure Contact Forms?

By the way, if the error is resulting from not having permission to create a table, how would I go about granting the needed permission?

I don’t know for sure since we don’t have the error message. But someone else saw the same kind of symptoms and that was the problem. If you can’t get PHPMyAdmin access, then I don’t know how you could change any permissions.

@ Michael Simpson
Firstly, Thanks for such a beautiful plugin which solves & Serves better than others.
Secondly, i want to know that using contact form 7 to database extension (cf7 to DB) saves the submitted form data to mysql database directly which can further be processed from there or it saves the submitted form data some where else in the plugin folder. and where the uploaded files are stored as an attachment along with the contact form 7.

Thanking You In Advance (Sir)

Everything is stored in the DB

Thanks For The Faster Reply… All In MySql DataBase.

Great Going Sir !

Hi Given all the great advice above:

Can you please spell out the steps I need to take to fix this problem. I have access to PHPmyadmin