All occurances of "SELECT n.nid" must be changed to "SELECT DISTINCT(n.nid)" to avoid duplicate listings when used in node_privacy_byrole.module

Sorry, I don't yet know how to make patches yet, but I found two occurances that needed to be changed, and that fixed the problem. I know this is the wrong way to go about it, but I've attached the full updated module.

See related issue: http://drupal.org/node/11871

Comments

stelman’s picture

stelman commented
Title: Duplicates when used with node_privacy_byrole.module » Still more code problems

Forget the attachment on my last post. I missed one occurance that didn't get changed, but more importantly, the count for each taxonomy on http://mysite/?q=weblinks is still not fixed. The count displayed is multiplied by the number of roles the current logged in user has assigned with access to the included nodes.

I couldn't figure this one out.

Note: These issues are not visible when logged on as the admin user, only as a regular user.

stelman’s picture

stelman commented
Title: Still more code problems » Duplicates when used with node_privacy_byrole.module
Bèr Kessels’s picture

Bèr Kessels commented
Status: Active » Fixed

fixed long ago.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)