Found creating a filter.

User posted or commented on node.
Option, not-one-of
Comma separated list of user names

(excuse me if this has been posted already. no time to search archives right now)

Preview result:


    * warning: array_fill() [function.array-fill]: Number of elements must be positive in C:\s\http\patriot_cluster\citizenmedic\000\modules\views\modules\comment\views_handler_filter_comment_user_uid.inc on line 11.
    * warning: implode() [function.implode]: Invalid arguments passed in C:\s\http\patriot_cluster\citizenmedic\000\modules\views\modules\comment\views_handler_filter_comment_user_uid.inc on line 12.
    * 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 ') OR ((SELECT COUNT(*) FROM comments c WHERE c.uid in () AND c.nid = node.' at line 6 query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM node node INNER JOIN users users ON node.uid = users.uid INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (node.uid in () OR ((SELECT COUNT(*) FROM comments c WHERE c.uid in () AND c.nid = node.nid) > 0)) ) count_alias in C:\s\http\patriot_cluster\citizenmedic\000\modules\views\includes\view.inc on line 729.
    * 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 ') OR ((SELECT COUNT(*) FROM comments c WHERE c.uid in () AND c.nid = node.' at line 15 query: SELECT node.nid AS nid, node.type AS node_type, node.title AS node_title, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, history_user.timestamp AS history_user_timestamp, history_user.nid AS history_user_nid, node.created AS node_created, node.changed AS node_changed FROM node node INNER JOIN users users ON node.uid = users.uid INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN history history_user ON node.nid = history_user.nid AND history_user.uid = 1 WHERE (node.status <> 0) AND (node.uid in () OR ((SELECT COUNT(*) FROM comments c WHERE c.uid in () AND c.nid = node.nid) > 0)) ORDER BY node_comment_statistics_last_comment_timestamp ASC LIMIT 0, 25 in C:\s\http\patriot_cluster\citizenmedic\000\modules\views\includes\view.inc on line 755.

Comments

ss_drupal’s picture

Project: Views (for Drupal 7) » Slideshow
Version: 6.x-2.6 » 4.7.x-0.9
Category: bug » support
Priority: Normal » Minor
Status: Active » Closed (fixed)
ss_drupal’s picture

Title: FYI: SQL error on filter - user posted or commented on node not one of ... » Miscellaneous
ss_drupal’s picture

Project: Slideshow » Attached Node
Version: 4.7.x-0.9 » 4.7.x-1.x-dev
kkaefer’s picture

I have no clue what your problem is. Furthermore, the version for 4.7 is no longer supported. If there is a bug and you provide a patch, I'm happy to commit it, but I won't actively patch bugs in this outdated version.

ss_drupal’s picture

This posting is an error.

Unfortunately there was no way to delete or edit it directly.

Please excuse.