I have this error :
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 '!= .endpoints_r_index AND 1 = '1' AND .endpoints_entity_type = 'node') WHERE (( ' at line 1

and this warning when I save my views : (I don't now if they are linked)
Notice : Undefined index: relation dans views_handler_field_field->access() (ligne 78 dans /home/quickstart/websites/testinsert.org/sites/all/modules/views/modules/field/views_handler_field_field.inc).

I have 2 content types
1 - créateur with 2 fields : "prénom" and "nom" and 2 contents : Créateur 1 and Créateur 2
2 Véhicule ( = car) with 2 fields : " nom" and "immatriculation" and 2 contens : Véhicule 1 and Véhicule 2

and 1 relation type : "louer un vehicule" (rent a car)

and 1 relation : louer un véhicule:
Créateur 1 louer un vehicule Véhicule 1

The attached file is the picture of the views' page

Thank you

CommentFileSizeAuthor
recaap_location_1.PNG142.65 KBaltbzh

Comments

chx’s picture

chx commented
Status: Active » Postponed (maintainer needs more info)

Please export your view and attach it as a text file.

altbzh’s picture

altbzh commented

J haved removed Relation ...
In one week, I make a new try ...
Thankyou

mikran’s picture

mikran commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)
danillonunes’s picture

danillonunes commented
Assigned: Unassigned » danillonunes
Status: Closed (cannot reproduce) » Active

Got a similar error, after upgrading from rc3 to rc4. Also, this error comes togheter with a notice "Can only flip STRING and INTEGER values! in DrupalDefaultEntityController->load() (line 178 of .../includes/entity.inc)."

I'll try to investigate it further.

danillonunes’s picture

danillonunes commented

Sorry for the delay, I backtraced the bug and it seems that the problem is caused for a wrong value returned for a field value in a loaded entity.

My special case is:

- I have a relation type called r.
- I have a node type called t, with a relation_dummy_field field called d, pointing to some r.
- I have a custom code, which do a n = node_load(t_nid); and then iterate through n->field_d[LANGUAGE_NONE], calling a relation_load() for each value.
- On Relation rc3, each value is a integer, on rc4, each one is a empty array.
- When I call relation_load() with empty array, errors are dumped, things explode and a baby panda cry.

danillonunes’s picture

danillonunes commented
Assigned: danillonunes » Unassigned
Status: Active » Postponed (maintainer needs more info)

Oh, I found it! I had to apply this patch from #1361380: Fulfill $items in hook_field_load in order to use Relation Edit, and I forgot to reapply it after update. I don't know if it's the same case of the issue author, so I'm restoring it back to the original state.

naught101’s picture

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

Closing, after a month with no response. If this re-appears, and is not related to Relation Edit requiring #1361380: Fulfill $items in hook_field_load, feel free to re-open.