SQL error when Groups is accessed and no content type has been associated with OG.

robbt - April 22, 2008 - 22:08
Project:Organic groups
Version:5.x-7.0-rc3
Component:og.module
Category:bug report
Priority:normal
Assigned:Unassigned
Status:duplicate
Description

I got the following error upon initially installing OG and before associating a content type with being a OG node.

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 ')) ORDER BY node_title ASC LIMIT 0, 90' at line 1 query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, og.description AS og_description, og.selective AS og_selective FROM node node LEFT JOIN og og ON node.nid = og.nid INNER JOIN users users ON node.uid = users.uid WHERE (node.status = '1') AND (og.directory = '1') AND (node.type IN ()) ORDER BY node_title ASC LIMIT 0, 90 in /home/www/drupal-5.7/includes/database.mysql.inc on line 172.

It seems like OG should do some kind of logic check and prompt the user to create a content type for groups instead of giving a SQL error.

#1

moshe weitzman - April 23, 2008 - 11:50
Status:active» duplicate

wil be fixed in rc4. coming in a few mins

 
 

Drupal is a registered trademark of Dries Buytaert.