Core bug - Group manager sees their group twice in <site>/og listing

Can't find my original source on this patch so here is a copy. This is a patch to database.mysql.inc in d6 core that resolved your problem for us. If you use mysqli as a connector instead of mysql, you'll have to patch it instead.

Sorry to sound dumb but I have this problem too.

What does one do with the patch?

The patch isn't particularly complicated... Instead, just open the file ./includes/database.mysql.inc and change the lines:

    $select = preg_replace(
      '/((?:^|,)\s*)(?<!DISTINCT\()(?:'. $table .'\.)?'. $field .'(\s*(?:,|$))/is',
      '\1'. $field_to_select .'\2', $matches[1], 1
    );

to:

    $select = preg_replace(
      '/((?:^|,|\()\s*)(?<!DISTINCT\()(?:'. $table .'\.)?'. $field .'(\s*(?:,|\sAS|\)|$))/is',
      '\1'. $field_to_select .'\2', $matches[1], 1
    );

This resolved the problem for us.

thanks kb_0, this worked for me too!
i had to change it in /includes/database.mysqli.inc

:-D

Haven't tested this patch, as I'm not particularly excited about patching core...

We are seeing this as well, and here is some more detail:

For the group creator (ie, the person who created the group node, and is also the manager) the view works as it should.

However, for a user who joins the group and is promoted to group admin, the problem exists (ie, groups are listed twice).

This is not an issue for UID1.

Also, for others reading this thread, hacking core is a VERY bad idea. Kittens die when you do that.

Forehead <--> Palm!

That's a great workaround --

Like you say, it doesn't actually address the underlying issue, but it does make it go away.

Actually, setting the view to distinct did not solve this in my case.

The problem still exists.

Still not going to patch core to address this, though.

This is likely related to #284392: db_rewrite_sql causing issues with DISTINCT.

This is also discussed at http://www.lullabot.com/blog/views-distinct-node-access-problems

We built out a small helper module that works around this. It is working for us in a specific use case, but YMMV. The download is available off the FunnyMonkey site, and is linked from this comment: http://www.lullabot.com/blog/views-distinct-node-access-problems#comment...

Like bonobo said, this is a core issue and it needs more eyes on it. There are steps to reproduce this with minimal fuss here, but I think what would be most helpful would be for people to confirm that this is a problem with PostgreSQL as well as with MySQL.

If you are a pgsql user, please help out with the core issue, which is #284392: db_rewrite_sql causing issues with DISTINCT.

retitle. not fixable by OG

Setting this to postponed (should this be a duplicate?) -- as this should be addressed via #284392: db_rewrite_sql causing issues with DISTINCT.

The solution with distinct saved my day and solved my problem. Thanks a bunch!

Groups repeated themselves twice in group directory, while using the following configuration.

Drupal 6.15
Views 6.x-3.0-alpha1
OG 6.x-2.0
panels, OG panels and more

Also using mysqli.

In core file database.mysqli.inc I changed the following line.

From:

  '/((?:^|,)\s*)(?<!DISTINCT\()(?:'. $table .'\.)?'. $field .'(\s*(?:,|$))/is',

To:

	'/((?:^|,|\()\s*)(?<!DISTINCT\()(?:'. $table .'\.)?'. $field .'(\s*(?:,|\sAS|\)|$))/is',

And the problem went away.

Needs fixing in core.

Duplicate of #284392: db_rewrite_sql causing issues with DISTINCT which is where you should provide feedback on the latest core patch.

Subscribing.

Editing og view, as suggested in #6, was the solution for me.

Drupal 6.15 using mysql (not mysqli)
OG 6.x-2.0
Views 6.x-2.8

In organic groups, under my groups the exact same problem (refer to post #6) occurred at the destination og/my in which groups were appearing twice.

In the corresponding og_my view, selecting display type to "Page", and under "Basic settings" changing "Distinct" to "Yes" fixed it here as well.