From: Stephen F. <spf...@gm...> - 2014-04-22 16:25:44
|
Hi Chuming, I am at a loss as to what might be wrong. It's very unusual that Drupal would not pick up the changes to the view. In every instance we have, it picks up changes with just a simple cache clearing (as long as it hasn't already been customized). So, can you try this. Go to 'Structure' -> 'Views' and click the 'Import' link. Cut-and-paste the code below into code box on the page and check the box "Replace an existing view if one exists with the same name". That will replace whatever Drupal thinks you have with what it should be. Stephen $view = new view(); $view->name = 'tripal_feature_user_feature'; $view->description = 'Allows users to search feature data'; $view->tag = 'tripal search'; $view->base_table = 'feature'; $view->human_name = 'Feature User Search'; $view->core = 0; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: features_all */ $handler = $view->new_display('default', 'features_all', 'default'); $handler->display->display_options['title'] = 'Sequence Features'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['access']['type'] = 'perm'; $handler->display->display_options['access']['perm'] = 'access chado_feature content'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '25'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['pager']['options']['id'] = '0'; $handler->display->display_options['pager']['options']['quantity'] = '9'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['grouping'] = ''; $handler->display->display_options['style_options']['columns'] = array( 'accession' => 'accession', 'accession_link' => 'accession_link', 'name' => 'name', 'uniquename' => 'uniquename', 'name_1' => 'name_1', 'common_name' => 'common_name', 'seqlen' => 'seqlen', 'is_obsolete' => 'is_obsolete', 'is_analysis' => 'is_analysis', 'nid' => 'nid', ); $handler->display->display_options['style_options']['default'] = '-1'; $handler->display->display_options['style_options']['info'] = array( 'accession' => array( 'sortable' => 1, 'separator' => '', ), 'accession_link' => array( 'sortable' => 1, 'separator' => '', ), 'name' => array( 'sortable' => 1, 'separator' => '', ), 'uniquename' => array( 'sortable' => 1, 'separator' => '', ), 'name_1' => array( 'sortable' => 1, 'separator' => '', ), 'common_name' => array( 'sortable' => 1, 'separator' => '', ), 'seqlen' => array( 'sortable' => 1, 'separator' => '', ), 'is_obsolete' => array( 'sortable' => 1, 'separator' => '', ), 'is_analysis' => array( 'sortable' => 1, 'separator' => '', ), 'nid' => array( 'separator' => '', ), ); /* No results behavior: Global: Text area */ $handler->display->display_options['empty']['text']['id'] = 'area'; $handler->display->display_options['empty']['text']['table'] = 'views'; $handler->display->display_options['empty']['text']['field'] = 'area'; $handler->display->display_options['empty']['text']['content'] = 'No features matched the supplied criteria.'; $handler->display->display_options['empty']['text']['format'] = '2'; /* Relationship: Feature: Feature => Node */ $handler->display->display_options['relationships']['feature_id']['id'] = 'feature_id'; $handler->display->display_options['relationships']['feature_id']['table'] = 'chado_feature'; $handler->display->display_options['relationships']['feature_id']['field'] = 'feature_id'; /* Field: Content: Nid */ $handler->display->display_options['fields']['nid']['id'] = 'nid'; $handler->display->display_options['fields']['nid']['table'] = 'node'; $handler->display->display_options['fields']['nid']['field'] = 'nid'; $handler->display->display_options['fields']['nid']['relationship'] = 'feature_id'; $handler->display->display_options['fields']['nid']['exclude'] = TRUE; /* Field: Node URL */ $handler->display->display_options['fields']['nid_1']['id'] = 'nid_1'; $handler->display->display_options['fields']['nid_1']['table'] = 'node'; $handler->display->display_options['fields']['nid_1']['field'] = 'nid'; $handler->display->display_options['fields']['nid_1']['relationship'] = 'feature_id'; $handler->display->display_options['fields']['nid_1']['ui_name'] = 'Node URL'; $handler->display->display_options['fields']['nid_1']['label'] = ''; $handler->display->display_options['fields']['nid_1']['exclude'] = TRUE; $handler->display->display_options['fields']['nid_1']['alter']['alter_text'] = TRUE; $handler->display->display_options['fields']['nid_1']['alter']['text'] = 'node/[nid]'; $handler->display->display_options['fields']['nid_1']['element_label_colon'] = FALSE; /* Field: Chado Feature: Uniquename */ $handler->display->display_options['fields']['uniquename']['id'] = 'uniquename'; $handler->display->display_options['fields']['uniquename']['table'] = 'feature'; $handler->display->display_options['fields']['uniquename']['field'] = 'uniquename'; $handler->display->display_options['fields']['uniquename']['label'] = 'Unique Name'; $handler->display->display_options['fields']['uniquename']['alter']['make_link'] = TRUE; $handler->display->display_options['fields']['uniquename']['alter']['path'] = '[nid_1]'; /* Field: Chado Feature: Name */ $handler->display->display_options['fields']['name']['id'] = 'name'; $handler->display->display_options['fields']['name']['table'] = 'feature'; $handler->display->display_options['fields']['name']['field'] = 'name'; $handler->display->display_options['fields']['name']['alter']['make_link'] = TRUE; $handler->display->display_options['fields']['name']['alter']['path'] = '[nid_1]'; /* Field: Chado Cvterm: Name */ $handler->display->display_options['fields']['name_1']['id'] = 'name_1'; $handler->display->display_options['fields']['name_1']['table'] = 'cvterm'; $handler->display->display_options['fields']['name_1']['field'] = 'name'; $handler->display->display_options['fields']['name_1']['label'] = 'Type'; /* Field: Chado Organism: Common Name */ $handler->display->display_options['fields']['common_name']['id'] = 'common_name'; $handler->display->display_options['fields']['common_name']['table'] = 'organism'; $handler->display->display_options['fields']['common_name']['field'] = 'common_name'; /* Field: Chado Feature: Seqlen */ $handler->display->display_options['fields']['seqlen']['id'] = 'seqlen'; $handler->display->display_options['fields']['seqlen']['table'] = 'feature'; $handler->display->display_options['fields']['seqlen']['field'] = 'seqlen'; $handler->display->display_options['fields']['seqlen']['label'] = 'Sequence Length'; /* Field: Chado Feature: Is Obsolete */ $handler->display->display_options['fields']['is_obsolete']['id'] = 'is_obsolete'; $handler->display->display_options['fields']['is_obsolete']['table'] = 'feature'; $handler->display->display_options['fields']['is_obsolete']['field'] = 'is_obsolete'; $handler->display->display_options['fields']['is_obsolete']['type'] = 'separator'; $handler->display->display_options['fields']['is_obsolete']['not'] = 0; /* Sort criterion: Chado Organism: Common Name */ $handler->display->display_options['sorts']['common_name']['id'] = 'common_name'; $handler->display->display_options['sorts']['common_name']['table'] = 'organism'; $handler->display->display_options['sorts']['common_name']['field'] = 'common_name'; /* Sort criterion: Chado Cvterm: Name */ $handler->display->display_options['sorts']['name']['id'] = 'name'; $handler->display->display_options['sorts']['name']['table'] = 'cvterm'; $handler->display->display_options['sorts']['name']['field'] = 'name'; /* Sort criterion: Chado Feature: Name */ $handler->display->display_options['sorts']['name_1']['id'] = 'name_1'; $handler->display->display_options['sorts']['name_1']['table'] = 'feature'; $handler->display->display_options['sorts']['name_1']['field'] = 'name'; /* Filter criterion: Chado Feature: Uniquename */ $handler->display->display_options['filters']['uniquename']['id'] = 'uniquename'; $handler->display->display_options['filters']['uniquename']['table'] = 'feature'; $handler->display->display_options['filters']['uniquename']['field'] = 'uniquename'; $handler->display->display_options['filters']['uniquename']['operator'] = 'contains'; $handler->display->display_options['filters']['uniquename']['group'] = 1; $handler->display->display_options['filters']['uniquename']['exposed'] = TRUE; $handler->display->display_options['filters']['uniquename']['expose']['operator_id'] = 'uniquename_op'; $handler->display->display_options['filters']['uniquename']['expose']['label'] = 'Unique Name'; $handler->display->display_options['filters']['uniquename']['expose']['use_operator'] = TRUE; $handler->display->display_options['filters']['uniquename']['expose']['operator'] = 'uniquename_op'; $handler->display->display_options['filters']['uniquename']['expose']['identifier'] = 'uniquename'; $handler->display->display_options['filters']['uniquename']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 3 => 0, ); $handler->display->display_options['filters']['uniquename']['select_optional'] = TRUE; $handler->display->display_options['filters']['uniquename']['max_length'] = '40'; /* Filter criterion: Chado Feature: Name */ $handler->display->display_options['filters']['name_1']['id'] = 'name_1'; $handler->display->display_options['filters']['name_1']['table'] = 'feature'; $handler->display->display_options['filters']['name_1']['field'] = 'name'; $handler->display->display_options['filters']['name_1']['operator'] = 'contains'; $handler->display->display_options['filters']['name_1']['group'] = 1; $handler->display->display_options['filters']['name_1']['exposed'] = TRUE; $handler->display->display_options['filters']['name_1']['expose']['operator_id'] = 'name_1_op'; $handler->display->display_options['filters']['name_1']['expose']['label'] = 'Name Contains'; $handler->display->display_options['filters']['name_1']['expose']['use_operator'] = TRUE; $handler->display->display_options['filters']['name_1']['expose']['operator'] = 'name_1_op'; $handler->display->display_options['filters']['name_1']['expose']['identifier'] = 'name'; $handler->display->display_options['filters']['name_1']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 3 => 0, ); /* Filter criterion: Chado Feature: Type Id */ $handler->display->display_options['filters']['type_id']['id'] = 'type_id'; $handler->display->display_options['filters']['type_id']['table'] = 'feature'; $handler->display->display_options['filters']['type_id']['field'] = 'type_id'; $handler->display->display_options['filters']['type_id']['value'] = array(); $handler->display->display_options['filters']['type_id']['group'] = 1; $handler->display->display_options['filters']['type_id']['exposed'] = TRUE; $handler->display->display_options['filters']['type_id']['expose']['operator_id'] = 'type_id_op'; $handler->display->display_options['filters']['type_id']['expose']['label'] = 'Type'; $handler->display->display_options['filters']['type_id']['expose']['operator'] = 'type_id_op'; $handler->display->display_options['filters']['type_id']['expose']['identifier'] = 'type_id'; $handler->display->display_options['filters']['type_id']['values_form_type'] = 'select'; $handler->display->display_options['filters']['type_id']['select_optional'] = TRUE; /* Filter criterion: Chado Organism: Common Name */ $handler->display->display_options['filters']['common_name']['id'] = 'common_name'; $handler->display->display_options['filters']['common_name']['table'] = 'organism'; $handler->display->display_options['filters']['common_name']['field'] = 'common_name'; $handler->display->display_options['filters']['common_name']['value'] = array(); $handler->display->display_options['filters']['common_name']['group'] = 1; $handler->display->display_options['filters']['common_name']['exposed'] = TRUE; $handler->display->display_options['filters']['common_name']['expose']['operator_id'] = 'common_name_op'; $handler->display->display_options['filters']['common_name']['expose']['label'] = 'Organism Common Name'; $handler->display->display_options['filters']['common_name']['expose']['operator'] = 'common_name_op'; $handler->display->display_options['filters']['common_name']['expose']['identifier'] = 'organism'; $handler->display->display_options['filters']['common_name']['values_form_type'] = 'select'; $handler->display->display_options['filters']['common_name']['select_optional'] = TRUE; /* Display: Page */ $handler = $view->new_display('page', 'Page', 'page_1'); $handler->display->display_options['path'] = 'chado/feature'; $handler->display->display_options['menu']['type'] = 'normal'; $handler->display->display_options['menu']['title'] = 'Features'; $handler->display->display_options['menu']['description'] = 'A biological sequence or a section of a biological sequence, or a collection of such sections.'; $handler->display->display_options['menu']['weight'] = '-10'; On 4/21/2014 6:22 PM, Chuming Chen wrote: > Yes, the public.cache_views table then populated when I navigate to > "Structure"->"Views". > > I have site search enabled, don't know whether that will interfere > with "Search Data". > > Chuming > > > On Mon, Apr 21, 2014 at 5:04 PM, Stephen Ficklin <spf...@gm... > <mailto:spf...@gm...>> wrote: > > If you navigate to 'Structure' -> 'Views' is the > public.cache_views table then populated? > > > On 4/21/2014 5:00 PM, Chuming Chen wrote: > > On Apr 21, 2014, at 4:50 PM, Stephen Ficklin > <spf...@gm... <mailto:spf...@gm...>> wrote: > > You wouldn't be able to uninstall Views without also > uninstalling Tripal as it's a dependency and uninstalling > Tripal will result in the loss of all of your organism, > feature, etc. pages (but not loss of data in Chado) which > you probably don't want to do. There must be something > else causing Drupal to not pick up the changes. Here are > a few other things to try: > > 1) Try clearing the Views cache directly: 'drush cc views'. > > I have run this command many times. > > 2) Try the brute force method of using phppgadmin (or psql > on the command-line) and emptying the contents of the > public.cache_views table. > > I checked this table from phppgadmin, not data. > > As a long shot.... you don't happen to have more than one > Tripal installation do you? > > I have tripal 1.1 and tripal 2.0, but they are in different > directories and using different databases. > > Stephen > > Chuming > > > |