After deleting an index, I get this on manually trying to index nodes. Cron also fails.
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=245&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND(((( (na.gid = '0') AND (na.realm = 'all') ))AND (na.grant_view >= '1') AN' at line 4: SELECT DISTINCT field_data_endpoints0.entity_type AS entity_type, field_data_endpoints0.entity_id AS entity_id, field_data_endpoints0.revision_id AS revision_id, field_data_endpoints0.bundle AS bundle FROM {field_data_endpoints} field_data_endpoints0 INNER JOIN {field_data_endpoints} field_data_endpoints1 ON field_data_endpoints1.entity_type = field_data_endpoints0.entity_type AND field_data_endpoints1.entity_id = field_data_endpoints0.entity_id LEFT OUTER JOIN {node_access} na ON na.nid = field_data_endpoints0.entity_id LEFT OUTER JOIN {node_access} na_2 ON na_2.nid = field_data_endpoints1.entity_id WHERE (field_data_endpoints0.endpoints_entity_type = :db_condition_placeholder_0) AND (field_data_endpoints1.endpoints_entity_id = :db_condition_placeholder_1) AND (field_data_endpoints1.delta = field_data_endpoints0.delta) AND (field_data_endpoints0.deleted = :db_condition_placeholder_2) AND (field_data_endpoints0.entity_type = :db_condition_placeholder_3) AND (field_data_endpoints0.bundle IN ()) AND(((( (na.gid = :db_condition_placeholder_4) AND (na.realm = :db_condition_placeholder_5) ))AND (na.grant_view >= :db_condition_placeholder_6) AND(( (na_2.gid = :db_condition_placeholder_7) AND (na_2.realm = :db_condition_placeholder_8) ))AND (na_2.grant_view >= :db_condition_placeholder_9) AND (field_data_endpoints1.entity_type = :db_condition_placeholder_10) )OR (field_data_endpoints1.entity_type <> :db_condition_placeholder_11) ) LIMIT 50 OFFSET 0; Array ( [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => 8 [:db_condition_placeholder_2] => 0 [:db_condition_placeholder_3] => relation [:db_condition_placeholder_4] => 0 [:db_condition_placeholder_5] => all [:db_condition_placeholder_6] => 1 [:db_condition_placeholder_7] => 0 [:db_condition_placeholder_8] => all [:db_condition_placeholder_9] => 1 [:db_condition_placeholder_10] => node [:db_condition_placeholder_11] => node ) in field_sql_storage_field_storage_query() (line 577 of /var/www/html/system/modules/field/modules/field_sql_storage/field_sql_storage.module).
Comments
Comment #1
nick_vhWithout more information or a way to reproduce your issue we can't support you.
Keep us posted!
Comment #2
nick_vh