Strange problem with TVI

Created on 13 February 2018, almost 7 years ago
Updated 27 July 2023, over 1 year ago

Hi.

I am on drupal 8.4.X
I have a vocabulary of religions having 5 terms. All terms using TVI at vocabulary level to display term and associated nodes. But, only one term of these 5 is being dispalyed correctly.

This is the log message I can not understand!

-------------

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Categories Post[categories_post]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'taxonomy_term_field_data.tid4' in 'where clause': SELECT taxonomy_term_field_data.tid AS tid, node_field_data_taxonomy_term_field_data.nid AS node_field_data_taxonomy_term_field_data_nid FROM {taxonomy_term_field_data} taxonomy_term_field_data LEFT JOIN {node_field_data} node_field_data_taxonomy_term_field_data ON (SELECT node_field_dataINNER.nid AS nidINNER FROM {node_field_data} node_field_dataINNER LEFT JOIN {taxonomy_index} taxonomy_indexINNER ON "node_field_dataINNER".nid = "taxonomy_indexINNER".nid LEFT JOIN {taxonomy_term_field_data} taxonomy_term_field_data_node_field_dataINNER ON "taxonomy_indexINNER".tid = "taxonomy_term_field_data_node_field_dataINNER".tid WHERE ("taxonomy_term_field_data_node_field_dataINNER".tid = taxonomy_term_field_data.tid4 ) ORDER BY node_field_dataINNER.nid DESC LIMIT 1 OFFSET 0) = node_field_data_taxonomy_term_field_data.nid INNER JOIN {node__field_religion} node_field_data_taxonomy_term_field_data__node__field_religion ON node_field_data_taxonomy_term_field_data.nid = node_field_data_taxonomy_term_field_data__node__field_religion.entity_id AND node_field_data_taxonomy_term_field_data__node__field_religion.deleted = :views_join_condition_0 AND (node_field_data_taxonomy_term_field_data__node__field_religion.langcode = node_field_data_taxonomy_term_field_data.langcode OR node_field_data_taxonomy_term_field_data__node__field_religion.bundle = :views_join_condition_2) WHERE ((node_field_data_taxonomy_term_field_data__node__field_religion.field_religion_target_id = :node__field_religion_field_religion_target_id)) AND (taxonomy_term_field_data.vid IN (:db_condition_placeholder_3, :db_condition_placeholder_4)) LIMIT 30 OFFSET 0; Array ( [:node__field_religion_field_religion_target_id] => 1709 [:db_condition_placeholder_3] => main_deity [:db_condition_placeholder_4] => temple_classification [:views_join_condition_0] => 0 [:views_join_condition_2] => mt_post ) in Drupal\views\Plugin\views\query\Sql->execute() (line 1496 of /srv/xxx/core/modules/views/src/Plugin/views/query/Sql.php).

---------------

Any help is appreciated

Thanks

Raju

💬 Support request
Status

Closed: outdated

Version

1.0

Component

Code

Created by

🇮🇳India mandavya

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • 🇨🇦Canada mikeohara Moncton, NB

    Closing as outdated, and the 8.x-1.x branch will be considered minimally maintained and soon to be deprecated.

    If there is value for the 2.x branch, please re-open and provide feedback for improvement.

Production build 0.71.5 2024