Filter counts incorrect when modules that implement the node access system are being used [#1669874]

Although there are two items found for one specific content type, facet search displays (1) after that type, how is this possible?

Please take a look at the attached picture

example

Comment	File	Size	Author
	Knipsel.PNG	44.18 KB	nielsvoo

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

nielsvoo CreditAttribution: nielsvoo commented 4 July 2012 at 18:22

Priority:

Normal

» Critical

Oke i noticed the admin count work well after that i struggled with the node rights and noticed that when enabling "Bypass content access control" for the authenticated user (al my users are logged in) the counts do work, but this is not a great solutions becouse they now can edit all pages.

Please can you fix this?

Comment #2

nielsvoo CreditAttribution: nielsvoo commented 4 July 2012 at 22:45

Oke, again i am one step further. The conflict occurs when the module Content Access is enabled.

I think the facet counts only work on core rights. is there a possibility for you to make it work with this access module also?

Comment #3

nielsvoo CreditAttribution: nielsvoo commented 5 July 2012 at 16:15

Component:	User interface	» Code
Category:	support	» bug

Please!!! help me with this issue,

also the Flag friend access control to limit node types function in the flag friend module is buggy with counting nodes....

Thank you
Niels

Comment #4

cpliakas CreditAttribution: cpliakas commented 6 July 2012 at 14:10

Title:

filtering counts not correct!

» Filter counts incorrect when modules that implement the node access system are being used

Hi Niels.

There is a lot of complex SQL happening here, so my guess is that the node access system isn't being leveraged on some of the subqueries. I would take a look at the FacetapiQuery::execute() method, specifically the $subquery query on line 94 and ensure the appropriate access controls are implemented.

Thanks,
Chris

Comment #5

nielsvoo CreditAttribution: nielsvoo commented 10 July 2012 at 14:20

Oke Chris thanks,

Maybe a solution will be for someone else, i implemented the solr search server, this one works fine with the other modules!

Niels

Comment #6

cpliakas CreditAttribution: cpliakas commented 10 July 2012 at 14:45

nielsvoo,

Good choice :-) Solr is definitely best-in-breed here, the purpose of this module is to provide a better starting point for people who are testing or can't use Solr or another external search engine for one reason or another.

Thanks again for reporting,
Chris