• When searching for WooCommerce SKUs in the admin interface I get an error:

    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 ‘) AND post_status != ‘future’ ORDER BY wp_posts.post_title LIKE ‘%16199%’ DESC,’ at line 1]
    SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND ( ( (((((wp_posts.post_title LIKE ‘%16199%’) OR (wp_posts.post_content LIKE ‘%16199%’)))))) AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’)) AND post_type != ‘revision’) AND post_status != ‘future’ ORDER BY wp_posts.post_title LIKE ‘%16199%’ DESC, wp_posts.post_date DESC LIMIT 0, 20

    https://ww.wp.xz.cn/plugins/search-everything/

The topic ‘WooCommerce SQL errors’ is closed to new replies.