Case insensitive not working in Drupal 7's Combined Fields exposed filter

The exposed filter for combined fileds in Drupal 7 seems to work only when entering the exact casing of the search term or phrase used.  

Seems a patch is required for this:

  1. In your Views, Views Handler Filter Combine - /views/handlers/views_handler_filter_combine.inc, find and change the line below (- indicates the original code line, + replacement code of line)

    -$expression = "CONCAT_WS(' ', $expression)";
    +$expression = "CONVERT(CONCAT_WS(' ', $expression) USING utf8)";

Organic Groups exposed filter error "An illegal choice has been detected. Please contact the site administrator." and choice defaults to an item, not ANY

Case: Drupal 7 installed, with Organic Groups 7.x setup. In Views, added an exposed filter for a particular field (that will filter from a Content Type that is set up as both a Group and a Group content in OG).

Exposed filter setup: Single filter, NOT required, Select all, NOT limited to selected items

Issues:

Get reliable web hosting services

Recurring donation

Make Donation

  • Other: $

Donate now

Single donation

Make Donation

  • Other: $

Donate now