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
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

Blue - November 6, 2009 - 20:29

Same here. I have the same problem.

#2

perarnet - November 13, 2009 - 18:46

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

SocialNicheGuru - November 14, 2009 - 04:45

http://drupal.org/node/581822

this might help you but it didn't help me. Let me know your results

 
 

Drupal is a registered trademark of Dries Buytaert.