Hello,

I've got an error HTTP 500 (Internal Server Error) when trying to access relation edit page.

I found this error in the drupal log , the trouble seems to come from the entity module.

REFERENT :
.../admin/config/development/generate/relation

MESSAGE :
PDOException : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_type' in 'where clause': SELECT comment.cid AS entity_id, :entity_type AS entity_type, NULL AS revision_id FROM {comment} comment WHERE (node_type IN (:db_condition_placeholder_0, :db_condition_placeholder_1)) LIMIT 20 OFFSET 0; Array ( [:db_condition_placeholder_0] => comment_node_author [:db_condition_placeholder_1] => comment_node_event [:entity_type] => comment ) dans EntityFieldQuery->execute() (ligne 1136 dans /home/www/sites/photographie.com/www/includes/entity.inc).

I'm using the last version of the entity module, 7.x-1.0-rc1 and relation 7.x-1.0-beta3.

Any idea to solve this ?
THanks

Comments

samw’s picture

Apologies for the hijacking and commenting. I see that this is probably a duplicate of #1345320: AJAX error in autocomplete for taxonomy relations and therefore #1054162: Taxonomy bundles not supported by EntityFieldQuery (followup). Sorry!

I believe I'm having a similar problem but when using the Relation Add block. I'm using dev versions of both Relation and ctools.

It's present when I try to create a relation which specifies that the source bundle is a specific taxonomy vocabulary - in the error message below, from the vocabulary 'club', rather than when it's set as "All taxonomy term bundles".

The error below comes from the javascript popup message:

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: http://localhost/relation_add/autocomplete/reciprocal_club/target
StatusText: Service unavailable (with message)
ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vocabulary_machine_name' in 'where clause': SELECT taxonomy_term_data.tid AS entity_id, :entity_type AS entity_type, NULL AS revision_id
FROM
{taxonomy_term_data} taxonomy_term_data
WHERE (taxonomy_term_data.name LIKE :db_condition_placeholder_0 ESCAPE '\\') AND (vocabulary_machine_name IN (:db_condition_placeholder_1))
LIMIT 12 OFFSET 0; Array
(
[:db_condition_placeholder_0] => %Lym%
[:db_condition_placeholder_1] => club
[:entity_type] => taxonomy_term
)
in EntityFieldQuery->execute() (line 1136 of /includes/entity.inc).

Is this a known problem and if so, is there a workaround other than just using all taxonomy vocabularies as bundles?

Thanks,
Sam

mikran’s picture

can you re-test this now with the fixed EFQ?

mikran’s picture

Status: Active » Postponed (maintainer needs more info)
naught101’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Closing, since no new information has been added.