empty checkbox 0 instead of NULL

[pgergely]

After the update all the empty checkboxes become 0 instead of NULL; which creates a huges issue for the extra pages where the logic looking for fields not null.

Is there any way to change it as it was before 5.9, in order not to refresh the whole databease manually after each update?


Thanks

[Panadu]

Hello, i have the same problem.

I upgraded from v 5.84 to 5.97 and my apps made strange things after this. After long search, i found out, there are database fields filled with "0", when a checkbox wa s not filled. Until v5.84 empty checkboxes where not filled, the database field was "NULL" .

Please is ther any possibility to change this behavior? I changed alle my checkboxes to "varchar" instead of "integer" but the behavior is the same.

Thank you for Help.
Regards Panadu

[baudwalker]

I always thought that a checkbox and radio button were binary, 0 or 1 ( checked or unchecked, off or on). Null would make no sense.

Barry

[Panadu]

Hello,

yeah, thats right, but if your Appgini software doesn't fill the database with "0" , if you have not checked a field, until version 5.84 and the field is "NULL". What should i do? I cannot update appgini because of this failure.

What i need is a hook or so, independed from appgini version, so i can upgrade to actual version.Is there anyone with an idea ?

Bye
Panadu

[jsetzer]

What about filling all records having NULL with 0 (zero) in TABLENAME_init() hook?