"Exclude Categories" bug

figoware
(@figoware)

10 years ago
Hi,

I found a bug: when using the “Exclude Categories” feature AND not having the standard DB prefix, there is an SQL error, and nothing is found.

The function se_build_exclude_categories() uses “wp_posts” table instead of the prefix variable.

Here is my corrected version:
```
if ( $this->wp_ver23 ) {
					$excludeQuery = " AND ( ctax.term_id NOT IN ( ".$excl_list." ) OR ($wpdb->posts.post_type IN ( 'page' )))";
				}
				else {
					$excludeQuery = " AND (c.category_id NOT IN ( '.$excl_list.' ) OR ($wpdb->posts.post_type IN ( 'page' )))";
				}
```
Hope it’s helping…

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

Viewing 6 replies - 1 through 6 (of 6 total)

Thread Starter figoware
(@figoware)

9 years, 11 months ago

Alas, still not corrected in v8.1.6…

NolymitContact
(@nolymitcontact)

9 years, 9 months ago

Hi figoware,

Thank you very much for sharing.

I used your above version and tested the search, the results are the same as before: The category id field contains any number, the search box returns no results.

Any thoughts will be highly appreciated.
Thread Starter figoware
(@figoware)

9 years, 9 months ago
It’s working for me…
In the options, I have something like : “30,31,32” in the “Exclude Categories:” field.

Since I post my solution, I’d to improve the code to make it work with Custom Post Types… Here is my code :
```
if ( $this->wp_ver23 ) {
  $excludeQuery = " AND ( ctax.term_id NOT IN ( ".$excl_list." ) OR ($wpdb->posts.post_type NOT IN ( 'post' )))";
}
else {
  $excludeQuery = " AND (c.category_id NOT IN ( '.$excl_list.' ) OR ($wpdb->posts.post_type NOT IN ( 'post' )))";
}
```
Is that helping you ?
NolymitContact
(@nolymitcontact)

9 years, 9 months ago

Thank you for your fast help. I tried the above new version. Here are the results:

I have one private group “page=bp-groups&gid=11”. I placed “11” in “Exclude Categories: 11 “. Then I searched as non-member of this private group, the content of this private group still appear in the search results. Any thoughts on this? I am new to wordpress.
rjgnyc
(@rjgnyc)

9 years, 9 months ago
This tweak also appears to be working for me. I made one additional tweak that seems to let me cover more of my bases (at least it doesn’t seem to not be working for me right now!).

Instead of swapping ‘page’ for ‘post’, I had both included in the list (and added ‘product’ to leave out select product categories). Appears to be working great so far, but I’ll test more over time.
```
if ( $this->wp_ver23 ) {
  $excludeQuery = " AND ( ctax.term_id NOT IN ( ".$excl_list." ) OR ($wpdb->posts.post_type NOT IN ( 'post', page', 'product' )))";
}
else {
  $excludeQuery = " AND (c.category_id NOT IN ( '.$excl_list.' ) OR ($wpdb->posts.post_type NOT IN ( 'post', page', 'product' )))";
}
```
NolymitContact
(@nolymitcontact)

9 years, 9 months ago

Hi All,

Thanks for sharing. I am wondering about this:

I used Buddypress to create private group, so I only saw this private group ID: “page=bp-groups&gid=11” in URL bar. I placed “11” in “Exclude Categories: 11 “.

Then I searched as non-member of this private group, the content of this private group still appear in the search results. Is this the situation same as yours?

Thanks advance for any input.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘"Exclude Categories" bug’ is closed to new replies.