Installed organic groups module. Enabled OG, access control, and views integrator. It suggest I rebuild node permissions, which I did. Now on pages with views I get errors for just about every view I have, like:

* 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(node.nid), node_data_field_date.field_date_value AS node_data_field_' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node.title AS node_title, node_data_field_date.nid AS node_data_field_date_nid, node.type AS node_type, location.name AS location_name FROM node node LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid INNER JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN location location ON location_instance.lid = location.lid WHERE ((node.status <> 0) AND (node.type in ('event')) AND (term_node.tid = 12)) AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2009-01-12') AND (DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') <= '2009-01-18')) ORDER BY node_data_field_date_field_date_value DESC ) count_alias in /home/starastr/public_html/test/sites/all/modules/views/includes/view.inc on line 699.

Any clues? MySQL version is 5.0.67-community-log

Comments

nickbits’s picture

Hi Mike,

I have exactly the same problem. No solution yet.

Nick

----------------------------------
Nick Young
www.nickbits.co.uk / www.drnick.me.uk

------------oOo----------------------
Nick Young (www.nickbits.co.uk)