Question about if I am doing this right.

I made two CCK types. 1 called "Program" and one called "Series". I create a node family where Series is the parent of Child. Then I try to do two things:

1. I follow instructions on README.txt to reference the child node in my parent node's template.

I add this:

 $children = nodefamily_relation_load_by_type($nid); 

foreach ($children as $childnode) {
        print node_view($childnode);
      }


Nothing comes up. Non-existent. Nothing. I have entered a lot of data in both CCK types.

2. I try to do Views fusion. I create two views: 1 of Program fields and 1 of Series fields. I then do a fusion where I fuse view Series with view Programs.
I then get this error:


* user warning: Not unique table/alias: 'term_node' query: SELECT count(DISTINCT(node.nid)) FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_content_series node_data_field_host_name_0 ON node.vid = node_data_field_host_name_0.vid LEFT JOIN nodefamily nodefamily ON node.nid = nodefamily.parent_nid LEFT JOIN node v2node ON nodefamily.child_nid = v2node.nid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_content_program node_data_field_date_of_show ON node.vid = node_data_field_date_of_show.vid WHERE (term_node.tid = '6') AND (term_node.tid = '5') in /home/.grapes/cctv/cctv.dreamhosters.com/includes/database.mysql.inc on line 121.
* user warning: Not unique table/alias: 'term_node' query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, node_data_field_host_name_0.field_host_name_0_value AS node_data_field_host_name_0_field_host_name_0_value, node.nid AS node_nid, node_data_field_date_of_show.field_date_of_show_value AS node_data_field_date_of_show_field_date_of_show_value, node_data_field_date_of_show.field_date_of_show_timezone AS node_data_field_date_of_show_field_date_of_show_timezone, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_content_series node_data_field_host_name_0 ON node.vid = node_data_field_host_name_0.vid LEFT JOIN nodefamily nodefamily ON node.nid = nodefamily.parent_nid LEFT JOIN node v2node ON nodefamily.child_nid = v2node.nid LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN node_content_program node_data_field_date_of_show ON node.vid = node_data_field_date_of_show.vid WH in /home/.grapes/cctv/cctv.dreamhosters.com/includes/database.mysql.inc on line 121.

So am I just being stupid and not doing something right, or is there a problem??
Thanks,
Emily

Comments

fago’s picture

are you using the latest views and views_fusion modules?

Programs are your children or? then you should have done it right and we have to find a bug.
-> 1. make two simple views and fuse them,
2. if this works start including more stuff to your views. watch out what breaks the view.

fago’s picture

Status: Active » Fixed

please reopen if the problem persists...

Anonymous’s picture

Status: Fixed » Closed (fixed)