I am receiving the following Error when executing my view:

Fatal error: Call to undefined method stdClass::join() in C:\Documents and Settings\Administrator\Sites\acquia-drupal-site\acquia-drupal\sites\all\modules\views\includes\query.inc on line 911

This error is only thrown when i specify a relationship for the multigroup (delta sync) filter. When no relationship is specified, the view will execute without errors - but, of course, without the desired delta synchronization on the secondary table's multigroup.

Here is the basic setup:
-Node Type A: Invoice
-Node Type B: Payment -- Contains a multigroup with two fields: Amount (Integer) and Invoice (Nodereference -> refers back to Node Type A)

The basic premise is that a Payment may be received that applies to multiple Invoices, and I am trying to generate a view that displays all invoices, and payments received (if any). I have the Nodereferrer module installed to support reverse node references from Node Type B to Node Type A.

The view is generated by selecting all nodes of type Invoice, then adding a relationship (provided by Nodereferrer) to pull in the Payments. This works, except that the deltas are not synchronized on the multigroup fields in Payments (getting duplicates). When I try to enable the multigroup filter (and specify the relationship) I get the error above.

I'm not able to see the query preview due to the error, but I can post the query without the relationship specified for the multigroup filter if it would be helpful.

Comments

markus_petrux’s picture

Status: Active » Fixed

Oops! We're using the wrong alias to append the extra join conditions. It's been fixed in CVS (patch)

http://drupal.org/cvs?commit=282178

Thanks for reporting. :)

ISPTraderChris’s picture

Thank you Markus - applied the patch and this did resolve the error message.

Once I had resolved this issue, I did have a second where the filter was still producing duplicate values -- but I believe this is a separate issue so I will create a new issue. Would appreciate your feedback of course!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.