I am creating a view for field collection and trying to set the show type as "Display Suite fields". I would get:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_collection_item.nid' in 'field list'
After googling around, I found https://drupal.org/node/1441248
The fix for the issue above was to add
+ 'commerce_product' => 'product_id',
+ 'commerce_line_item' => 'line_item_id',
to views/views_plugin_ds_fields_view.inc
I added
+ 'field_collection_item' => 'item_id',
and it fixed my issue.
Display Suite 7.x-2.6+24-dev
Views 7.x-3.7+27-dev
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | ds-fix-field-collections-2272989-2.patch | 574 bytes | eigentor |
Comments
Comment #1
Anonymous (not verified) commentedThe same error for me!
Add
'field_collection_item' => 'item_id'
fix the issue.
Comment #2
eigentor commentedThis fixed the issue for me to. A fairly simple method.
To get this committed, I created a patch against the dev branch.
So I set the version of the module in the issue description to the dev branch as well.
Set to needs review.
Comment #4
aspilicious commentedComment #6
eigentor commentedSomehow the patch did not make it into to 7.2.8 release, the line "'field_collection_item' => 'item_id'," is still missing in views/views_plugin_ds_fields_view.inc
Setting back to active.
Comment #7
aspilicious commentedIt is still on the dev branch, 2.8 was only a security release.