I use the combo Search API + Facet API + Search API Database Search in this project of mine and it works fine with my custom entities.

But when I try to index Multifield as an entity, to convert its fields into facets, I get this error:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'multifield.id' in 'field list': SELECT multifield.id AS entity_id, :entity_type AS entity_type, NULL AS revision_id FROM {multifield} multifield WHERE (multifield.type IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => field_location_multifield [:entity_type] => multifield ) in EntityFieldQuery->execute() (line 1216 of DRUPAL_ROOT/includes/entity.inc).

Any help?

Comments

3magnus created an issue.

3magnus’s picture

3magnus commented

Clarifying a little more: I've tried this approach because Multifield's subfields don't show up on Select fields to index tab/page, not even on Add related fields.