Closed (duplicate)
Project:
File Entity (fieldable files)
Version:
7.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Sep 2013 at 21:19 UTC
Updated:
27 Sep 2013 at 04:26 UTC
When I try to add a new user with a non administrator user, it tells me that fid column in field_data_group_group table doesn't exist. Is it an OG issue or is it a File Entity issue?
If file entity issue, it seems it's just a column name error from fid to entity_id but I couldn't find where to correct it.
Any help? Thank you.
Thierry
Here is the error message:
PDOException : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_group_group0.fid' in 'where clause': SELECT field_data_group_group0.entity_type AS entity_type, field_data_group_group0.entity_id AS entity_id, field_data_group_group0.revision_id AS revision_id, field_data_group_group0.bundle AS bundle FROM {field_data_group_group} field_data_group_group0 INNER JOIN {file_managed} file_managed ON file_managed.fid = field_data_group_group0.entity_id WHERE (field_data_group_group0.group_group_value = :db_condition_placeholder_0) AND (field_data_group_group0.deleted = :db_condition_placeholder_1) AND (file_managed.fid = :db_condition_placeholder_2) AND (field_data_group_group0.entity_type = :db_condition_placeholder_3) AND ( EXISTS (SELECT fm_access.fid AS fid FROM {file_managed} fm_access WHERE ( (fm_access.uri LIKE :db_condition_placeholder_4 ESCAPE '\\') OR (fm_access.uri LIKE :db_condition_placeholder_5 ESCAPE '\\') )AND (field_data_group_group0.fid = fm_access.fid) )) ...
Comments
Comment #1
devin carlson commentedIt sounds like this is a duplicate of #2073085: Issues with _file_entity_query_file_entity_access_alter(). It only expects inner joins. or #2067671: Ensure file query alteration is performed when using EntityFieldQuery.