htmlspecialchars error

Something looks wrong with your view. It should not reference "temp_search_results" in the filter.tablename. I suggest that you remove the filter and exposed filter, and try again, selecting "Search: Fast Index". If this is what you think you did, then please try again, just to make sure.

This filter that appears to work, exported view shown below:

  $view = new stdClass();
  $view->name = 'Drupal_Node_119557';
  $view->description = 'Drupal Node 119557 Test';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Drupal Node 119557';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = 'None Found';
  $view->page_empty_format = '1';
  $view->page_type = 'teaser';
  $view->url = 'drupal/node/119557';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '10';
  $view->sort = array (
    array (
      'tablename' => 'node',
      'field' => 'created',
      'sortorder' => 'ASC',
      'options' => 'normal',
    ),
  );
  $view->argument = array (
  );
  $view->field = array (
  );
  $view->filter = array (
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'operator' => '=',
      'options' => '',
      'value' => '',
    ),
  );
  $view->exposed_filter = array (
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'label' => '',
      'optional' => '0',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
  );
  $view->requires = array(node, search_index);
  $views[$view->name] = $view;

Sure it can... unless I miss something you are asking for. Anything you can create with views and the standard search filter, you can also create with this filter. I'm closing this issue. If you need help creating the view, please ping me or #drupal-support and someone can walk you through it.

I upgraded to Drupal 5.1. I've seen this on a lot of my admin pages. I went to the source of the errors "bootstrap.inc" and I tinkered with check_plain to see if I could suppress the errors:

function check_plain($text) {
  if (is_array($text)) {
	$output = $text;
	foreach ($output as $key => $value) {
	  $output[$key] = check_plain($value);	
	}  
  }
  else {
	$output = htmlspecialchars($text, ENT_QUOTES);	
  }
  return $output;
}

That suppressed the errors-- but now when I load the admin/build/block page I get "Array" where before I had blanks. I am going to continue digging in case this is a collision between localization, i8ln and other modules.

dewolfe001,

This is not the place to propose your core patch. Although, if you want my two cents, that's not the right patch. In general, I believe that Drupal core tries to optimize itself against extra checks like this and relies on the contrib authors to pass the right arguments. If there is a problem, the problem is in the contrib module not in Drupal core.

I suspect (hopt) that your problem is the same as morphirs. Please try recreating your view from scratch. If you still have problems, please export your view and paste it here (within <code> and </code> tags).

Thanks!

My problem is coming from almost anywhere on the site that uses check_plain (I say, *almost*, because it's happening everything I can see it, but I feel there must be some good firings on check_plain going on). All of the views and associated modules (eg. Insert Views and Views Theme Wizard, etc.) have been shut off. The problem persists. In debugging this, I trapped any arrays that went through check_plain and did a var_dump of those. All of my problem examples appear when form elements are going through check_plain. I can understands labels, values and form names going through for wrapping each by themselves, but there is something pushing the an entire array into the check_plain function and causing it to choke. The check_plain function is so straightforward, it doesn't have a way to account for arrays, so arrays should never be passed in.

This is all from a Drupal 4.7 => 5.1 upgrade I did, but soon after the install (and well before alot of modules were added or turned on), this problem began to manifest itself and I found it occurring on most of the admin pages.

I dug deeper and looked at a form_element hook I was implementing at the theme level. Its output was a string, but it was triggering check_plain calls and passing in an array:

function cila1_form_element($title, $value, $description = NULL, $id = NULL, $required = FALSE, $error = FALSE) {
  $output  = '<div class="form-item '.(($GLOBALS['even_odd']++ % 2) ? 'on' : 'off').'">'."\n";
  $required = $required ? '<span class="form-required" title="'. t('This field is required.') .'">*</span>' : '';

  if ($title) {
    if ($id) {
      $output .= ' <label for="'. form_clean_id($id) .'">'. t('%title: %required', array('%title' => $title, '%required' => $required)) . "</label>\n";
    }
    else {
      $output .= ' <label>'. t('%title: %required', array('%title' => $title, '%required' => $required)) . "</label>\n";
    }
  }

  $output .= " $value\n";

  if ($description) {
    $output .= ' <div class="description">'. $description ."</div>\n";
  }

  $output .= "</div>\n";

  return $output;
}

The call to t() triggered a call to check_plain() if the value of one of the %title or %required were '@', causing this issue to manifest itself.

So, short-story-long, I found the bug and that was what it was.

All the best,

Mike

sorry but i had to re-open this... i just started trying to use this module and i get the htmlspecialchars error. Found this post but don't see any solution here; so not sure why it is closed.

Also of interest is the fact that i only get the error when i select the OR case, not if i select AND case. I took a look at the 2 different exports and it looks like this is possibly the issue:

OR case

  $view = new stdClass();
  $view->name = 'search_forums';
  $view->description = '';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Forum Search';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'teaser';
  $view->url = 'search/forums';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '20';
  $view->menu = TRUE;
  $view->menu_title = 'Forums';
  $view->menu_tab = TRUE;
  $view->menu_tab_default = FALSE;
  $view->menu_tab_weight = '0';
  $view->sort = array (
  );
  $view->argument = array (
  );
  $view->field = array (
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'forum',
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'distinct',
      'operator' => '=',
      'options' => '',
      'value' => array (
),
    ),
  );
  $view->exposed_filter = array (
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'label' => '',
      'optional' => '0',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
  );
  $view->requires = array(node, search_index);
  $views[$view->name] = $view;

