I know D7 version is still a work in progress, so I'm going to test it. This module would be the wonderfull tool I was looking for, that's why I really hope it will be available.

First errors I would like to report are the following:

Notice: Undefined index: users in views_handler_field_field->access() (line 73 of (...)/sites/all/modules/views/modules/field/views_handler_field_field.inc).
Notice: Undefined index: users in views_handler_field_field->query() (line 127 of (...)/sites/all/modules/views/modules/field/views_handler_field_field.inc).
Notice: Undefined index: entity keys in views_handler_field_field->query() (line 139 of (...)/sites/all/modules/views/modules/field/views_handler_field_field.inc).

and

Debug:

'Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AS users_, users.created AS users_created, \'\' AS field_data_field_subscriber_amb\' at line 1'

in views_plugin_query_default->execute() (line 1362 of (...)/sites/all/modules/views/plugins/views_plugin_query_default.inc).

I used two select list: 1 for a city field from location module and 1 taxonomy field (which is displayed empty). My view lists users ans provides location and profile2 data. Please find attached the view export and the finder export. These are true use cases (the view is work in progress, but still all the fields I need are in there). I will make further tests to be able to provide the steps to reproduce these issues independently on a clean test website as soon as possible.

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Jerome F’s picture

Here's a simple test site (that you can use in acquia for example). I provided the sites folder and the database. You can log is as "admin" password "admin". If you prefer there's just the finder export file (EXPORT_simple_finder_content_taxo_select_list.txt).

Go to http://drupal_finder.localhost:8082/finder/1 to see:

Debug:

'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'field_data_field_taxo_voc1.field_taxo_voc1\' in \'where clause\''

in views_plugin_query_default->execute() (line 1362 of (...)/acquia-drupal/sites/all/modules/views/plugins/views_plugin_query_default.inc).

I'm quite confused by the numbers in the select list (see attached screenshot) what are these?
It's definitely not the "name" value The term name - though it should be.
It's not "fields" field_taxo_voc1_tid either
Nor the taxonomy terms ID "tids".

Jerome F’s picture

modules.zip:
sites/all/modules

drupal_finder.localhost.zip:
sites/drupal_finder.localhost

danielb’s picture

Status: Active » Closed (duplicate)

I think the crux of this issue is the old views relationships problem everyone has with profile views
#487980: The Views relationships issue
You've raised a few other things, but I can't really deal with those because it isn't going to work with the relationships problem.

Jerome F’s picture

thank you for yous answer @danielb

arvandtiv’s picture

I had to upgrade my view and ctools together and after the process my any views with a contextual filter set to user id from URL was giving me the same error. The fix was to remove the generated "relationship" by views and hit save again.