Forms not showing up from FS Contact Form

It sounds like the plugin is no longer reading its table. Did the table prefix change?

In your database, do you have a table named wp_cf7dbplugin_submits with data in it?

So had a chance to check that out this morning. Not sure if it changed as I deleted the CFDB plugin and then the admin I work with deleted the tables from myPHPadmin. When we reinstalled the plugin it created new tables named with the prefix wpnu, so what we see now is wpnu_cf7dbplugin_submits. I submitted test forms and we checked in myPHPadmin admin and the data is there but CFDB does not see the data. I assume that this is because CFDB is looking for the wp prefix. Is there a spot to change the table the plugin looks for. I might have missed it. Thanks

Are you using WP Multi User configuration? The plugin doesn’t work with that. (Something I’m looking at fixing)

I spoke to our main admin and he tells me this is a single user install. Any other possibilities come to mind?

Do the rest of your tables in your database start with “wp_” or “wpnu_”?

The plugin simply asks WP what prefix to use. That is set in your WP configuration (you set it when you do the initial install). This table should have the same prefix as the rest of your tables.

“wp_” is the default prefix. It sounds like you had data in a table with this prefix, then the prefix was changed in the conf. The plugin started looking for a table with the new prefix but it wasn’t there. The reinstall would create the table with the new prefix but it would be empty.

So if you have data in wp_cf7dbplugin_submits and not in wpnu_cf7dbplugin_submits then you could go into your database and do:

DROP TABLE wpnu_cf7dbplugin_submits
RENAME TABLE wp_cf7dbplugin_submits TO wpnu_cf7dbplugin_submits

All the table prefixes for are wpnu_. The data when submitted is showing up in wpnu_cf7dbplugin_submits when you look at them in myPHPadmin. There isn’t presently a wp_cf7dbplugin_submits to change.

Where is the value of wp_cf7dbplugin_submits stored in the CFDB plugin? Could we make the change there? The table prefix was established by the WordPress install and we can’t change that.

Hope I am being clear.

Ok, then this isn’t a case of there being 2 tables with different prefixes.

You are misunderstanding: wp_cf7dbplugin_submits is not stored in the plugin. The plugin asks WP for what the prefix is. In your case is sounds like it is correctly getting “wpnu_”.

My initial guess was that it wasn’t reading the correct table. But that now seems wrong. So, the question is, if it is reading the correct table, why does it not see the data?

When you look at the CFDB admin page, does it indicate that there are no form submissions at all, or is there a drop-down list of form names, but when you select one it shows no data? If the latter, what is the form name?

I am a new user and downloaded Contact Form DB 2.9.16 on March 3 and I am experiencing the same issue as randybowler.

I am running Secure Contact Form version 4.0.41
I am running WordPress version 4.4.2.

The only thing I see under Export and Short Code Builder is *Select a form*

No forms show up to select.

Another update. Once I filled out the application form and sent it off, it was added automatically to Contact Form DB 2.9.16. I can now add a form to the selector for the Export and Short Code Builder page.

Data has to be present before the form can be used.

@gwally: that is the correct behavior. CFDB knows about form submissions, not form definitions.

Hi,
I have the same issue. Not form can be selected from the *select a form* drop down. The drop down appeared after I submitted a form, however, it just shows blank in the option. Cheers.

Had a chance to get back to this today. I get a blank window on the Contact Form DB page. If I click on he drop down I see a √and a blank line beside it and a *Select a Form* above.

I see that you have posted a 2.9.16 update. Any chance this is part of the fix? Just hoping.

I haven’t been able to reproduce the problem on any of my sites, so I doubt it is fixed.

Another hint. I just created a new form and sent a new email request and went back to CFDB admin page, clicked on the drop down for the form selection and the new form shows up, along with all the data!

Went back to the old form and submitted a new email. Went back and that previously created form, before the upgrades described above, is still not there in the drop down.

I really hope I don’t have to recreate the old form to get things working again.

Any ideas?

@randybowler You shouldn’t need to re-create any forms.

I’m stumped by this. If you don’t mind me looking at your site, please contact me at [email protected]