SQL error: Event Repeat Views not compatible with i18n?
akahn - March 1, 2008 - 00:29
| Project: | Event Repeat Views |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
I have a View for listing various nodes tagged as "news," including some event module nodes. I'm trying to use the Event Repeat Views module to make it so that repeating events only show up once in this news view. When I try to add the filter for only showing distinct events, I get the following error:
user warning: Unknown column 'event_repeat.rid' in 'group statement' query: SELECT node.nid, node.created AS node_created_created FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( (node.status = '1') AND (term_node.tid IN ('2')) ) GROUP BY event_repeat.rid, node_created_created ORDER BY node_created_created DESC LIMIT 0, 3 in /home/.mandrake/akahn/akahn.net/drupal/includes/database.mysql.inc on line 172.
Can anyone explain why this is happening? Is it fixable?
Thanks,
Alex