• Resolved LifeintheBush

    (@lifeinthebush)


    I’m getting this message when I attempt to do a search and replace…

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order = REPLACE(order, "localhost/albany", "al"), data = REPLACE(data, "localhos' at line 1 for query UPDATE wp_ninja_forms_fav_fields SET id = REPLACE(id, "localhost/albany", "al"), row_type = REPLACE(row_type, "localhost/albany", "al"), type = REPLACE(type, "localhost/albany", "al"), order = REPLACE(order, "localhost/albany", "al"), data = REPLACE(data, "localhost/albany", "al"), name = REPLACE(name, "localhost/albany", "al") made by require_once('E:\Domains\a\albanyartscommunications.com\user\htdocs\wp-admin\admin.php'), do_action('tools_page_search-and-replace/search-and-replace'), call_user_func_array, searchandreplace_page, searchandreplace_action, searchandreplace_doit, searchandreplace_sall
    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order = REPLACE(order, "localhost/albany", "al"), data = REPLACE(data, "localhos' at line 1 for query UPDATE wp_ninja_forms_fields SET id = REPLACE(id, "localhost/albany", "al"), form_id = REPLACE(form_id, "localhost/albany", "al"), type = REPLACE(type, "localhost/albany", "al"), order = REPLACE(order, "localhost/albany", "al"), data = REPLACE(data, "localhost/albany", "al"), fav_id = REPLACE(fav_id, "localhost/albany", "al"), def_id = REPLACE(def_id, "localhost/albany", "al") made by require_once('E:\Domains\a\albanyartscommunications.com\user\htdocs\wp-admin\admin.php'), do_action('tools_page_search-and-replace/search-and-replace'), call_user_func_array, searchandreplace_page, searchandreplace_action, searchandreplace_doit, searchandreplace_sall

    Website is here…

    https://www.ads-software.com/plugins/search-and-replace/

Viewing 1 replies (of 1 total)
  • Plugin Contributor Frank Bueltge

    (@bueltge)

    WordPress have change the database, since version 4.2.
    But now I have change the collate check in the new version 1.7.1 for case sensitive search in the database, that it will now work also with WP version 4.2 and higher.

Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error You have an error in your SQL syntax’ is closed to new replies.