Submissions are being saved but not displaying

What is the name of the form in the drop-down?

Does it work for other form names?

The name is “Hong Kong Roundtable Survey” it is the longest form name in the list. It is also the only multi-page form I’ve created, FWIW.

I’m using Caldera 2.0.4.1 forms by the way. I’ve changed the name to ‘hk’ and submitted a new entry – still nothing

Thanks

OK. I thought perhaps there was a special character in the name that is not being represented right in the query of the database. But that seems not to be the case.

From what I understand, when you select the form name in the administration page it shows no entries. So I would like to test that query that gets that data.

In the CFDB Options page, there is an option to display the Database query on the admin page. Set that to “true”.

Go back to the admin page and select your form. The MySQL query should display at the bottom of the page.

Copy that query and try it in your PHPMyAdmin. Does it give you an error? Does it return results? Please past the query and error here.

Thanks

It give me the all the expected results I am not seeing in WP admin. No error!

Yikes. I have to think about this some more…

Please email me, I want to ask you about your site: [email protected]

After a long process of elimination it seems that the culprit is curly quotes in the field_name column. Yes, I did copy my text from MS Word.

It didn’t appear at first because it was on a un-required question.

Also, FWIW it’s a bit fiddly to use PHPMyAdmin to edit the database because cf7dbplugin_submits doesn’t have a unique column.

I can work around, but hopefully it’s a simple fix for the future.

Thanks for a great plugin and excellent support

Thanks for figuring this out. I tried a Caldera form with a “hello” field name that I copied from MS Word and it seems to work for me. I also tried those quotes in the field value that works OK.

Would you give me some more specific detail about the field name you have and its type?

FYI, To change the field name for all the submissions you can run the MySQL query:

update wp_cf7dbplugin_submits
set field_name = 'New field name'
where field_name = 'Old field name'

But remember to change the field name in your Caldera form definition as well.

I had single curly quotes in my field name…

Building more ‘native’ online content…