[Plugin: Contact Form 7 to Database Extension] Returned entries in database not viewable

Try uninstalling again, but also go into the database and drop the table if it is still there. It should get removed when you uninstall but maybe it is there but did not get correct column changes that came with 1.8.

So if you can get to your database via PHPMyAdmin or something like that, drop table wp_CF7DBPlugin_SUBMITS then go about re-installing the plugin.

Thanks Michael,

I did try your suggestion however but still the same issue. The table was not present when I removed the plugin.
I then decided to re-install, dropped table, removed plugin again and then re-installed but same issue. Not shown any visible table entries, only the message “Returned entries 1 to 0 of 2 entries in the database” after I had inserted a couple of test items from my contact form.
If I go back into phpMyAdmin, I can see the two records I have entered, just not shown up in the settings page for the template.

All very weird.

Just to add, I had forgot to re-do all the admin settings.

Have since done this and also set “Maximum number of rows to retrieve from the DB for the Admin display” to 100 and the message has now changed to “Returned entries 1 to 3 of 3 entries in the database” but still not showing the table (only viewable in phpMyAdmin)

In the Database Options page, set Show the query used to display results to true.

Then go back to the Database page to see the query. Try that query in MySQL and see if it results in an error. Post the query here if it isn’t working so I can have a look.

Hi Michael,

Set the Show the query used to display the results to true but does not show anything, only the same message as mentioned before.
“Returned entries 1 to 3 of 3 entries in the database”

What version of PHP are you running?

Hi Michael,

MYSQL Version : 5.0.77
SQL Mode : Not set
PHP Version : 5.1.6
PHP Safe Mode : Off
PHP Allow URL fopen : On
PHP Memory Limit : 256M
PHP Max Upload Size : 2M
PHP Max Post Size : 8M

I’ve also checked my wp-config file and the following is in place:
define(’WP_MEMORY_LIMIT’, ’64M’);

Thanks for all your help so far.

Hi Michael,

I updated my test wordpress site which I originally used to create this website and matched with the same plugins etc. The only thing I could find was a difference when viewing the table data for Database plugin via PhpMyAdmin.
Now I am not very familiar with this (bit of a noobie) but I noticed the last column on my working test site has a value of ‘BLOB_01’ for each record item, but on the live site, each record has a value of ‘BLOB_NULL’. I do not know what this means, or if this is the issue?

Rolled back to Ver 1.7 of Database plugin and its working again.

I suspect my host site has a older version of PhpMy Admin ??

What do I need to inform them (host) to enable me to use your later version, or am I ok to stick with Ver 1.7 of the plugin for now?

I see I just opened the same bug, with the same problem (should have checked the forum first. sorry for that).

Worked like a charm, until I upgraded. I do not want to drop my tables, as I am a couple of weeks before the event I use the forms for.

Hoe did you roll back to 1.7?

Hi jzomer – I managed to find this link from the WordPress plugins page. For me, rolling back to Ver 1.8 was not enough and as I have very little data, I didnt have an issue deleting ver 1.81 (incl. data) and rolling back. Good luck.

Contact Form 7 Versions

Yeah, found that one too. But how to install it without losing my data? Disabling and updating refuses (as ‘a newer version is present’).

note to self: backup tables soon.

Not sure on that one buddy

I get a 404 on this JS

/wp-content/plugins/contact-form-7-to-database-extensiondt_i18n/nl.json

The dir does not exist. It is (without i18n)

/wp-content/plugins/contact-form-7-to-database-extensiondt/nl.json

Sorry:

/wp-content/plugins/contact-form-7-to-database-extension/dt_i18n/nl.json

a missing slash…

where is this in the code? JSonEncode??