Yes / No Element 500 Error Store Row Failed

[ontarget]

Joomla 4.4.8
F4.4.1
Hi
I have a hidden Yes / No Element (second_onward_journey) which is visible / hidden with js condition.
On form submission I get:
Store row failed: Incorrect integer value: '' for column `my_db`.`my_db_table.`second_onward_journey` at row 1 ; Please inform your web-site owner.

I have tried setting the default value to 0
Unpublishing the element allows the form to be submitted without issue.
I used a calc element to test the return on the yes/no value during submission:
return '{adtldldd_claim___second_onward_journey_raw}';
This value returns 0 throughout the process.

a var_dump($data);
OnBeforeStore on the form submission shows:
["adtldldd_claim___second_onward_journey"]=> string(0)
["adtldldd_claim___second_onward_journey_raw"]=> string(0)

Not sure why it's trying to set '' when not being used?

This is similar to the issue reported here:

SOLVED: Incorrect integer value on csv import

Joomla 4.2.9 Fabrik #4 Gamma 3 Cassiopeia vanilla J & F installation Hi, trying to import a csv file to a db table directly from the list and i get the following error for a db column. 500 Store row failed: Incorrect integer value: '' for column `xxxxx`.`fab_matches`.`player_b_id` at row 1...

fabrikar.com

FYI I also checked that i had no JS scripts that seemed to be causing the error last time see:

FixMe - Yesno element throw fatal error is acl protected

I use a yes/no element in a list used to store users's data together with the user plugin to have a register form and bypass the joomla's one. This yes/no elt contains the "blocked" equivalent to the juser field. It is acl protected to not appear in the form/detail view but only in the list view...

fabrikar.com

 

[ontarget]

As a work around the only thing I could do was to set the Yes/No Element as a radio button.
This allowed the column to be changed from INT to TEXT therefore allowing an empty value.