SQL error when Groups is accessed and no content type has been associated with OG.
| Project: | Organic groups |
| Version: | 5.x-7.0-rc3 |
| Component: | og.module |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
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
wil be fixed in rc4. coming in a few mins