Closed (duplicate)
Project:
Organic Groups
Version:
6.x-1.3
Component:
og_access.module
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
21 Sep 2009 at 04:52 UTC
Updated:
21 Feb 2011 at 15:34 UTC
Jump to comment: Most recent file
Comments
Comment #1
moshe weitzman commentedThe fix is going to come from core, i hope. Nothing OG can do here.
Comment #2
ajayg commentedI just opened this here so OG users are aware of this.
Comment #3
brisath commentedDoes anyone know if the latest Dev versions of Drupal core resolve this problem?
Comment #4
ajayg commentedAs of today nope. There is a patch discussed here #284392: db_rewrite_sql causing issues with DISTINCT . When it is ready in core, it will solve the problem.
Comment #5
brisath commentedI'm still watching the discussion linked in #4. I haven't seen any addition of the discussed patch to core yet. Are we sure that is the issue that will solve this OG double post problem in views? In other words, there is no solution but to wait until it goes into at least a dev version of Drupal core (since I am not patch literate nor do I want to risk a patch right now)?
Comment #6
mathieuhelie commentedDoubling occurs in all OG views, as well as custom views where group nodes are mixed with other content types (only group nodes appear twice).
Does not occur for users with administrator privileges.
Comment #7
Bernardine commentedSubscribing
Comment #8
Hunabku commentedSubscribing
Comment #9
glen201 commentedUg, I've never seen a point release of core break so much as 6.14. Getting a little trigger happy with 6.x in the face of the 7.x release, I presume. I'm staying away, and I turned off the Update Status updates so I don't get bothered with being out of date. :)
Comment #10
dugh commentedsubscribe
Comment #11
Pongolyn commentedsubscribing
Comment #12
mrosas commentedsubscribing
Comment #13
MatthijsG commentedsubscribe!
Comment #14
moshe weitzman commentedlets follow #284392: db_rewrite_sql causing issues with DISTINCT as ajay suggests
Comment #15
Blue commentedI have the same problem in OG 2.0
Comment #16
bricef commentedHello,
I applied the patch #257 from http://drupal.org/node/284392 and i still have a problem. When i add a node to one my organic groups i can see this message :
Duplicate entry '304' for key 1 query: INSERT INTO og_access_post (nid, og_public) VALUES (304, 0) in /var/www/html/trunk/includes/common.inc on line 3468.Comment #17
brisath commentedDoes core upgrade to 6.15 resolve anything, or do I need to keep holding back? I'm following http://drupal.org/node/284392 but not sure if I missed something in regard to OG and the double post problems.
Comment #18
tetty commentedsubscribing
Comment #19
brisath commentedSo is this the dev version that finally allows me to upgrade Drupal and avoid this OG double posting issue?
http://drupal.org/node/97368
I saw it was committed in the discussion linked from #14 above.
Comment #20
zchandler commentedI followed ajayg and moshe's advice on which thread to watch, and the fix to the node-doubling problem is in that queue. The bug is not OG, its any node access module + core (after 6.13).
Patch by mathieu is available here:
http://drupal.org/node/284392#comment-2254932
(attached below for your convenience)
confirmed here:
http://drupal.org/node/284392#comment-2264916
confirmed w/OG specifics here:
http://drupal.org/node/284392#comment-2265998
which I can confirm in my own site:
Drupal 6.15
OG 6.x-2.0
Views 6.x-2.8
When following the instructions on applying the patch (to core), note the non-standard -p1 flag (-p0 won't work).
Comment #21
zchandler commentedComment #22
henrijs.seso commentedsubscribe. patch #20 didnt help.
Comment #23
ajayg commentedDrupal 6.16 has all the required patches and should fix this issue. I haven't tried yet. If you have, please write it here your observation.
Comment #24
stacysimpson commentedSubscribing
Comment #25
brisath commentedI've upgraded to 6.16 and can verify the nodes are not showing twice in OG. I haven't run into any problems at this point.
Comment #26
tugis commentedThe reason for the duplicates is a Node Access issue. If we have just one "View" grant per user, we won't see duplicates. I mean, if we are admin of a group, we receive a view grant from "og_admin" and "og_subscriber" realms and we can also receive the view grant from "og_public" if the group is public. So, I was facing the same issue and what I did was hacking the code of "og_access.module" so I just give 1 view grant per user. This solved the duplicates.