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
Comment #2
stephen_wtd commentedComment #3
stephen_wtd commentedOk 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.
Comment #4
stephen_wtd commentedComment #5
benjamin.merkley commentedI just did the same ^