value not null constraint violation in options.php

[thomas66]

the line 277 in /wp-admin/options.php
"$value = null;"

should be changed to
"$value = 0;"

to prevent value not null constraint violation in db table wp_options

steps to reproduce:

1) set strict mode via MySQL config file:
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES

2) remove “STRICT_ALL_TABLES” from the “list of incompatible SQL modes” in wp_db.php, which is defined in $incompatible_modes

3) goto page options-discussions unselect a checkbox like "close_comments_for_old_posts"

step 3 will not work, only with the change above.

[SergeyBiryukov]

Hi there, welcome to WordPress Trac!

Thanks for the report, we're already tracking this issue in #45078.