Whether or not the user actually has content that matches the view, this is posted:
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) AS node_nid FROM node node LEFT JOIN comments comments ON no' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, DISTINCT(node.nid) AS node_nid FROM node node LEFT JOIN comments comments ON node.nid = comments.nid AND comments.uid = '1' WHERE (node.status = '1') AND (node.uid = '1' OR comments.uid = '1') AND ((node.type NOT IN ('page') OR node.type IS NULL)) ORDER BY node.created DESC LIMIT 0, 10 in /home/mysite/public_html/includes/database.mysql.inc on line 120.
Comments
Comment #1
agileware commentedThe 4.7 version is no longer supported.