Error in field: LIEU_PTF (TextSelect with custom SQL query)

Bonjour
j'ai ce message d'erreur et j'avoue ne pas comprendre ce aue je dois chercher - du coup un coup de main serait le bienvenue

Error in field: LIEU_PTF while splitting element: SELECT value, value as text FROM #__flexicontent_fields_item_relations WHERE field_id='{field->id}' AND value != '' GROUP BY value properties needed: 2 properties found: 1

je me dis qu'il y a une relation avec l'image 2 mais... je sèche... je ne me souviens pas avoir vu ce message d'erreur avant...



pour info, l'affichage sur le site est correct...

Hello

seeing a picture in French is difficult

but i see that you have selected to use
"Existing Values + Custom Elements"

thus the code expects a list of elements , it does not expect an SQL query !

Fix:
you need to click the "list of elements" parameter and --remove-- sql query
and in there use elements instead of an SQL query !

Hello
thanks for your answer
I don't really understand as, as far I can see, I did not select SQL...
Which "Element Mode" am I supposed to select to have the list of previous location (this field is containing some town for instance) keeping the possibility to add one when creating the article...

Hello

The parameter elements fields
has (default value) an SQL query in it

when you changed parameter "Element Mode" to "Existing values + Custom Elements"
then you need to enter custom elements into elements fields or at least clear it

ah OK - I've got it
thanks a lot