I installed the View Reference Module, created a type with a View reference field, chose to omit some views, and then went to create a node with a Views Reference. I got a load of warnings, and the actual View Reference field when adding the node was blank.

* user warning: Unknown column 'n.language' in 'where clause' query: SELECT view_id, position, name, title FROM viewreference WHERE (n.language ='nl' OR n.language ='' OR n.language IS NULL) AND ( (view_id != 6 AND view_id != 7 AND view_id != 36 AND view_id != 37 AND view_id != 38 AND view_id != 39 AND view_id != 40 AND view_id != 41 AND view_id != 42 AND view_id != 43 AND view_id != 44 AND view_id != 45 AND view_id != 46 AND view_id != 47 AND view_id != 48 AND view_id != 49 AND view_id != 50 AND view_id != 51 AND view_id != 52 AND view_id != 53 AND view_id != 54) AND title LIKE '%%' )ORDER BY view_id in ~/sites/all/modules/viewreference/viewreference.module on line 481.
* user warning: Unknown column 'n.language' in 'where clause' query: SELECT view_id, position, name, title FROM viewreference WHERE (n.language ='nl' OR n.language ='' OR n.language IS NULL) AND ( (view_id != 6 AND view_id != 7 AND view_id != 36 AND view_id != 37 AND view_id != 38 AND view_id != 39 AND view_id != 40 AND view_id != 41 AND view_id != 42 AND view_id != 43 AND view_id != 44 AND view_id != 45 AND view_id != 46 AND view_id != 47 AND view_id != 48 AND view_id != 49 AND view_id != 50 AND view_id != 51 AND view_id != 52 AND view_id != 53 AND view_id != 54) AND title LIKE '%%' )ORDER BY view_id in ~/sites/all/modules/viewreference/viewreference.module on line 481.

When I setup the View Reference field not to omit any Views, the list of warnings gets smaller. The Select list for the View Reference field now shows the option 'none' instead of being completely empty.

* user warning: Unknown column 'n.language' in 'where clause' query: SELECT view_id, position, name, title FROM viewreference WHERE (n.language ='nl' OR n.language ='' OR n.language IS NULL) AND ( ( 1 ) AND title LIKE '%%' )ORDER BY view_id in /home/arjan/workspace/drupal-62/sites/all/modules/viewreference/viewreference.module on line 481.
* user warning: Unknown column 'n.language' in 'where clause' query: SELECT view_id, position, name, title FROM viewreference WHERE (n.language ='nl' OR n.language ='' OR n.language IS NULL) AND ( ( 1 ) AND title LIKE '%%' )ORDER BY view_id in /home/arjan/workspace/drupal-62/sites/all/modules/viewreference/viewreference.module on line 481.

Some of my Views have a language filter setup, is that the problem?

Comments

danielb’s picture

danielb commented

Mate I've never heard of language filters so obviously this is something I haven't accounted for. Can you link me to more info about this? I don't understand how my query is being changed to include conditions about language!? Is there a module you have installed to rewrite queries and make them language specific? Or is this something about views 2 that I don't know about?

danielb’s picture

danielb commented
Status: Active » Postponed (maintainer needs more info)
ar-jan’s picture

ar-jan commented

Yes, Most likely i18n, which I use. There have been many issues between i18n and Views I think, indeed about db_rewrite_sql().

Maybe this has something to do with what primary table is being used? See this discussion on i18n and views.

danielb’s picture

danielb commented
Status: Postponed (maintainer needs more info) » Fixed

fixed in latest release.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.