Undefined index: distinct in views_plugin_query_default->build()

Yeah, I get this error w/ Views, too. The simple solution is to wrap the if condition in that line with a !empty().

Related issue: #882800: Move DISTINCT to a query option

Hmm, will mark this fixed with the attached patch so others who see this error can find the solution.

Hi

I'm getting the same issue when creating a view. Rszrama, please could you explain your solution a little? I'm a bit new to this.

Cheers

Jibb

Actually, as far as I know, the patch I wrote has been applied to Views itself. If you update to the most recent dev version, the problem should disappear. Otherwise you need to download that file I posted to your views directory and type patch -p0 < 882800.distinct_empty_check.patch. If you're on windows, see if Drupal's patch documentation has any tips: http://drupal.org/patch/apply

Hi Rszrama

Thanks very much! That did the trick. I did d/l the latest version of the module, which didn't sort it. That patch, however, did. I've never installed a patch on drupal before so thanks loads for also adding the instructions on that.

Much appreciated

Cheers

Jibb

I got this error when i used hook_views_query_alter(&$view, &$query). and am using latest views(version 7.x-3.10)

This issue exists in views 7.x-3.11.
May have been fixed in prior versions but it is back again.

Looks like this got hijacked as a "Views" issue. The patch in question is also agains Views.