I get this error whenever I create a group or content in a group.
SocialNicheGuru - October 22, 2009 - 13:39
| Project: | Organic groups |
| Version: | 6.x-2.x-dev |
| Component: | og.module |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
It looks like there is a conflict between the two group types, but why?
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(n.nid) FROM node n WHERE n.type IN ('group','site_group_adv') AND n.sta' at line 1 query: SELECT n.title, DISTINCT(n.nid) FROM node n WHERE n.type IN ('group','site_group_adv') AND n.status = 1 ORDER BY n.title ASC in sites/all/modules/contrib/og/og.module on line 1604.

#1
Same here. I have the same problem.
#2
I have the same error aswell.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(n.nid) FROM aktiv_node n WHERE n.type IN ('group') AND n.status = 1 ORD' at line 1 query: SELECT n.title, DISTINCT(n.nid) FROM aktiv_node n WHERE n.type IN ('group') AND n.status = 1 ORDER BY n.title ASC in /home/fnord/www6/sites/aktivistnett.no/modules/og/og.module on line 1604.
#3
http://drupal.org/node/581822
this might help you but it didn't help me. Let me know your results