posts_where filter is ignored

Hey folks,
me again.

Ok even if i make a clear sql error in the statement, i get a result…

$where .= " AND ".$wpdb->posts.".IDXAXAXAXA is in (1,2,3)  ";

so thats at least the prove that my filter is ignored… but why ?

Hi Eric,

yes it does.

If i echo, or print_r $where i get the where statement matching to my search criteria.
after that i add my personal “and” statement.

So that looks fine.

i also checked that surpress_filters is not active and checked that the filter its used
in the ./wp-includes/query.php all looks good – but it has no impact on the result…

as i said – i can write total nonsense in the $where, and the search is triggered
as if i nothing happens.

thats why i think that i put the trigger to late, and the query is already executed ,
is this possible ?

i checked the posts_requests filter, and that is also funny.

i inserted that code in my functions.php

function my_posts_request_filter( $input ) {
	print_r( $input );
}
add_filter( 'posts_request', 'my_posts_request_filter' );

and i get
“SELECT * FROM wp_posts WHERE 1=2”

so this does’t look like my query 😀

and also here if i change that code to this:

function my_posts_request_filter( $input ) {
	global $wpdb;
	$input = "SELECT * FROM wp_posts where ".$wpdb->posts.".ID is  in (1,2,3) ";
	print_r( $input );
}
add_filter( 'posts_request', 'my_posts_request_filter' );

it has no impact on my search result. I get the same posts, as if this filter would not be in the code.

print_r($where); from post_where filter says

AND (((wp_posts.post_title LIKE '%sports%') OR (wp_posts.post_content LIKE '%sports%'))) AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') AND wp_posts.ID IS IN (1,2,3)

but this is not surprising 😀

good point, but nope…
i tried to make it more direct now

Array (
[where] =>
AND (((wp_posts.post_title LIKE '%sports%') OR (wp_posts.post_content LIKE '%sports%'))) AND wp_posts.post_type IN ('post', 'page', 'attachment')
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1
AND wp_posts.post_status = 'private')
AND wp_posts.ID = 1
[groupby] =>
[join] =>
[orderby] => wp_posts.post_date DESC
[distinct] =>
[fields] => wp_posts.*
 [limits] => LIMIT 0, 7 )

still got the same search result, with all posts that contain “sports”

jeep maybe , but all of them should be targeted by the last stand alone

“AND wp_posts.ID = 1”

so in fact not one single post , is valid if it is not ID: 1

the trigger isn’t used… thats my point, the syntax is correct,but it is just ignored
and i have no clue why…

i am going to search deeper in the query.php , but i do not want to make changes here,
to keep the system up-dateable.

thankx for your time bro – i appreciate that – but maybe somebody ready that who knows why the filter just does nothing 😀