SQL error Unknown table 'nodefamily_parent'

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

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

#1

behindthepage - January 25, 2008 - 02:46

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

Digital Deployment - January 31, 2008 - 20:56

you tried version 1.2 of this module?

#3

behindthepage - February 1, 2008 - 05:50

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

#4

folkertdv - June 12, 2008 - 14:44

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

#5

behindthepage - June 13, 2008 - 00:05

Thanks folkertdv,

It looks promising, I will check it out

#6

behindthepage - October 31, 2008 - 02:24

Patch submitted on #4 issue

 
 

Drupal is a registered trademark of Dries Buytaert.