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
Comment #1
markus_petrux CreditAttribution: markus_petrux commentedOops! 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. :)
Comment #2
ISPTraderChris CreditAttribution: ISPTraderChris commentedThank 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!