I'm getting the following every time I click on "Unanswered Topics":
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.type AS node_type, node.title AS node_title, t' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, history_user.timestamp AS history_user_timestamp, history_user.nid AS history_user_nid, node.created AS node_created, node.changed AS node_changed, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, COALESCE(ncs_users.name, node_comment_statistics.last_comment_name) AS node_comment_statistics_last_comment_name, ncs_users.name AS ncs_user in /usr/www/users/nofrills/staging/public_html/includes/database.mysqli.inc on line 128
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.type AS node_type, node.title AS node_title, t' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, history_user.timestamp AS history_user_timestamp, history_user.nid AS history_user_nid, node.created AS node_created, node.changed AS node_changed, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, COALESCE(ncs_users.name, node_comment_statistics.last_comment_name) AS node_comment_statistics_last_comment_name, ncs_users.name AS ncs_users_name, node_commen in /usr/www/users/nofrills/staging/public_html/includes/database.mysqli.inc on line 128
...Similar errors for My Unread.
The resulting page renders (with pulldown menu for filtering forums, but no results even though there are unread and unanswered posts).
I'm running Node Comment as well as Advanced Forum in Panels using the latest dev snapshot of AF. That said, I did see this yesterday as well, before switching from AF Alpha 1, and I'm able to reproduce it without panels.
Everything else about AF seems to be working fine.
Comments
Comment #1
michelleViews bug, not AF bug, and it was fixed a couple weeks or so ago. Upgrade to the latest views dev and it should go away.
Michelle