Viewing 0 reply threads
  • Author
    Posts
    • #8068
      cdcorey
      Member

      I noticed this in my error log. Not sure exactly what caused it, but it seems like it might suggest a conflict between Yoast and Piklist.

      mod_fcgid: stderr: 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 ‘EXISTS ‘needs-a-value-anyway’ ORDER BY CAST(meta_value AS CHAR) ) ORDER BY CAST(‘ at line 1 for query SELECT DISTINCT post_id FROM wp_postmeta WHERE post_id NOT IN (SELECT post_id FROM wp_postmeta WHERE meta_key = ‘_yoast_wpseo_focuskw’ AND CAST(meta_value AS CHAR) NOT EXISTS ‘needs-a-value-anyway’ ORDER BY CAST(meta_value AS CHAR) ) ORDER BY CAST(meta_value AS CHAR) made by wp_dashboard, do_meta_boxes, call_user_func, Yoast_Dashboard_Widget->display_dashboard_widget, Yoast_Dashboard_Widget->statistic_items, Yoast_Dashboard_Widget->set_statistic_items_for_this_user, Yoast_Dashboard_Widget->get_seo_scores_with_post_count, array_map, Yoast_Dashboard_Widget->map_rank_to_widget, WPSEO_Statistics->get_post_count, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, WP_Meta_Query->get_sql, apply_filters_ref_array, WP_Hook->apply_filters, call_user_func_array, Piklist_WordPress::get_meta_sql, Piklist_WordPress::get_sql_for_query

      I had Piklist 0.9.9.12 and Yoast SEO 4.6 installed at the time of the log. I’ve just upgraded Yoast SEO to 4.7, but since I’m not sure what triggered that error output, I have no way to test if that will affect this issue.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.