Incorrect integer value when using extrafield " Boolean " in dolibarr ver 13.0.1

Using my Dolibarr Other native modules
1

Hi

OS : MX linux 19.2
Server : Apcche 2.4.38
PHP : 7.4
DB: MariaDB 5.5.5

I try to use extrafield to show user name in line of proposal .
And i read the example so i set a Boolean (one checkbox) .
And the other one is user name in lines .
So i have two questions .
When i create a extrafield with Boolean (one checkbox) , if i click it to select and then go to next page and to edit it to un-select it , that will show a error " Incorrect integer value: ‘’ for column dolibarrdb01.llx_propal_extrafields.multicoop at row 1 " .
If i select it again , it will not show any issues .
As my testing , it will not set the value to Null in DB . But it works for SALES ORDERS module .
Are there anyone knows how to fix it ?

2

Can you check if the settings are equal with your added checkbox in Sales order?

3

Hi

I have tried that in sales order , and it works fine with no error message .
Also i have the other dolibarr install in windows server , and works fine , too .