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

  • user warning: Unknown column 'location.postal_code' in 'where clause' query: SELECT count(node.nid) FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid AND term_data.vid IN ('9') LEFT JOIN users_roles users_roles ON node.uid = users_roles.uid LEFT JOIN content_type_bild node_data_field_bildchen2 ON node.vid = node_data_field_bildchen2.vid INNER JOIN users users ON node.uid = users.uid INNER JOIN nodefamily nodefamily_child ON node.nid = nodefamily_child.child_nid LEFT JOIN node v66node ON nodefamily_child.parent_nid = v66node.nid LEFT JOIN location v66location ON v66node.vid = v66location.eid LEFT JOIN users_roles v66users_roles ON v66node.uid = v66users_roles.uid LEFT JOIN content_type_kontakt_daten v66node_data_field_email ON v66node.vid = v66node_data_field_email.vid LEFT JOIN content_type_kontakt_daten v66node_data_field_telefon ON v66node.vid = v66node_data_field_telefon.vid WHERE (term_node.tid IS NOT NULL) AND (term_data.tid IS NOT NULL) AND (users_roles.rid IN ('3')) AND (UPPER(location.postal_code) LIKE UPPER('%20%')) AND (v66users_roles.rid IN ('3')) AND (v66node.type IN ('kontakt_daten')) in /kunden/163565_20459/webseiten/dirksway/includes/database.mysql.inc on line 172.
  • Comments

    DesignWork’s picture

    Hi 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

    fago’s picture

    Title: Exposed Filter not working with Fusion » location views filter fails if fused
    Priority: Critical » Normal

    It 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

    DesignWork’s picture

    Hi 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

    DesignWork’s picture

    Hi Wolfgang,

    I have tryed it with an other CCK field. It does not work also!!

    Could it be an other problem?

    Dirk

    fago’s picture

    no, 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?

    DesignWork’s picture

    Yes

    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

    fago’s picture

    Title: location views filter fails if fused » views fusion problems with filters

    indeed. 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.

    DesignWork’s picture

    Hi 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

    deadman’s picture

    I 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.

    fago’s picture

    deadman, 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.

    bneel’s picture

    Hi,
    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

    suit4’s picture

    This might be of interest: http://drupal.org/node/150094