Viewing 15 replies - 1 through 15 (of 19 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    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

    (@tom1975)

    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

    (@msimpson)

    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

    (@tom1975)

    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

    (@msimpson)

    What fields are in this form? Is it just one field to upload a file?

    Plugin Author Michael Simpson

    (@msimpson)

    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

    (@tom1975)

    Hello,

    I have 4 fields in this form:
    Name
    Phone
    Email
    Your message

    Plugin Author Michael Simpson

    (@msimpson)

    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

    (@tom1975)

    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

    (@msimpson)

    That setting looks OK.

    If you do a new submission from that form do you see it?

    Thread Starter tom1975

    (@tom1975)

    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

    (@craigsand)

    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

    (@msimpson)

    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 [email protected]

    Thread Starter tom1975

    (@tom1975)

    I can let you log into my site, but everything is in hebrew.
    Can you check it even if it’s not in English?

    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)

The topic ‘Error on getting data’ is closed to new replies.