Download & Extend
Views Fusion » Issues

SQL error Unknown table 'nodefamily_parent'

Posted by behindthepage on January 18, 2008 at 10:52am
Project:Views Fusion
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

This a great module. Kudos and thanks for programing it.

I can get it to work fine if all the nodefamily relations of the fusions are the same type, i.e. either all "child - parent" or all "parent - child", but as soon as I add a fusion with the other type I get a SQL error like this

user warning: Unknown table 'nodefamily_parent' in on clause query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node_data_field_vendor_link.field_vendor_link_url AS node_data_field_vendor_link_field_vendor_link_url, ......

The Unknown table specified in the error is always the opposite of the nodefamily relation of the fusion which suggests to me that could be where the problem lays.

I hope that all makes sense.
Any ideas
many Thanks
Geoff

Login or register to post comments

Comments

#1

Posted by behindthepage on January 25, 2008 at 2:46am

Specs

Drupal 5.6
Views 5.x-1.6
Nodefamily 5.x-1.3
Views Fusion 5.x-1.x-dev

Lots of others but nothing that is known to cause problems (from the readme and other issues)

#2

Posted by Mac Clemmens on January 31, 2008 at 8:56pm

you tried version 1.2 of this module?

#3

Posted by behindthepage on February 1, 2008 at 5:50am

Yes. Tried Version 1.2 then 5.x-1.x-dev. Both had same problems.

#4

Posted by folkertdv on June 12, 2008 at 2:44pm

This might be caused by the same bug I stumbled upon when using Node Relativity. Check out http://drupal.org/node/267008.

#5

Posted by behindthepage on June 13, 2008 at 12:05am

Thanks folkertdv,

It looks promising, I will check it out

#6

Posted by behindthepage on October 31, 2008 at 2:24am

Patch submitted on #4 issue