Resources
This section is to provide contacts, reference materials, tools and other information to save time and trouble for leaseholders, residents and suppliers.
Internal Directory
RALA Committee
625 reads
user error: Unknown column 'n.nid' in 'on clause'
query: SELECT DISTINCT(n.nid), n.title, u.uid, u.name FROM node_counter s INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON s.nid = n.nid INNER JOIN users u ON n.uid = u.uid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','term_access1')) AND s.daycount <> '0' AND n.status = 1 ORDER BY s.daycount DESC LIMIT 0, 3 in /home/genghis/sites/nellgwynn.com/includes/database.mysql.inc on line 66.user error: Unknown column 'n.nid' in 'on clause'
query: SELECT DISTINCT(n.nid), n.title, u.uid, u.name FROM node_counter s INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node n ON s.nid = n.nid INNER JOIN users u ON n.uid = u.uid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','term_access1')) AND s.timestamp <> '0' AND n.status = 1 ORDER BY s.timestamp DESC LIMIT 0, 3 in /home/genghis/sites/nellgwynn.com/includes/database.mysql.inc on line 66.