Posted by ronia on June 21, 2009 at 1:46pm
Jump to:
| Project: | abuse |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
| Issue tags: | views |
Issue Summary
Nodes auto-hidden, hidden or removed
by Abuse http://drupal.org/project/abuse
remain accessible - Views list continue to
show the title
and clicking the title
the node is accessible.
Since it is impossible to work with Abuse
this makes the site pretty broken.
I do not know whose fault it is -
Abuse or Views
but this needs fixing today and now!
Please help.
Comments
#1
Either you need to add a filter that abuse provides, or abuse is using db_rewrite_sql. Either way this isn't a Views issue.
#2
merlinofchaos is correct - it isn't a views issue (sorry, Merlin, on getting dragged into this issue from abuse again and again) Abuse isn't using db_rewrite_sql but it is changing the node status value (can blame my lack of properly using the hooks and limited usage for the module on my end) from the nodeapi hook. This definetly needs to be addressed (and its a somewhat large rewrite). I have not been able to give this module the attention it needs (moving countries, changing jobs, lack of usage for this module by me) but will try and figure out time to work on this.
#3
This module should be removed from the Drupal downloads until it is fixed.
This isn't garden variety breakage. It does the OPPOSITE of what's intended.
I am in the midst of removing some 4,000 porn, drug and link spam blog posts from one of our sites. Fortunately, Views Bulk Operations makes this fairly straightforward.
You can clean up the mess by importing the following view. Before saving, be sure to EDIT THE ALLOWED CONTENT TYPES to match those available on your site.
This view will add a tab to your admin/content page that will find all nodes whose authors have been blocked, and will let you bulk-unpublish them.
$view = new view;$view->name = 'node_orphans';
$view->description = 'Find nodes whose accounts have been blocked';
$view->tag = 'Admin';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('fields', array(
'nid' => array(
'label' => 'Nid',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 1,
'exclude' => 0,
'id' => 'nid',
'table' => 'node',
'field' => 'nid',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
'type' => array(
'label' => 'Type',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 0,
'machine_name' => 0,
'exclude' => 0,
'id' => 'type',
'table' => 'node',
'field' => 'type',
'relationship' => 'none',
),
'title' => array(
'label' => 'Title',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'relationship' => 'none',
),
'name' => array(
'label' => 'Name',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_user' => 1,
'overwrite_anonymous' => 0,
'anonymous_text' => '',
'exclude' => 0,
'id' => 'name',
'table' => 'users',
'field' => 'name',
'relationship' => 'none',
),
));
$handler->override_option('sorts', array(
'nid' => array(
'order' => 'DESC',
'id' => 'nid',
'table' => 'node',
'field' => 'nid',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
));
$handler->override_option('filters', array(
'status' => array(
'operator' => '=',
'value' => '1',
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'status',
'table' => 'node',
'field' => 'status',
'relationship' => 'none',
),
'status_1' => array(
'id' => 'status_1',
'table' => 'users',
'field' => 'status',
),
'type' => array(
'operator' => 'in',
'value' => array(
'image' => 'image',
'blogmu' => 'blogmu',
'blog_post' => 'blog_post',
'forum' => 'forum',
),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'type_op',
'identifier' => 'type',
'label' => 'Node: Type',
'optional' => 1,
'single' => 1,
'remember' => 1,
'reduce' => 1,
),
'id' => 'type',
'table' => 'node',
'field' => 'type',
'relationship' => 'none',
),
'uid' => array(
'operator' => 'in',
'value' => '',
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'uid_op',
'identifier' => 'uid',
'label' => 'User: Name',
'optional' => 1,
'remember' => 0,
'reduce' => 0,
),
'id' => 'uid',
'table' => 'users',
'field' => 'uid',
'override' => array(
'button' => 'Override',
),
'relationship' => 'none',
),
));
$handler->override_option('access', array(
'type' => 'perm',
'perm' => 'administer nodes',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler->override_option('style_plugin', 'bulk');
$handler->override_option('style_options', array(
'grouping' => '',
'override' => 1,
'sticky' => 1,
'order' => 'asc',
'columns' => array(
'type' => 'type',
'title' => 'title',
'name' => 'name',
'nid' => 'nid',
),
'info' => array(
'type' => array(
'sortable' => 0,
'separator' => '',
),
'title' => array(
'sortable' => 0,
'separator' => '',
),
'name' => array(
'sortable' => 1,
'separator' => '',
),
'nid' => array(
'sortable' => 1,
'separator' => '',
),
),
'default' => '-1',
'execution_type' => '1',
'display_type' => '0',
'hide_select_all' => 0,
'skip_confirmation' => 0,
'display_result' => 1,
'merge_single_action' => 1,
'selected_operations' => array(
'node_mass_update:0ccad85c1ebe4c9ceada1aa64293b080' => 'node_mass_update:0ccad85c1ebe4c9ceada1aa64293b080',
'flag_nodes:0c012f9cb2355ae83f00e95078b0bfd8' => 0,
'nodequeue_add_action' => 0,
'node_assign_owner_action' => 0,
'nodewords_mass_update:48d00920397f9d8f23f7088c88056286' => 0,
'views_bulk_operations_delete_node_action' => 0,
'node_mass_update:a27b9efabcd054685a549378b174ad11' => 0,
'system_message_action' => 0,
'token_actions_message_action' => 0,
'views_bulk_operations_script_action' => 0,
'node_make_sticky_action' => 0,
'node_make_unsticky_action' => 0,
'flag_nodes:98fdd0311ba8e28087bb103ba33cf99a' => 0,
'node_mass_update:c4d3b28efb86fd703619a50b74d43794' => 0,
'views_bulk_operations_fields_action' => 0,
'views_bulk_operations_taxonomy_action' => 0,
'views_bulk_operations_argument_selector_action' => 0,
'twitter_actions_set_status_action' => 0,
'node_promote_action' => 0,
'node_mass_update:14de7d028b4bffdf2b4a266562ca18ac' => 0,
'node_mass_update:9c585624b9b3af0b4687d5f97f35e047' => 0,
'node_publish_action' => 0,
'image_operations_rebuild' => 0,
'token_actions_goto_action' => 0,
'system_goto_action' => 0,
'emfield_operations_reload' => 0,
'flag_nodes:98c0f7017877a9fcfa002a5f5d45d42a' => 0,
'flag_nodes:217a9779edd6e8499f935e7c023f5239' => 0,
'nodequeue_remove_action' => 0,
'node_unpromote_action' => 0,
'node_mass_update:8ce21b08bb8e773d10018b484fe4815e' => 0,
'node_save_action' => 0,
'system_send_email_action' => 0,
'token_actions_send_email_action' => 0,
'node_unpublish_action' => 0,
'node_unpublish_by_keyword_action' => 0,
'pathauto_node_operations_update' => 0,
),
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('fields', array(
'type' => array(
'label' => 'Type',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 0,
'machine_name' => 0,
'exclude' => 0,
'id' => 'type',
'table' => 'node',
'field' => 'type',
'relationship' => 'none',
),
'title' => array(
'label' => 'Title',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'relationship' => 'none',
),
'name' => array(
'label' => 'Name',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_user' => 1,
'overwrite_anonymous' => 0,
'anonymous_text' => '',
'exclude' => 0,
'id' => 'name',
'table' => 'users',
'field' => 'name',
'relationship' => 'none',
),
'nid' => array(
'label' => 'Nid',
'alter' => array(
'alter_text' => 0,
'text' => '',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 0,
'exclude' => 0,
'id' => 'nid',
'table' => 'node',
'field' => 'nid',
'override' => array(
'button' => 'Use default',
),
'relationship' => 'none',
),
));
$handler->override_option('items_per_page', 100);
$handler->override_option('use_pager', '1');
$handler->override_option('path', 'admin/content/node/orphans');
$handler->override_option('menu', array(
'type' => 'tab',
'title' => 'Orphan nodes',
'description' => 'Nodes whose owners have been blocked',
'weight' => '0',
'name' => 'navigation',
));
$handler->override_option('tab_options', array(
'type' => 'none',
'title' => '',
'description' => '',
'weight' => 0,
'name' => 'navigation',
));
#4
Duplicate of #315404: Abuse Module to work with Views 2?