WordPress.org

1. noorg
   Member
   Posted 11 months ago #
   

   Hi,
   yesterday I updated my WordPress-Installation to 3.4 and a couple plugins (including Contact Form 7 to Database Extension) as well. After this update all my data "vanished".

   I looked into phpmyadmin and found the table with all my data, but the plugin doesn't detect it and I noticed a oddity in the naming of the cf7dbplugin_submits table. I use a table prefix with approximately this pattern 'abcXYZ_'. All tables use *exactly* this prefix, only the cf7dbplugin_submits table was named "abcxyz_cf7dbplugin_submits" (all lowercase). After renaming the table to abcXYZ_cf7dbplugin_submits all data entries were back.

   The plugin used to work fine before. Because I won't be able to verify this bug before Saturday I decided to report this now.

   best regards

   http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/

2. David
   Member
   Posted 10 months ago #
   

   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

3. noorg
   Member
   Posted 10 months ago #
   

   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

4. Michael Simpson
   Member
   Plugin Author
   Posted 10 months ago #
   

   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.

5. David
   Member
   Posted 10 months ago #
   

   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

6. Michael Simpson
   Member
   Plugin Author
   Posted 10 months ago #
   

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

7. Tienie
   Member
   Posted 10 months ago #
   

   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?

8. Tienie
   Member
   Posted 10 months ago #
   

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

9. nyladenise
   Member
   Posted 10 months ago #
   

   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.

10. Michael Simpson
    Member
    Plugin Author
    Posted 10 months ago #
    

    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.

11. nyladenise
    Member
    Posted 10 months ago #
    

    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?

12. Michael Simpson
    Member
    Plugin Author
    Posted 10 months ago #
    

    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.

13. Himanshu Goel
    Member
    Posted 3 months ago #
    

    @ 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)

14. Michael Simpson
    Member
    Plugin Author
    Posted 3 months ago #
    

    Everything is stored in the DB

15. Himanshu Goel
    Member
    Posted 3 months ago #
    

    Thanks For The Faster Reply... All In MySql DataBase.

    Great Going Sir !

16. Johanhorak
    Member
    Posted 1 week ago #
    

    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

17. Michael Simpson
    Member
    Plugin Author
    Posted 1 week ago #
    

    @Johanhorak
    Issues related to this thread were fixed in the plugin months ago. Please describe in detail the problem you are seeing so I can know if it is the same or something different.

18. Johanhorak
    Member
    Posted 1 week ago #
    

    Hi Michael

    I should have started a new threat. I will ;-)

Reply

You must log in to post.