Changed Page URL and Page Title convert data functions to wpcf7_post_related_smt
Changed Submitted from Page URL to Submitted Page URL because otherwise $wpdb->get_results parses max(if(field_name='Submitted from Page URL', field_value, null )) AS 'Submitted from Page URL', incorrectly (from is used as mysql statement)
Note: for live installations with submitted form data you would need to execute following sql statement:
UPDATE wp_cf7dbplugin_submits SET field_name='Submitted Page URL' WHERE field_name='Submitted from URL'
Knut007
commented
6 years ago
Changed Page URL and Page Title convert data functions to
wpcf7_post_related_smtChanged Submitted from Page URL to Submitted Page URL because otherwise
$wpdb->get_resultsparsesmax(if(, incorrectly (from is used as mysql statement)field_name='Submitted from Page URL',field_value, null )) AS 'Submitted from Page URL'Note: for live installations with submitted form data you would need to execute following sql statement:
UPDATEwp_cf7dbplugin_submitsSETfield_name='Submitted Page URL' WHERE field_name='Submitted from URL'