I have this error when I try to use Link Click Count fields on views.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'link_click_count.published' in 'on clause': SELECT node_field_data.title AS node_field_data_title, node_field_data.langcode AS node_field_data_langcode, node_field_data.type AS node_field_data_type, COUNT(link_click_count.url) AS link_click_count_url, MIN(node_field_data.nid) AS nid FROM {node_field_data} node_field_data LEFT JOIN {link_click_count} link_click_count ON node_field_data.nid = link_click_count.nid AND (link_click_count.published = :views_join_condition_0 AND node_field_data.numeric_field = :views_join_condition_1 AND link_click_count.published != node_field_data.boolean_field) GROUP BY node_field_data_title, node_field_data_langcode, node_field_data_type HAVING (( (COUNT(DISTINCT link_click_count.url) >= :link_click_count_url) )) ORDER BY link_click_count_url DESC LIMIT 11 OFFSET 0; Array ( [:link_click_count_url] => 1 [:views_join_condition_0] => 1 [:views_join_condition_1] => 1 )

Comments

eliasbrat created an issue. See original summary.

istankevych’s picture

Status: Active » Needs review
StatusFileSize
new710 bytes

It is no 'published' field in link_click_count_schema().
I removed this fields from extra join options.