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 > 1328054400 AND e.event_start < 1330559999) OR (e.event_end > 1328054400 AND e.event_end < 1330559999) OR (e.event_start < 1328054400 AND e.event_end > 1330559999)) 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 > 1330560000 AND e.event_start < 1333238399) OR (e.event_end > 1330560000 AND e.event_end < 1333238399) OR (e.event_start < 1330560000 AND e.event_end > 1333238399)) ORDER BY event_start in /home/beacon/public_html/includes/database.mysql.inc on line 66.
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|||
|
|
|