Title: Error on getting data Last modified: August 31, 2016 --- # Error on getting data * [tom1975](https://wordpress.org/support/users/tom1975/) * (@tom1975) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/) * Hello, * I have in my site ([http://hastudio-il.com/](http://hastudio-il.com/)) 2 forms. one with 3 fields and one with 4. * In the last days I noticed that in the CFDB plugin I can’t see the data of the 4 fields form but in the other form the data shown okay. * What is the problem? * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/) Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/topic/error-on-getting-data/page/2/?output_format=md) [→](https://wordpress.org/support/topic/error-on-getting-data/page/2/?output_format=md) * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405888) * If you deleted the form data, then you can’t get it back. * Assuming that is not the case, does the form name appear in the drop-down list on the CFDB Admin page? And when you select it, what appears in the window? * Thread Starter [tom1975](https://wordpress.org/support/users/tom1975/) * (@tom1975) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405897) * I didn’t deleted the form data. * The form name appear in the drop-down list. * When I select it I see this message: Returned entries 1 to 0 of 0 entries in the database * In the second form everything is ok. * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405901) * In the Dashboard, go to: * Contact Form DB -> Options -> Admin View change “Show the query used to display results” to true, Save. * Go back to the admin view and select your form again. A database query text should display on the page. Would you post that text here? * Thread Starter [tom1975](https://wordpress.org/support/users/tom1975/) * (@tom1975) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405907) * Query: SELECT `submit_time` AS ‘Submitted’, GROUP_CONCAT(if(`file` is null or length(`file`) = 0, null, `field_name`)) AS ‘fields_with_file’ FROM `wp_cf7dbplugin_submits` WHERE `form_name` = ‘צור קשר – הסטודיו’ GROUP BY `submit_time` ORDER BY `submit_time` DESC LIMIT 0,100 * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405910) * What fields are in this form? Is it just one field to upload a file? * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405911) * I’ve been playing around with this. I can get the result if I have a form entry saved but it has no fields from the form saved. Is that possible in your situation? * Thread Starter [tom1975](https://wordpress.org/support/users/tom1975/) * (@tom1975) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405913) * Hello, * I have 4 fields in this form: Name Phone Email Your message * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405914) * OK. I’m still not sure what is going on. It seems like your form entries or their field entries are deleted/missing in the database. * If you do a new submission what happens? * In your CFDB -> Options -> Saving, do you have anything in “Do not save fields” or “Do not save forms”? * Thread Starter [tom1975](https://wordpress.org/support/users/tom1975/) * (@tom1975) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405916) * I didn’t understand. What do you mean? If I do a new form? * In the “Do not save fields” written: /.*wpcf7.*/,_wpnonce * I tried to delete the plugin and install it again but it is the same… * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405917) * That setting looks OK. * If you do a new submission from that form do you see it? * Thread Starter [tom1975](https://wordpress.org/support/users/tom1975/) * (@tom1975) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405919) * That’s the problem. * If U do a new submission from that form I get an email about it but in the CFDB plugin I can’t see the details… * [craigsand](https://wordpress.org/support/users/craigsand/) * (@craigsand) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405922) * Hi – I’m getting the same issue, I’m receiving emails but no data is being saved in the database. * All my plugins have been updated to latest version. * I hope you can help! * Thanks * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [10 years ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405923) * I’m baffled. I can’t reproduce the error. * If you want me let me log into a test site that you have so that I can investigate, please email me at [info@cfdbplugin.com](https://wordpress.org/support/topic/error-on-getting-data/info@cfdbplugin.com?output_format=md) * Thread Starter [tom1975](https://wordpress.org/support/users/tom1975/) * (@tom1975) * [9 years, 11 months ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405925) * I can let you log into my site, but everything is in hebrew. Can you check it even if it’s not in English? * [advertisingtech](https://wordpress.org/support/users/advertisingtech/) * (@advertisingtech) * [9 years, 11 months ago](https://wordpress.org/support/topic/error-on-getting-data/#post-7405926) * Hello. It happens to me too. I looked in the site error log and I get this: Error Table ‘tablename.SELECT’ doesn’t exist de la base de datos de WordPress para la consulta SHOW FULL COLUMNS FROM `SELECT` realizada por do_action(‘toplevel_page_CF7DBPlug * It seems like the query is not correcly formed? Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/topic/error-on-getting-data/page/2/?output_format=md) [→](https://wordpress.org/support/topic/error-on-getting-data/page/2/?output_format=md) The topic ‘Error on getting data’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff. svg) * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/) * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq) * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/) * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/) * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/) * 19 replies * 4 participants * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/) * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/error-on-getting-data/page/2/#post-7405934) * Status: not resolved