No Data Available in Table

  • mkormendy

    (@mkormendy)


    8 years ago

    None of my forms appear to have any data.

    I am using Gravity Forms to collect the data.
    As well I am also on multisite, but the main site is the only one that has forms available.

    When I go to view any form’s contents with Contact Form DB, they all say “No Data Available in Table”. However, when I go to the database and look at them directly, data is collected, in both the contact form db tables, as well as the tables from Gravity Forms

    The error log in the wp-content folder has the following:

    [26-Nov-2016 10:36:42 America/Chicago] WordPress database error Table 'wp_database.one' doesn't exist for query SHOW FULL COLUMNS FROM one made by do_action('toplevel_page_CF7DBPluginSubmissions'), call_user_func_array, CF7DBPlugin->whatsInTheDBPage, CFDBViewWhatsInDB->display, ExportBase->getDBRowCount
[26-Nov-2016 10:36:42 America/Chicago] WordPress database error Table 'wp_database.one' doesn't exist for query SHOW FULL COLUMNS FROM one made by do_action('toplevel_page_CF7DBPluginSubmissions'), call_user_func_array, CF7DBPlugin->whatsInTheDBPage, CFDBViewWhatsInDB->display, ExportBase->getDBRowCount
[26-Nov-2016 10:36:42 America/Chicago] WordPress database error Table 'wp_database.one' doesn't exist for query SHOW FULL COLUMNS FROM one made by do_action('toplevel_page_CF7DBPluginSubmissions'), call_user_func_array, CF7DBPlugin->whatsInTheDBPage, CFDBViewWhatsInDB->display, ExportToHtmlTable->export, ExportBase->setDataIterator, CFDBAbstractQueryResultsIterator->query, CFDBWpdbResultIterator->queryDataSource
[26-Nov-2016 10:36:42 America/Chicago] WordPress database error Table 'wp_database.one' doesn't exist for query SHOW FULL COLUMNS FROM one made by do_action('toplevel_page_CF7DBPluginSubmissions'), call_user_func_array, CF7DBPlugin->whatsInTheDBPage, CFDBViewWhatsInDB->display, ExportToHtmlTable->export, ExportBase->setDataIterator, CFDBAbstractQueryResultsIterator->query, CFDBWpdbResultIterator->queryDataSource

    Somehow it thinks that there’s a table called wp_database.one .. but none of my gravity forms have that as its name. I don’t have any clue as to where it would get “one” from as I don’t use that as a reference for any naming structure in the form or the fields.

    • This topic was modified 8 years ago by mkormendy.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    You won’t see the name of any of your forms in CFDB until it captures a submission for that form. Each site in multisite has its own independent set of data. So it is possible to see it on the main site or one of the individual sites because you have made a submission there, but not see them on other sites because there have been no submissions there.

    Thread Starter mkormendy

    (@mkormendy)

    Like I said: “when I go to the database and look at them directly, data is collected, in both the contact form db tables, as well as the tables from Gravity Forms”.

    So the name of my forms in CFDB are there, and CFDB has captured many submissions for that form because I see them directly in the database wp_cf7dbplugin_submits table.

    And regarding multisite, I also mentioned: “the main site is the only one that has forms available”, meaning, no other sub-site on multisite has any gravity forms present on them. This also means that none of the sub-sites are capturing submissions.

    The main site is the only site with forms, and form data submissions.

    • This reply was modified 8 years ago by mkormendy.
    Plugin Author Michael Simpson

    (@msimpson)

    OK, now I see I can scroll the error above, I can see there is more information.

    I don’t know what ‘wp_database.one’ is and there is no “SHOW FULL COLUMNS” query in the plugin code. This do_action('toplevel_page_CF7DBPluginSubmissions') seems like some other plugin or the theme is injecting something. Maybe that is messing things up so the the CFDB query can’t run correctly.

    CFDB should create and query a table called <prefix>_cf7dbplugin_submits which is normally wp_cf7dbplugin_submits but each site in your multisite will have different prefix.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘No Data Available in Table’ is closed to new replies.