Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Hi Wolfgang,
i have a fusion of two views.
First shows me a Taxonomyterm, and a Image (CCK) its not filter by node type and has an Exposed Filter by Taxonomy Term
The Second shows me the Node Author, Location postal code, Location City, Email, Telefon and Location Country, its filterd by node type. This View has an Exposed Filter at Postal Code.
Each one only is working perfekt.
I fused them together child - parent relation. Now I got a huge MSQYL warning.
Do you have any idea why?
Warm regards from Cologne
Dirk
Comments
Comment #1
DesignWork CreditAttribution: DesignWork commentedHi Wolfgang,
I forgot a link if you want to see it live.... http://www.freelens.ws/dirksway/freelens_fotografen/fotojob3
Its just a test site.
Dirk
Comment #2
fagoIt looks like the location postal code filter views integration fails if it's used within a fused view.
What you can do about that?
- fix the location views integration or
- rearrange your view, so that the filter is part of the primary view
Comment #3
DesignWork CreditAttribution: DesignWork commentedHi Fargo,
I will try to fix it!! But i can not change my views, allready tryed it, does not work.
But thanks for the tip anyway!!
Dirk
Comment #4
DesignWork CreditAttribution: DesignWork commentedHi Wolfgang,
I have tryed it with an other CCK field. It does not work also!!
Could it be an other problem?
Dirk
Comment #5
fagono, I've just tested it again, it's working with CCK fields..
Are you sure you are running views fusion 1.2, views 1.6 and a compatible cck version?
Comment #6
DesignWork CreditAttribution: DesignWork commentedYes
I´m shure. I updated every thing, but i can not go close to a result. The only field i can filter in a child view ist author name.
I can give you admin acces to the site for reproducing the error or put you again a view for you to check.
Thanks in advance
Dirk
Comment #7
fagoindeed. There are a lot of problems with filters with views 1.6
you can try this patch for views: http://drupal.org/node/150094
this would already fix a lot of filters, like the CCK text filters.
Comment #8
DesignWork CreditAttribution: DesignWork commentedHi Fago,
i will test the patch and post the results. At the moment i resolved my problem by a custom modul. It´s a pitty because views should work, this would make drupal much nicer.
Dirk
PS. it´s nice, but it could be nicer
Comment #9
deadman CreditAttribution: deadman commentedI am experiencing a similar error using the current versions of views and views fusion (1.6 beta 5 & 1.2). when showing (or attempting to show) the last comment author of a node.
switching that particular filter off produces the view as expected but enabling it produces the "unknown column" error.
the patch posted by fago has no effect as far as I can see.
Comment #10
fagodeadman, this patch and issue is about filters - it doesn't change anything regarding to fields.
Anyway, I tried this field and I got even a sql error without views_fusion. I'll try again as soon as it got fixed.
Comment #11
bneel CreditAttribution: bneel commentedHi,
I have the same message error when I use cck date (regular or UNIX format).
I patched views files as fago recommended (see #7) and I use all up to date modules. I use node reference module (and it's patch) for relations. Views fusion works perfectly with text cck. But when I add date filter in the child view, I have 2 big msql errors in the fused view.
It there other patch to apply to the views module in order to filter views fusion by CCK date ?
Thx
Ben
Comment #12
suit4 CreditAttribution: suit4 commentedThis might be of interest: http://drupal.org/node/150094