update 3.2.1 is breaking my website in pieces….

I can give you access to the website if needed in PMB

You should contact the author directly if you feel that the forums are not right for the support level you need (if you are offering admin access).

Thank you for reporting this. Even though the plugin was tested before release, it can never be guaranteed that it works with all other WordPress plugins.

To fix the white screen, you will need to remove the content-aware-sidebars folder from your website, [moderated]

Sorry @intoxstudio, you or the OP can’t offer or ask for admin access here. You can provide your contact details and you can do what you wish privately of course.

I had what sounds like the same problem with 3.2.1 and had to revert to 3.1.2. The error in Apache logs indicates badly formed SQL where the IN subclause is empty. This might help in diagnosing the problem…

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 ‘) GROUP BY object_id’ at line 1 for query SELECT object_id FROM wp_term_relationships WHERE object_id IN () GROUP BY object_id made by require(‘/home/account/public_html/wp-blog-header.php’)

A bit more info. The error was on line 108 of taxonomy.php

Seems $posts is coming in as empty.

public function filter_excluded_context($posts) {
		global $wpdb;
		$posts = parent::filter_excluded_context($posts);
		$obj_w_tags = $wpdb->get_col("SELECT object_id FROM $wpdb->term_relationships WHERE object_id IN (".implode(",", array_keys($posts)).") GROUP BY object_id");
		$posts = array_diff_key($posts, array_flip($obj_w_tags));
		return $posts;
	}

Thank you for this information, I am investigating it right now.

Edit: I can confirm this is a bug. And you say this caused your site to turn blank?

This is how it is fixed:

public function filter_excluded_context($posts) {
		global $wpdb;
		$posts = parent::filter_excluded_context($posts);
		if($posts) {
			$obj_w_tags = $wpdb->get_col("SELECT object_id FROM $wpdb->term_relationships WHERE object_id IN (".implode(",", array_keys($posts)).") GROUP BY object_id");
			$posts = array_diff_key($posts, array_flip($obj_w_tags));
		}
		return $posts;
	}

Thanks Joachim.

I’m happy to see that I’m not alone to notice this. Although my pages have not gone blank, I’d like to see this fixed.

An update coming soon?

Thanks for such great support.

@philrp

While I do have a fix for Russell’s case, I am still waiting a little to see if all reported problems are caused by the same bug (instead of pushing out updates for each bug).

Can you try to use the code from my previous reply and see if that solves the problem?

The above code did fix the problem. The error would report whenever I loaded a page that did not use Content Aware Sidebars.

In case it helps, here is the full error i was getting.

Thanks again

[15-Jun-2016 00:33:22 UTC] 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 ') GROUP BY object_id' at line 1 for query SELECT object_id FROM kk_term_relationships WHERE object_id IN () GROUP BY object_id made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/twentysixteen/page.php'), get_header, locate_template, load_template, require_once('/themes/twentysixteen/header.php'), body_class, get_body_class, apply_filters('body_class'), call_user_func_array, twentysixteen_body_classes, is_active_sidebar, wp_get_sidebars_widgets, apply_filters('sidebars_widgets'), call_user_func_array, CAS_Sidebar_Manager->replace_sidebar, WPCACore::get_posts, WPCACore::get_conditions, apply_filters('wpca/modules/exclude-context'), call_user_func_array, WPCAModule_taxonomy->filter_excluded_context

Hello,

I’m having the same error message. I am just wondering where is the taxonomy.php located?

Thanks!

Hello Everyone,

I found it and fixed the problem. Thanks!

Same issue.

Was getting the exact same error that philrp was getting.

Made the change to the taxonomy.php file and that fixed it.

For reference, the taxonomy.php file that needs to be updated is part of the plugin, and located in the following location.

/wp-content/plugins/content-aware-sidebars/lib/wp-content-aware-engine/module/taxonomy.php

Thank you everyone for reporting it and telling that the fix works. I know it can be a headache when a plugin causes problems. I am still not completely sure that the SQL error is what has caused the blank screen initially reported.

The SQL problem is present on all pages that do not contain taxonomies, but only if those pages don’t have any content aware sidebars. I will push out the fix later today.