FormCraft v1.2.11, WP 6.8.1<\/p>\n\n\n\n
Getting the following error when attempting to edit a form:<\/p>\n\n\n\n
I’ve traced this to the following line in builder.php<\/p>\n\n\n\n Preparing the statement in this fashion includes the table name as a single quoted string, which causes the error. I’ve resolved this issue by updating the code:<\/p>\n\n\n\n —-<\/p>\n\n\n\n There’s another syntax error in formcraft-main.php, line 473. There’s an extra comma following the table name in the statement.<\/p>\n\n\n\n Continuing to troubleshoot here and will fix these issues locally, but I hope that they can be addressed by a future update.<\/p>\n\n\n\n Thanks!<\/p>\n","protected":false},"template":"","class_list":["post-18451391","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18451391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18451391\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18451391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}[05-May-2025 20:05:08 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''wpws_formcraft_b_forms' WHERE id = 5' at line 1 for query SELECT * FROM 'wpws_formcraft_b_forms' WHERE id = 5 made by do_action('toplevel_page_formcraft_basic_dashboard'), WP_Hook->do_action, WP_Hook->apply_filters, formcraft_basic_dashboard, require_once('\/plugins\/formcraft-form-builder\/views\/builder.php')<\/code><\/p>\n\n\n\n$qry = $wpdb->get_results( $wpdb->prepare(\"SELECT * FROM %s WHERE id = %d\", $forms_table, $form_id));<\/code><\/p>\n\n\n\n$qry = $wpdb->get_results( $wpdb->prepare(\"SELECT * FROM $forms_table WHERE id = %d\", $form_id));<\/code><\/p>\n\n\n\n