Hello, Thanks for reporting this. I will get this resolved quickly and have an update pushed out for you.
Appreciate the quick reply!
I just pushed an update to correct this. Thanks again for reporting the issue.
My apologies, but it does not appear that the issue is corrected. It appears now to only happen when publishing posts… when the post is set to private the issue does not happen. it also does not happen when updating existing posts.
It “feels” like a conflict somewhere, but by process of elimination, the issue does not occur when the Accessibility plugin is disabled
[Mon May 03 14:07:27.808500 2021] [php7:notice] [pid 18148] [client THE.CLIENTS.IP.ADDRESS:50852] 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 quaws_posts.post_type = ‘post’ AND (quaws_posts.post_status = ‘publish” at line 3 for query SELECT SQL_CALC_FOUND_ROWS quaws_posts.ID FROM quaws_posts LEFT JOIN quaws_term_relationships ON (quaws_posts.ID = quaws_term_relationships.object_id) WHERE 1=1 AND ( \n quaws_term_relationships.term_taxonomy_id IN (2090)\n) AND ((())) AND quaws_posts.post_type = ‘post’ AND (quaws_posts.post_status = ‘publish’ OR quaws_posts.post_status = ‘acf-disabled’ OR quaws_posts.post_status = ‘future’ OR quaws_posts.post_status = ‘draft’ OR quaws_posts.post_status = ‘pending’ OR quaws_posts.post_status = ‘private’) GROUP BY quaws_posts.ID ORDER BY quaws_posts.menu_order ASC LIMIT 0, 20 /* From [www.THEDOMAIN.com/wp-admin/edit.php?s&post_status=all&post_type=post&action=-1&m=0&cat=2090&seo_filter&readability_filter&paged=1&post%5B0%5D=5927&post%5B1%5D=5841&post%5B2%5D=5813&post%5B3%5D=5759&post%5B4%5D=5678&post%5B5%5D=5655&post%5B6%5D=5635&post%5B7%5D=5570&post%5B8%5D=5396&post%5B9%5D=5338&post%5B10%5D=5290&post%5B11%5D=5275&post%5B12%5D=5262&post%5B13%5D=5205&post%5B14%5D=5195&post%5B15%5D=5177&post%5B16%5D=5126&post%5B17%5D=5101&post%5B18%5D=5094&post%5B19%5D=5089&action2=-1] in [N/A] */ made by WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, referer: https://www.THEDOMAIN.com/wp-admin/edit.php?category_name=certification-station
[Mon May 03 14:07:27.874619 2021] [php7:notice] [pid 18148] [client THE.CLIENTS.IP.ADDRESS:50852] 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 quaws_posts.post_type = ‘post’ AND (quaws_posts.post_status = ‘publish” at line 5 for query SELECT SQL_CALC_FOUND_ROWS quaws_posts.ID FROM quaws_posts LEFT JOIN quaws_term_relationships ON (quaws_posts.ID = quaws_term_relationships.object_id) LEFT JOIN quaws_term_relationships AS tt1 ON (quaws_posts.ID = tt1.object_id) WHERE 1=1 AND ( \n quaws_term_relationships.term_taxonomy_id IN (2090) \n AND \n tt1.term_taxonomy_id IN (2090)\n) AND ((())) AND quaws_posts.post_type = ‘post’ AND (quaws_posts.post_status = ‘publish’ OR quaws_posts.post_status = ‘acf-disabled’ OR quaws_posts.post_status = ‘future’ OR quaws_posts.post_status = ‘draft’ OR quaws_posts.post_status = ‘pending’ OR quaws_posts.post_status = ‘private’) GROUP BY quaws_posts.ID ORDER BY quaws_posts.menu_order ASC LIMIT 0, 20 /* From [www.THEDOMAIN.com/wp-admin/edit.php?s&post_status=all&post_type=post&action=-1&m=0&cat=2090&seo_filter&readability_filter&paged=1&post%5B0%5D=5927&post%5B1%5D=5841&post%5B2%5D=5813&post%5B3%5D=5759&post%5B4%5D=5678&post%5B5%5D=5655&post%5B6%5D=5635&post%5B7%5D=5570&post%5B8%5D=5396&post%5B9%5D=5338&post%5B10%5D=5290&post%5B11%5D=5275&post%5B12%5D=5262&post%5B13%5D=5205&post%5B14%5D=5195&post%5B15%5D=5177&post%5B16%5D=5126&post%5B17%5D=5101&post%5B18%5D=5094&post%5B19%5D=5089&action2=-1] in [/nas/content/live/swainc/wp-content/plugins/wordpress-seo-premium/admin/links/class-link-columns.php:219] */ made by WP_List_Table->display, WP_List_Table->display_tablenav, WP_Posts_List_Table->extra_tablenav, do_action(‘manage_posts_extra_tablenav’), WP_Hook->do_action, WP_Hook->apply_filters, WPSEO_Link_Columns->count_objects, WPSEO_Link_Columns->set_count_objects, WP_Query->get_posts, referer: https://www.THEDOMAIN.com/wp-admin/edit.php?category_name=certification-station
Hello, Unfortunately I am not able to reproduce the error in our plugin. It looks like it may be in the seo premium plugin. See the affected file in your error message: wordpress-seo-premium/admin/links/class-link-columns.php:219