and the AND case:

  $view = new stdClass();
  $view->name = 'search_forums';
  $view->description = '';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Forum Search';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'teaser';
  $view->url = 'search/forums';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '20';
  $view->menu = TRUE;
  $view->menu_title = 'Forums';
  $view->menu_tab = TRUE;
  $view->menu_tab_default = FALSE;
  $view->menu_tab_weight = '0';
  $view->sort = array (
  );
  $view->argument = array (
  );
  $view->field = array (
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'forum',
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'operator' => '=',
      'options' => '',
      'value' => '',
    ),
    array (
      'tablename' => 'node',
      'field' => 'distinct',
      'operator' => '=',
      'options' => '',
      'value' => array (
),
    ),
  );
  $view->exposed_filter = array (
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'label' => '',
      'optional' => '0',
      'is_default' => '0',
      'operator' => '0',
      'single' => '0',
    ),
  );
  $view->requires = array(node, search_index);
  $views[$view->name] = $view;

in the OR case this code looks like the difference:

array (
      'tablename' => 'search_index',
      'field' => 'word',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),

where there is an empty array for 'value'.. not sure; but looking through rest of this thread i do doubt that the issue is with bootstrap...

oh yea.. and one last thing... O M G.. how great is this module.. you can't imagine the amount of work this has saved me.. :)... well, at least assuming i get this bug sorted out.

Peter Lindstrom
LiquidCMS - Content Management Solution Experts

and one more test.. i took the export from OR case above and modified the odd looking bit to be this:

array (
      'tablename' => 'search_index',
      'field' => 'word',
      'operator' => 'OR',
      'options' => '',
      'value' => '',
    ),

and it seems to save without errors.

Will need to do a few actual search tests to see that it is actually doing the right thing.. but so far this does look like a bug in this module. Will take a loko at the module code if it looks like this solution works.

well i thought it looked fixed.. but when i go to edit the view again.. the error is back (without saving).. but when i look at the export of the newly imported view it has put this code back the way it was.

ok, i found this post: http://drupal.org/node/142755

which seems like it might be on the right track.. my sql now looks better with the OR, but i see a double DISTINCT that looks wrong.. but then i think i saw another post about that error

ok, 2 patches later.. and it seems to work.. i still get the htmlspecialchars error when i save a view with the OR case; but the view still seems to be working and searching correctly.

I also get this out of the box w/Druapl 5.1 and Views 1.6, trying to set up a real simple view. I've used this (great!) module before, but this is the first time I've seen this bug.

The view is as follows:

  $view = new stdClass();
  $view->name = 'directory';
  $view->description = 'Staff Directory';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'IFTF Staff Directory';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'table';
  $view->url = 'people/directory';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '50';
  $view->menu = TRUE;
  $view->menu_title = 'directory';
  $view->menu_tab = FALSE;
  $view->menu_tab_weight = '0';
  $view->menu_tab_default = FALSE;
  $view->menu_tab_default_parent = NULL;
  $view->menu_tab_default_parent_type = 'tab';
  $view->menu_parent_tab_weight = '0';
  $view->menu_parent_title = '';
  $view->sort = array (
  );
  $view->argument = array (
  );
  $view->field = array (
    array (
      'tablename' => 'users',
      'field' => 'uid',
      'label' => '',
    ),
    array (
      'tablename' => 'node_data_field_first_name',
      'field' => 'field_first_name_value',
      'label' => 'First Name',
      'handler' => 'content_views_field_handler_group',
      'sortable' => '1',
      'options' => 'default',
    ),
    array (
      'tablename' => 'node_data_field_last_name',
      'field' => 'field_last_name_value',
      'label' => 'Last Name',
      'handler' => 'content_views_field_handler_group',
      'sortable' => '1',
      'defaultsort' => 'ASC',
      'options' => 'default',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'users_roles',
      'field' => 'rid',
      'operator' => 'AND',
      'options' => '',
      'value' => array (
  0 => '3',
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'bio',
),
    ),
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),
  );
  $view->exposed_filter = array (
    array (
      'tablename' => 'search_index',
      'field' => 'word',
      'label' => '',
      'optional' => '1',
      'is_default' => '0',
      'operator' => '1',
      'single' => '1',
    ),
  );
  $view->requires = array(users, node_data_field_first_name, node_data_field_last_name, users_roles, node, search_index);
  $views[$view->name] = $view;

I can't reproduce this on 5.x-1.1 or on the 5.x-1.x-dev (recently released as 5.x-2.x-dev) versions. Please try with the latest versions of views and VFS. Unless there's a strong compelling reason, I will no longer be supporting the 5.x-1.x branch.

Closing this once again...

I think this is a views or FAPI issue: http://drupal.org/node/119557

Woops, wrong link; http://drupal.org/node/179010