user error: Unknown column 'n.nid' in 'on clause'
query: SELECT DISTINCT(n.nid), e.event_start FROM event e INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON n.nid = e.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0')) AND n.status = 1 AND ((e.event_start > 1335830400 AND e.event_start < 1338508799) OR (e.event_end > 1335830400 AND e.event_end < 1338508799) OR (e.event_start < 1335830400 AND e.event_end > 1338508799)) ORDER BY event_start in /home/beacon/public_html/includes/database.mysql.inc on line 66.user error: Unknown column 'n.nid' in 'on clause'
query: SELECT DISTINCT(n.nid), e.event_start FROM event e INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON n.nid = e.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0')) AND n.status = 1 AND ((e.event_start > 1338508800 AND e.event_start < 1341100799) OR (e.event_end > 1338508800 AND e.event_end < 1341100799) OR (e.event_start < 1338508800 AND e.event_end > 1341100799)) ORDER BY event_start in /home/beacon/public_html/includes/database.mysql.inc on line 66.
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|||
|
|
|