Actions
Bug #6134
closedDefault Value NULL breaks Action Element
Status:
Closed
Priority:
Normal
Assignee:
Nicola Chiapolini
Target version:
-
Start date:
01.06.2018
Due date:
% Done:
0%
Estimated time:
Discuss:
Prio Planung:
Vote:
Description
I have an action defined as follows
INSERT INTO `FormElement` (`id`, `formId`, `feIdContainer`, `dynamicUpdate`, `enabled`, `name`, `label`, `mode`, `modeSql`, `class`, `type`, `subrecordOption`, `encode`, `checkType`, `checkPattern`, `onChange`, `ord`, `tabindex`, `size`, `maxLength`, `bsLabelColumns`, `bsInputColumns`, `bsNoteColumns`, `rowLabelInputNote`, `note`, `adminNote`, `tooltip`, `placeholder`, `value`, `sql1`, `parameter`, `parameterLanguageA`, `parameterLanguageB`, `parameterLanguageC`, `parameterLanguageD`, `clientJs`, `feGroup`, `deleted`, `modified`, `created`) VALUES
(483, 1008, 0, 'no', 'yes', 'laudator', '', 'show', '', 'action', 'afterSave', '', 'specialchar', 'auto', '', '', 80, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '', '', 'slaveId = 0\r\n\r\nsqlInsert = {{ INSERT INTO ceremony_laudators (`shortname`,`title`,`lastname`, `firstname`, `mail`) VALUES ( \'{{nodb_search_laudator:FE:allbut:s}}\', \'{{nodb_laudator_title:FE:allbut:s}}\', \'{{nodb_laudator_lastname:FE:allbut:s}}\',\'{{nodb_laudator_firstname:FE:allbut:s}}\',\'{{nodb_laudator_mail:FE:allbut:s}}\' ) }}\r\n', '', '', '', '', '', '', 'no', '2018-06-01 12:58:09', '2018-05-29 16:01:39');
Laudator is a column in a separate table and laudator is only updated correctly if its the default value is 0 and not NULL. (However NULL is necessary if the two tables should be linked with a FK-relation...)
Actions