No search results with exposed "search terms" filter

Hi,

Below you can find a view that i'm using to test.

$view = new view;
$view->name = 'Gebruikerslijst2';
$view->description = 'Gebruikerslijst';
$view->tag = 'Gebruikerslijst';
$view->view_php = '';
$view->base_table = 'users';
$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', 'Gebruikerslijst', 'default');
$handler->override_option('fields', array(
  'name' => array(
    'label' => 'Gebruikersnaam',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_user' => 1,
    'overwrite_anonymous' => 0,
    'anonymous_text' => '',
    'exclude' => 0,
    'id' => 'name',
    'table' => 'users',
    'field' => 'name',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
  'mail' => array(
    'label' => 'E-mailadres',
    'alter' => array(
      'alter_text' => 0,
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'html' => 0,
    ),
    'link_to_user' => '0',
    'exclude' => 0,
    'id' => 'mail',
    'table' => 'users',
    'field' => 'mail',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('filters', array(
  'keys' => array(
    'operator' => 'optional',
    'value' => '',
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => 'keys_op',
      'label' => 'Zoeken: Search Terms',
      'use_operator' => 0,
      'identifier' => 'keys',
      'optional' => 0,
      'remember' => 0,
    ),
    'id' => 'keys',
    'table' => 'search_index',
    'field' => 'keys',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('title', 'Profiel zoeken');
$handler->override_option('header_format', '2');
$handler->override_option('header_empty', 0);
$handler->override_option('items_per_page', 0);
$handler->override_option('use_pager', '0');
$handler->override_option('distinct', 1);
$handler->override_option('style_plugin', 'list');
$handler->override_option('style_options', array(
  'grouping' => '',
  'type' => 'ul',
));
$handler->override_option('row_options', array(
  'inline' => array(
    'picture' => 'picture',
    'name' => 'name',
    'created' => 'created',
    'access' => 'access',
  ),
  'separator' => '',
));
$handler = $view->new_display('page', 'Pagina', 'page_1');
$handler->override_option('filters', array(
  'keys' => array(
    'operator' => 'optional',
    'value' => '',
    'group' => '0',
    'exposed' => TRUE,
    'expose' => array(
      'use_operator' => 0,
      'operator' => 'keys_op',
      'identifier' => 'keys',
      'label' => 'Zoeken: Search Terms',
      'optional' => 0,
      'remember' => 0,
    ),
    'id' => 'keys',
    'table' => 'search_index',
    'field' => 'keys',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Use default',
    ),
  ),
));
$handler->override_option('path', 'testzoeken');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => 'Gebruikerslijst',
  'description' => 'Gebruikerslijst',
  'weight' => '2',
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
));

Thanks for your help,

Gunther

Ow sorry merlinofchaos,

Here it is:

SELECT DISTINCT(users.uid) AS uid,
   users.name AS users_name,
   users.mail AS users_mail
 FROM users users

Actually very simple, but when i give in my username in the search field, it doesn't appear.

Any ideas where it goes wrong?

Thanks,
Gunther

Hi merlinofchaos,

Yes, it's very odd! My live preview works, but when i give in a search term on my page, it doesn't give me results. Only when it's not filled in.

In my attach you can find a screenshot of my view. Some words are dutch, but maybe it can help to find the problem.

Thanks for your time,
Gunther

Mm, so you know what's wrong or?

Thanks!

Sorry, but how can i do that? I'm quite new in Drupal.

Thanks,
Gunther

Hi merlinofchaos,

Here you have another query, when i'm searching for my username. (i didn't know that you could test this too in the live preview)

SELECT DISTINCT(users.uid) AS uid,
   SUM(search_index.score * search_total.count) AS score,
   users.name AS users_name,
   users.mail AS users_mail
 FROM users users 
 LEFT JOIN search_index search_index ON users.uid = search_index.sid
 LEFT JOIN search_total search_total ON search_index.word = search_total.word
 WHERE (search_index.word = 'guntherdevisch') AND (search_index.type = 'users')
 GROUP BY search_index.sid, uid, users_name, users_mail
 HAVING COUNT(*) >= 1

Maybe there is something wrong with this query, because i'm getting no results.

Thanks!
Gunther

Can somebody help me? Merlinofchaos? Or someone else?

Thanks!
Gunther

Hi,

I just installed the 6.x-2.6 version of views, but i'm still having the problem with my exposed search filter:(

@tkamen: Do you have the problem only when you expose the search filter on a list of users or?

Any help is welcome.

Thanks,
Gunther

Hi,

Thanks for your feedback.

I have tested my view in the live preview on my page display, but i'm getting no results.

Here's my query:

SELECT DISTINCT(users.uid) AS uid,
   SUM(search_index.score * search_total.count) AS score,
   users.mail AS users_mail,
   users.name AS users_name
 FROM users users 
 LEFT JOIN search_index search_index ON users.uid = search_index.sid
 LEFT JOIN search_total search_total ON search_index.word = search_total.word
 WHERE (search_index.word = 'test') AND (search_index.type = 'users')
 GROUP BY search_index.sid, uid, users_mail, users_name
 HAVING COUNT(*) >= 1

Here, i'm searching on a username, called 'test'. I also tried other usernames/usermails, but no results are given. Only when i leave the search-box empty, i'm getting all the results.

In the attachment, you can find a screenshot of my page display (note: my view is in dutch, hope you can understand).

I also tried updating my cron manually, but that didn't did the trick.

Thanks for the help.

Greets,
Gunther

Doesn't anyone have a solution for this problem?

I think there's enough info here now, if not please say so.

Thanks,
Gunther

Hi,

I ran the query below in PhpMyAdmin, but i'm getting also no results. So i looked in the table search_index, but there i didn't found a search_index.word = 'test' or search_index.type = 'users'. I just found 'help' and 'node' as search_index types. Does somebody know why there are no 'users' types indexed?

SELECT DISTINCT(users.uid) AS uid,
   SUM(search_index.score * search_total.count) AS score,
   users.name AS users_name,
   users.mail AS users_mail
 FROM users users 
 LEFT JOIN search_index search_index ON users.uid = search_index.sid
 LEFT JOIN search_total search_total ON search_index.word = search_total.word
 WHERE (search_index.word = 'test') AND (search_index.type = 'users')
 GROUP BY search_index.sid, uid, users_name, users_mail
 HAVING COUNT(*) >= 1

Thanks,
Gunther

Hi,

When i manually add the user to the search_index table, my (views) search works:)
Now i just have to automate this proces. Making sur that whenever a useraccount is created or adjust, the search_index is updated.

Anyone ideas where i can do that? In which script/module?

I'll keep you updated, when i have more news.

Thanks,
Gunther

Hi guys,

I made it work! I tried the 'reindex'-module & 'profile-search'-module and then run my cron. I think the profile-search module did the trick!
So all who has the same problem as me, i suggest you try the modules i mentioned here above.

Greets,
Gunther

Hi Simon,

The second module i used, wasn't 'profile plus', but 'profile search', here's the link: http://drupal.org/project/profilesearch, run your cron afterwards.

Hopely it works now,

Greets,
Gunther