Update error on checklist field, Field validation failure

[ITI]

Hello, we update Espo from version 5 till 9, everything works fine but we have one issue.
An checklist filed give the error in /data/log >>
[2026-03-03 07:28:02] WARNING: (400) Field validation failure; entityType: AdviesOpMaat, field: algemeneLedenvergadering, type: valid. :: PUT /AdviesOpMaat/698ee7bc2329ed17a

Enclosed what we see in the CRM.

It looks like to give me the error when I select more than one option.

Hopefully somebody can/will assist?

[victor]

ITI

Please send a screenshot of the settings for this field.

[ITI]

I ve upload it to the first post

[victor]

Your screenshot doesn't show all the settings for this field.

[ITI]

I ve upload new images, one with settings (that is complete, before i made 2 screenshots)

[victor]

In new versions of EspoCRM, the code is much stricter about validating the data you enter and its correctness for each type of field.


Try to create a backup of the EspoCRM files and the database (if the data of this field and it is important to you) and perform the following steps:
1. Delete the item marked in the screenshot. One of them has a "/".



2. Save the changes and make Rebuild.
3. Create a test record and select more than one item in it.
4. If everything goes well, then add the marked items again, but be sure to without "/".

Personally, I can't reproduce your error and I can select multiple values in the Checklist field type.

In general, ideally, the "Option name" of Options for such fields should be as simple as possible and then enter what you want in the "Label" of this Option.

[ITI]

I have done all above, including hard rebuild. Unfortunally no succes.
I have delete all the fields with stange chars, so I have only a-z.
On other entities we have also checklist fields, without any problem.

I will setup a test version en delete the fields and make new ones.

[yuri]

Could you provide this file? It may allow us to reproduce.

custom/Espo/Custom/Resources/metadata/entityDefs/AdviesOpMaat.json

[ITI]

When you asked me i look into that file found this

"algemeneLedenvergadering": {
"type": "checklist",
"storeArrayValues": true,
"options": [
"Datum ALV",
"Agenda inclusief besluitvorming ",
"Definitieve offertes ",
"Definitieve doorrekening",
"Warmtefonds traject"
],
"isCustom": true,
"default": []
},

see the spaces at the end, blank after besluitvorming and offertes.
When I change that, save the file, clear cache and rebuild, no errors.
But the field will not all saved when I fill the form, so see my update, after that eveything was fine.

Hopefully this give something to the solution?

Update:
"
when I delete all the field options in the gui with an space at the end, than clear cache and rebuild, the problem is solved. No errors anymore
I hope somebody can assist me with this and otherwise I hope that others may find this forum topic useful in the future.
"

[yuri]

It seems that we don't have string trimming in the field manager when checklist options are stored. We'll look into and fix if needed.

[ITI]

I think this originated in a (very) old version.
Because when I now test with and without spaces, everything works fine with newly created fields.
For now, I can fix it manually.

Thank you all so much for guiding me to the solution.

[yuri]

It will save me time. Thank you for letting know.