NULL instead ORIGINAL on ENUM field when you edit several registries at once
Database management in a single PHP file
Brought to you by:
jakubvrana
Menu
▾
▴
#462 NULL instead ORIGINAL on ENUM field when you edit several registries at once
The situation is as follows:
- You select 2 or more registries in a table and click at EDIT button.
- Is presented a vertical form and all fields are presented with ORIGINAL, signaling that the value will be kept if you don't touch it.
- THE BUG => ENUM fields show NULL. It is expected ORIGINAL as other fields.
- Every time you had to remember to change all of them to ORIGINAL. If you forget, all ENUM values are WIPED OUT if you push the SAVE button.
- The workaround is: During table creation, you had to never allow NULLs at ENUM fields and leave the first option as empty string.
Bugged file is enum-option.php. When you remove this plugin, the error disapear.
Last edit: Marcelo 2016-02-01
I couldn't reproduce it and I think it was already fixed.
SOLVED!
In enum-option.php, just insert the following command right after the line containing "$options[""][-1] = lang('original');":
$selected = "-1";
When adminer is in multiple-fields-edit-mode (or isset($_GET["select"])), the $selected is set to null by default ($value parameter) and it's value wasn't updated when "original" option was generated.