CFDB not getting results from database

  • Until now, I’ve never had any errors with CFDB, but something is happening and I don’t know what to do:
    I have 3 Contact Form 7 forms in this site:
    Subscribe [3 text, 2 radio];
    Send subscription payment receipt [3 text, 2 attachment (1 attachment required and the other is optional)];
    Job submission [8 text, 2 radio, 1 attachment].

    On my CFDB page, all 3 forms appear in the <select> drop-down menu, but only 2 of them have results (I have seeded all 3 of them).

    Also, all of the forms send an mail and mail2, and they are all working (both who fill in the form (sender) and who receives the email (receiver) are getting the emails for all 3 forms)

    Then, I went to phpmyadmin to see if the form that had no results shown was actually getting and storing them, and in the 452988c_cf7dbplugin_submits table I had some rows corresponding to that form that was showing no results.

    Do you have any clues on what might be happening?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter mauriciowho

    (@mauriciowho)

    Oh, and here’s my query:

    Query:
SELECT <code>submit_time</code> AS 'Submitted',
 max(if(<code>field_name</code>='your-name', <code>field_value</code>, null )) AS 'your-name',
 max(if(<code>field_name</code>='your-email', <code>field_value</code>, null )) AS 'your-email',
 max(if(<code>field_name</code>='your-cpf', <code>field_value</code>, null )) AS 'your-cpf',
 max(if(<code>field_name</code>='your-fone', <code>field_value</code>, null )) AS 'your-fone',
 max(if(<code>field_name</code>='CategoriaDeInscricao', <code>field_value</code>, null )) AS 'CategoriaDeInscricao',
 max(if(<code>field_name</code>='Minicursos', <code>field_value</code>, null )) AS 'Minicursos',
 max(if(<code>field_name</code>='Page Title', <code>field_value</code>, null )) AS 'Page Title',
 max(if(<code>field_name</code>='Page URL', <code>field_value</code>, null )) AS 'Page URL',
 max(if(<code>field_name</code>='Submitted from Page URL', <code>field_value</code>, null )) AS 'Submitted from Page URL',
 max(if(<code>field_name</code>='Submitted Login', <code>field_value</code>, null )) AS 'Submitted Login',
 max(if(<code>field_name</code>='Submitted From', <code>field_value</code>, null )) AS 'Submitted From',
 GROUP_CONCAT(if(<code>file</code> is null or length(<code>file</code>) = 0, null, <code>field_name</code>)) AS 'fields_with_file'
FROM <code>452988c_cf7dbplugin_submits</code> 
WHERE <code>form_name</code> = 'Confirma??o'  
GROUP BY <code>submit_time</code> 
ORDER BY <code>submit_time</code> DESC
LIMIT 0,100
    Plugin Author Michael Simpson

    (@msimpson)

    What is the name of the form that is not showing results? I suspect special characters like quotes might cause the retrieval query to fail.

    Plugin Author Michael Simpson

    (@msimpson)

    …I see the form name is in your query above: Confirma??o

    Try renaming the form “Confirmacao”, do a submission, and see it you can view the entry.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘CFDB not getting results from database’ is closed to new replies.