Multiple displays of same entry for every taximage with View2

I'm sorry, I don't understand what you're asking here.

Apparently this is a problem with Views1 as well: #312655: adding taxonomy_image field in views - create multiple listing .

This modules doesn't ask Views to do anything; this module provides data when Views requests it.

I have the same problem...
http://img374.imageshack.us/img374/1861/64669731hy9.jpg

@chasz:
I think the error comes from this module since Views displays nothing wrong regardless of what terms I add without this module enabled.
My best bet is that the problem is somewhere in the function that sends data back to Views, but I'm not really sure.

Since my website depends on this module and I want to use it for a some other sites it's critical to get this one to work.
I'll try to look into the module and see if I find anything useful, hopefully we can find a solution...

Image: http://img89.imageshack.us/img89/3871/39318712mi6.jpg

suscribing.

Well, I guess we need a Views expert - and that is not me.

subscribing

From what i understand there is a patch correcting this for 5.x. here http://drupal.org/node/312655
Maybe someone that understand this better than me can help

That patch has been applied. But it is not for Views2. I have asked a Views expert to check all these issues.

sorry wrong post.

Still no solution?
This is a critical bug...

I understand the issue, but I cannot duplicate it.

Here they are.

OK

All of those only have one.

Ah, I added another term to one of the nodes and it did produce a duplicate. BTW, Views warns that this would happen.

Taxonomy terms. Note that using this can cause duplicate nodes to appear in views; you must add filters to reduce the result set.

I did not get such warning msg.

From the perspective of SQL, to get rid of the duplicate display without taximage, we need to say term_image.tid !=NULL or term_image.tid >0

But I have no idea on how to modify the SQL backing View.

That's not a message that shows up at the top of the page. It shows up in the definition area and is not highlighted.

I have no idea how to modify Views -- I can barely even use it.

As I said, I am not Views guru. Every time I've tried to work on this, I break Views.

I think I have an idea of whats going on here.

If you are trying to list taxonomy images by using a view:

1. You would have selected Taxonomy Image: Image as the View field

2. Probably set the filter: Taxonomy: Terms for your_term

You would expect that the result set would return distinct taxnomy images.

But seeing as the View is run against the nodes table (when it should probably run against the term tables), the view pulls a LISTING OF NODES with terms tagged with your_term.

Therefore, you would be displaying the taxonomy image for each node found and if you have a more than one node with the same taxonomy term, you get duplicates.

This is not the fault of the Views module (as the module does what is supposed to do) and I do not think the taxonomy image module is entirely at fault. Its just one of those weird cases where things don't work because it was not designed to do so.

What should probably happen is that the Views query be run against the taxonomy tables and pulls distinctly the image attach to each taxonomy term (if the image exists).

I do not know the solution but I know a few work arounds.

Work around Option 1

Create a nodequeue and for each taxonomy image that you want appear, add a node tagged with the respective term to the queue. Then create a view that lists the taxonomy images from nodes in this queue. As long as you don't add 2 nodes with the same term, you would not get duplicates.

Work around Option 2

Create a block with php input format setting and manually call taxonomy_image_display(..) for each image you want to display.

Admittedly, both workarounds suck, but if you really need this functionality (as I do), you can try it.

Its just one of those weird cases where things don't work because it was not designed to do so.

I don't even know that doing the query against the terms table will fix this. There is a many-to-one relationship involved between nodes and terms; and a one-to-many relationship between terms and nodes. This situation is going to always produce results that are not optimal.

If anyone knows a Views coding guru, perhaps they can make this situation better, but I doubt that it can be totally cured for all cases.

Marked #437204: I'm getting doubles in Views of each node that has an icon associated with it. as duplicate.

subscribing...

was wondering what's going on until i found this thread ....
subscribing.

BTW, if I were to use "Taxonomy terms. Note that using this can cause duplicate nodes to appear in views; you must add filters to reduce the result set." i'm still getting the duplicated. a step back .... how shall I use this if a node belongs to multiple terms in different vocabularies. I think this relevant because the symptom is the same..... view's issue rather?

as for #35, to reduce duplicate, one should use "Taxonomy: All terms" then should check "Limit terms by vocabulary" ..in which you can select which one to show. It's hidden there huhu ..... I found this from http://drupal.org/node/345571#comment-1188223

unless "Taxonomy Image" can provide similar function beside only " Taxonomy: Term image The image associated with a taxonomy term." I guess we are out of luck, as nothing Views can do about it.

In my case, all of the posts are categorized by one required vocabulary: post type, but only two of three terms have an icon. If I set Taxonomy: Vocabulary = Post type under filters, the duplicates disappear.

Best,
Andrey.

Taxonomy: Vocabulary under filters does the job. Learning more on views now ... TQ

not in my case at least, see attached screenshots :(

this is the query for the first one (no taxonomy image field)

SELECT DISTINCT(node.nid) AS nid,
   node.title AS node_title,
   node.type AS node_type,
   node.vid AS node_vid
 FROM drup_node node 
 LEFT JOIN drup_content_field_sistema node_data_field_sistema ON node.vid = node_data_field_sistema.vid
 LEFT JOIN drup_term_data term_data_node_data_field_sistema ON node_data_field_sistema.field_sistema_value = term_data_node_data_field_sistema.tid
 WHERE term_data_node_data_field_sistema.vid in ('3')

and for the second one (with taxonomy image field)

SELECT DISTINCT(node.nid) AS nid,
   node.title AS node_title,
   node.type AS node_type,
   node.vid AS node_vid,
   term_image.tid AS term_image_tid
 FROM drup_node node 
 LEFT JOIN drup_content_field_sistema node_data_field_sistema ON node.vid = node_data_field_sistema.vid
 LEFT JOIN drup_term_data term_data_node_data_field_sistema ON node_data_field_sistema.field_sistema_value = term_data_node_data_field_sistema.tid
 LEFT JOIN drup_term_node term_node ON node.vid = term_node.vid
 LEFT JOIN drup_term_image term_image ON term_node.tid = term_image.tid
 WHERE term_data_node_data_field_sistema.vid in ('3')

I believe this has something to do with not being able to group multiple values in the Taxonomy Image field options.

thanks @mr.andrey, that solved for me :D

cheers

As I understand it's not a bug, right?

So anyone know how to create field type "All terms images"? Or might be it already created?

I mean this field must be like "All terms", but as images.

I developed a patch for this module, which allows to display all term images for a given node as a single view field without generating duplicate rows. Tested with drupal-6.14 and taxonomy_image-6.x-1.6. See it here: http://drupal.org/node/471530#comment-2282102

I'm experiencing this same issue. The fix in #37 worked for me only after also turning on "Distinct"

I had the same problem however when I created view type term instead of node it fixed the duplicates - so check it out as it should work for you

When I use the fix in #37 I find that this generally messes up the view. I am having to use Taxonomy: Term ID and Taxonomy: Vocabulary filters. When Taxonomy: Vocabulary is set in a higher hierarchy as Taxonomy: Term ID I still get duplicates but when I reverse them some nodes are removed and the sort order seems disabled. Anyone else getting this?

Sorry did this ever get resolved anywhere? Ive had this problem now for about a year on my site and only now finally getting around to try and fix it. Im using Views 3 and Distinct doesnt have any effect on anything

I am using a patched dev version of tax image i found somewhere in here. 'tax all images' field available. I have 2 or 3 terms from the same vocab on nodes. My efforts are here-
http://onlinebanter.com/latest

If i cant fix it now i dont mind as im resined to a life of frustration with drupal due to my lack of php and other skills :(