error after relationships with flag

Created on 7 February 2024, about 1 year ago

I got this error message showing on the bottom of the views preview first after I added the relationships with flags, after 30s the error message gone and the views preview displaying the result with duplicating results.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'count' in 'field list': SELECT COUNT(*) AS "expression" FROM (SELECT DISTINCT "node_field_data"."nid" AS "nid", count AS "count", id AS "id", 1 AS "expression" FROM "node_field_data" "node_field_data" LEFT JOIN "node__body" "node__body" ON node_field_data.nid = node__body.entity_id AND node__body.deleted = :views_join_condition_0 AND (node__body.langcode = node_field_data.langcode OR node__body.bundle = :views_join_condition_2) WHERE ("node_field_data"."status" = :db_condition_placeholder_0) AND ("node_field_data"."type" IN (:db_condition_placeholder_1)) AND ("node__body"."body_value" NOT LIKE :db_condition_placeholder_2 ESCAPE '\\')) "subquery"; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => artist [:db_condition_placeholder_2] => 0 [:views_join_condition_0] => 0 [:views_join_condition_2] => simplenews_issue )

after the problem with the preview, I added a views page and a path for the page. but when I try to access the page url, I got the blank screen with an error "The provided host name is not valid for this server." and I see this in log:

Symfony\Component\Routing\Exception\RouteNotFoundException: Route "view.duplicate_of_latest_list_1.page_1" does not exist. in Drupal\Core\Routing\RouteProvider->getRouteByName() (line 206 of /home/abc/public_html/web/core/lib/Drupal/Core/Routing/RouteProvider.php).

🐛 Bug report
Status

Active

Component

Flag core

Created by

🇬🇧United Kingdom freelylw

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024