For some reason, when I activate this plugin, the yearly post archive stops working. WordPress 4.7.4 Multisite with Advanced Custom Fields Pro Version 5.5.11
Here's the error I receive:
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 wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish' O' at line 3 for query SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID FROM wp_2_posts WHERE 1=1 AND ( \n ( YEAR( wp_2_posts.post_date ) = 2016 AND MONTH( wp_2_posts.post_date ) = 11 )\n) AND ((())) AND wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'acf-disabled' OR wp_2_posts.post_status = 'private') ORDER BY wp_2_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/child_theme/archive.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts, referer: https://domain/multisite/site/posts/2016/
I changed the referrer url to keep google off my dev server. I activated and deactivated the plugin on both my production and dev servers and could confirm it was this plugin that was causing the issue. Has anyone else seen this?
For some reason, when I activate this plugin, the yearly post archive stops working. WordPress 4.7.4 Multisite with Advanced Custom Fields Pro Version 5.5.11
Here's the error I receive:
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 wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish' O' at line 3 for query SELECT SQL_CALC_FOUND_ROWS wp_2_posts.ID FROM wp_2_posts WHERE 1=1 AND ( \n ( YEAR( wp_2_posts.post_date ) = 2016 AND MONTH( wp_2_posts.post_date ) = 11 )\n) AND ((())) AND wp_2_posts.post_type = 'post' AND (wp_2_posts.post_status = 'publish' OR wp_2_posts.post_status = 'acf-disabled' OR wp_2_posts.post_status = 'private') ORDER BY wp_2_posts.post_date DESC LIMIT 0, 10 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/child_theme/archive.php'), WP_Query->__construct, WP_Query->query, WP_Query->get_posts, referer: https://domain/multisite/site/posts/2016/
I changed the referrer url to keep google off my dev server. I activated and deactivated the plugin on both my production and dev servers and could confirm it was this plugin that was causing the issue. Has anyone else seen this?