Project

General

Profile

Actions

Bug #6134

closed

Default Value NULL breaks Action Element

Added by Nicola Chiapolini almost 6 years ago. Updated over 5 years ago.

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

Also available in: Atom PDF