OG tracker showing nodes twice after upgrading core to 6.14
ajayg - September 21, 2009 - 04:52
| Project: | Organic groups |
| Version: | 6.x-1.3 |
| Component: | og_access.module |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
Description
Since I upgraded to core 6.14, OG tracker suddenly started to show double nodes. This affects non-admin users and only node under OG (og access)
Selecting the "distinct" option under og tracker view helped but there is a performance pentaly. I didn't have this penalty when using core 6.12 (I went from 6.12-6.14)
It seems this seems to be related to this issue #284392: db_rewrite_sql causing issues with DISTINCT
#1
The fix is going to come from core, i hope. Nothing OG can do here.
#2
I just opened this here so OG users are aware of this.
#3
Does anyone know if the latest Dev versions of Drupal core resolve this problem?
#4
As 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.
#5
I'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)?
#6
Doubling 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.
#7
Subscribing
#8
Subscribing
#9
Ug, 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. :)
#10
subscribe
#11
subscribing
#12
subscribing
#13
subscribe!
#14
lets follow #284392: db_rewrite_sql causing issues with DISTINCT as ajay suggests
#15
I have the same problem in OG 2.0
#16
Hello,
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.