SQL query select field show FLEXI_FIELD_INVALID_ELEMENTS

FLEXIcontent version 2.2.0 r1882

I create a select field,and use SQL query
SELECT id AS value, title AS text FROM #__eb_events
the setting like this f.desbear.com/VsQG
In backend form the select show event title as select text.
f.desbear.com/VsMV

But in front end the filed in the position show "FLEXI_FIELD_INVALID_ELEMENTS". :


How to solve this problem?

Thank you~!

Hello

so the SQL query that you added worked in backend item form, but in frontend item view it gives this error ?

can you try clearing the cache ?

-- i don't see why this would work in item form but gives this error in item/category view, it is strange


you may send me a PM with super admin login, site url, and field id, and item id

Regards

Hi ggddbk
Sorry I forget to modify the field in falang.
I build this site with falang,and the field is translate before.
So I need to copy the new setting to the field in falang. :oops:

Thank you~!!

Hello

i see,
the falang element also specifies the saving of parameters,

thanks for feedback