When trying to create a simple flag count on a view, during adding flag relationship I can see this error behind the modal box

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'field list': SELECT DISTINCT comment_entity_statistics.comment_count AS comment_entity_statistics_comment_count, node_field_data.created AS node_field_data_created, node_field_data.nid AS nid, id AS id FROM {node_field_data} node_field_data INNER JOIN {comment_entity_statistics} comment_entity_statistics ON node_field_data.nid = comment_entity_statistics.entity_id AND comment_entity_statistics.entity_type = :views_join_condition_0 WHERE (( (node_field_data.status = :db_condition_placeholder_1) )) ORDER BY node_field_data_created DESC LIMIT 4 OFFSET 0; Array ( [:db_condition_placeholder_1] => 1 [:views_join_condition_0] => node )

I think this is some how removing the relationship even though views allows me to save the relationship.
Because when I add any field relating to flags "on content" I get this or similar for the type of field

The field Flagging: Flagging count uses a relationship that has been removed.

The flag relationship is still listed though?

Is this a bug or is it my incorrect config. (please excuse me if this is a config error)
Can anyone offer a suggestion?

Comments

Stephen_WTD created an issue. See original summary.

stephen_wtd’s picture

Title: Views relationship prolem » Views relationship problem
stephen_wtd’s picture

Ok figured this out it was a configuration error on my behalf.
When applying a relationship across multiple displays (all displays had been chosen) it appeared that the displays were receiving the setting (my mistake was I did not check all) - as soon as this was applied the removed message appeared. I did not realise this message was telling me that one of the displays was not getting the relationship - when I reapplied the relationship to that display the problem was solved.

stephen_wtd’s picture

Status: Active » Closed (works as designed)
benjamin.merkley’s picture

I just did the same ^