• After upgrading to Version 2.10.34 the back-end query to show leads does not work when the CF7 form name contains dash ‘-‘ characters.

    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 = ‘2017 Free Demo Page’
    GROUP BY submit_time
    ORDER BY submit_time DESC
    LIMIT 0,100

    should be:

    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 = ‘2017- Free Demo – Page’
    GROUP BY submit_time
    ORDER BY submit_time DESC
    LIMIT 0,100

    The page I need help with: [log in to see the link]

  • The topic ‘Query fails when CF7 form name contains dash ‘-‘’ is closed to new replies.