Hello,
I have created a block display view that shows a collection of nodes filtered by a taxonomy term.
All goes fine in the update preview. The problem comes with the display on a page, it shows nothing and gives me through the views performance statistics/debug messages via the Devel module the following messages:

Missing join: taxonomy_term_data taxonomy_term_data
Exception in noticias_presentaciones[noticias_presentaciones]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_2.tid' in 'on clause'

When I remove the taxonomy image field from the views fields, the view is displayed correctly and I get the following message:

Missing join: taxonomy_term_data taxonomy_term_data

Can you give me any help on what can I do to fix it or what i'm doing wrong?
Thanks!

CommentFileSizeAuthor
#3 view-export.txt14.69 KBdrupalerocant

Comments

drupalerocant’s picture

drupalerocant commented

Hi!
I don't know if I was doing something wrong or is a views problem, or something else, but I found out a solution to my problem.
As i said i made a block display view that shows a collection of nodes filtered by a taxonomy term and i couldn't make it work it out till i changed my approach.
My actual view is a taxonomy term view with a relationship Taxonomy term: Content using My Vocabulary.
Now it displays everything as i wanted to be: the content with the related taxonomy image.
I hope it helps somebody!

dawehner’s picture

dawehner
Primary language German
commented

It would be cool if you could attach an export of the view which was broken. I guess that might be a bug of views, that should/could be fixed, so less people have the same issue.

drupalerocant’s picture

drupalerocant commented
StatusFileSize
new view-export.txt14.69 KB

Hello!
As you requested, here i attached the broken view. I hope it helps to fix the bug. I also copy down here the complete Devel module message:

Missing join: taxonomy_term_data taxonomy_term_data

Exception in recursos_presentaciones[recursos_presentaciones]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_2.tid' in 'on clause'

FAAREIA’s picture

FAAREIA commented

Hi people, i found the some big bug.
I add a custom text field to a taxonomy vocabulary.
Then i go to my content view, and add a relationship to a taxonomy term, so then i add the custom text field of my term. In preview, it shows alright. On the web page, it just dissapears. With or without admin login, it's not rendered.
BUT.......if i "Disable SQL rewriting", the view is shown.........really strange.

thanks for all

FAAREIA’s picture

FAAREIA commented
Title: Exception:SQLSTATE[42S22] Cannot display taxonomy image » Exception:SQLSTATE[42S22] Cannot display taxonomy relationship on content view
kars-t’s picture

kars-t commented
Status: Active » Fixed

Dear fellow Drupal enthusiasts,

this issue is now lasting for a very long time in the issue queue and was unfortunately never solved. As Drupal is a open source project everyone is helping on voluntary basis. So that this is was not solved is nothing personal and means no harm. But perhaps no one had time to deal with this issue, maybe it is too complex or did not describe the problem comprehensibly.

But this issue is not the only one. There are thousands of issues on Drupal.org that have never been worked on or could not be processed. This means that we are building a wave that is unmanageable and just a problem for the Drupal project as a whole. Please help us keep the issue queue smaller and more manageable.

Please read again, "Making an issue report" and see if you can improve the issue. Test the problem with the current Core and modules. Maybe the problem doesn't exist anymore, is a duplicate or has even been solved within this issue but never closed.

Help can also be found for it on IRC and in the user groups.

In order to remove this issue, I have set this issue to "fixed"

If there is new information, please re-open the issue.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.