Edit problem with multi choices

ASHKAR · Post by **ASHKAR** » Wed Feb 07, 2024 4:41 am

Hello ,

when I choose from ( Edit tag ) checkbox or select (Multiple) and generate the script , every thing work well with Add in multiple choices

But in Edit, multi choices items disappear and the field became blank , and if I click save button the cell in db became blank and all multi choices gone

note: I can't make it only read , becuase the user may change it later

any help ?

arbei · Post by **arbei** » Wed Feb 07, 2024 9:29 am

Your information is insufficient. You better post:

Edit Tag settings
Lookup table settings (if any)

Also make sure the data type of the field is varchar and the field size is large enough to store the multi-selected options (storead as comma separated values).

Cat · Post by **Cat** » Thu Feb 08, 2024 1:04 am

Hello everyone

I can reproduce the problem and it is true that the fields are deleted when editing

ASHKAR · Post by **ASHKAR** » Thu Feb 08, 2024 6:49 am

now I created another project to test that problem with the same edit tag ( select, mutiple, use lookup table, use modal dialog for look ) , in mysql thay are varchar(2255)

new one work ok , old one delete valuse when edit .. !!

ASHKAR · Post by **ASHKAR** » Thu Feb 08, 2024 6:52 am

Cat,
Maybe the problem with meduim projects !!
small projects works fine as I test

arbei · Post by **arbei** » Thu Feb 08, 2024 9:50 am

If "meduim projects" meant you have many fields in the table, and it occurs during Grid-Add/Edit (with many inputs in the form), you better check your max_input_vars in php.ini.