- Issue created by @freelylw
- Status changed to Postponed: needs info
7 months ago 12:38pm 19 October 2024
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).
Active
Flag core