Query fails when CF7 form name contains dash ‘-‘
-
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’
FROMwp_cf7dbplugin_submits
WHEREform_name
= ‘2017 Free Demo Page’
GROUP BYsubmit_time
ORDER BYsubmit_time
DESC
LIMIT 0,100should be:
SELECT
submit_time
AS ‘Submitted’,
GROUP_CONCAT(if(file
is null or length(file
) = 0, null,field_name
)) AS ‘fields_with_file’
FROMwp_cf7dbplugin_submits
WHEREform_name
= ‘2017- Free Demo – Page’
GROUP BYsubmit_time
ORDER BYsubmit_time
DESC
LIMIT 0,100The 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.