zen_db_perform and null values

[Dave224]

Function zen_db_perform apparently does not treat null values properly, at least with PHP 8. If inserting or updating a table containing a field with a null value, the function changes the value from null to '' when written to the table. Although the function has a case for NULL and null which would write null, casting a null value to a string will convert the value to '', so the case statements won't process it. This causes problems trying to write a datetime field, resulting in a fatal error. Looks like the same code in zc1.5.8.

Guess I need to use $db->Execute("INSERT....")???

Dave
zc157c, php 8.0.28

[lat9]

Whenever I've used zen_db_perform to insert/update 'NULL' values, I've supplied the (string)'NULL' as the associated value.

[swguy]

You can also just not touch the field unless the value is non-null.

See (for example) banner_manager.php line 156 and how date_added is updated on adds.