WordPress database error You have an error in your SQL syntax

  • Resolved Oded Talmon

    (@odedta)


    5 years, 8 months ago

    Hello,
    I inserted a Country and State fields, when I select Country = Canada the state field is not updated with the correspondent states.

    The error_log shows:

    [08-Oct-2020 15:06:13 UTC] PHP Notice: Undefined variable: cid in /home/MY_USER/public_html/MY_WEBSITE/wp-content/plugins/country-state-city-auto-dropdown/includes/ajax-actions.php on line 12
    [08-Oct-2020 15:06:13 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 ‘order by name asc’ at line 1 for query SELECT * FROM wp_state where country_id= order by name asc made by do_action(‘wp_ajax_nopriv_tc_csca_get_states’), WP_Hook->do_action, WP_Hook->apply_filters, tc_csca_get_states

    What should I do?

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress database error You have an error in your SQL syntax’ is closed to new replies.