Calculated field error logs
Posted: 2022-01-19 17:03
Hi,
i have a calculated field with this query:
The fields in the table "employees_de" are:
"date_of_birth" as Data Type: Date
"age" as Data Type: Integer
The calculation works.
But in query logs i get that errors:
Page: /ajax-update-calculated-fields.php
UPDATE `employees_de` SET `age`='' WHERE `ID`='1'
Incorrect integer value: '' for column `app`.`employees_de`.`age` at row 1
Can someone please help me what is the problem?
Thank you very much!
i have a calculated field with this query:
Code: Select all
select TIMESTAMPDIFF(year,date_of_birth,NOW()) as age from employees_de where id=%ID% "date_of_birth" as Data Type: Date
"age" as Data Type: Integer
The calculation works.
But in query logs i get that errors:
Page: /ajax-update-calculated-fields.php
UPDATE `employees_de` SET `age`='' WHERE `ID`='1'
Incorrect integer value: '' for column `app`.`employees_de`.`age` at row 1
Can someone please help me what is the problem?
Thank you very much!