WP 6.7.2 error checking boxes settings

[solanako]

When attempting to update certain settings in the WordPress admin panel (specifically checkboxes or image settings), WordPress tries to save a NULL value into the wp_options table. However, since the option_value column in the SQLite database has a NOT NULL constraint, this results in the following error:

No plugins installed.

WordPress database error: [

 

Queries made or created this session were

1. Raw query: UPDATE wp_options SET option_value = NULL WHERE option_name = 'thumbnail_crop'
2. Rewritten: UPDATE wp_options SET option_value = NULL WHERE option_name = 'thumbnail_crop'
3. With Placeholders: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
4. Prepare: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
5. Executing: array ( 0 => 'thumbnail_crop', )

Error occurred at line 1715 in Function execute_query.
Error message was: Error while executing query! Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: wp_options.option_value

#0 /disk19/home/solano/public_html/wp-content/db.php(2746): WP_SQLite_DB\PDOEngine->get_error_message() #1 /disk19/home/solano/public_html/wp-includes/class-wpdb.php(2716): WP_SQLite_DB\wpsqlitedb->query('...') #2 /disk19/home/solano/public_html/wp-includes/option.php(955): wpdb->update('...', Array, Array) #3 /disk19/home/solano/public_html/wp-admin/options.php(344): update_option('...', NULL) 

]
UPDATE wp_options SET option_value = NULL WHERE option_name = 'thumbnail_crop'

WordPress database error: [

 

Queries made or created this session were

1. Raw query: UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_size'
2. Rewritten: UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_size'
3. With Placeholders: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
4. Prepare: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
5. Executing: array ( 0 => 'image_default_size', )

Error occurred at line 1715 in Function execute_query.
Error message was: Error while executing query! Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: wp_options.option_value

#0 /disk19/home/solano/public_html/wp-content/db.php(2746): WP_SQLite_DB\PDOEngine->get_error_message() #1 /disk19/home/solano/public_html/wp-includes/class-wpdb.php(2716): WP_SQLite_DB\wpsqlitedb->query('...') #2 /disk19/home/solano/public_html/wp-includes/option.php(955): wpdb->update('...', Array, Array) #3 /disk19/home/solano/public_html/wp-admin/options.php(344): update_option('...', NULL) 

]
UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_size'

WordPress database error: [

 

Queries made or created this session were

1. Raw query: UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_align'
2. Rewritten: UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_align'
3. With Placeholders: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
4. Prepare: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
5. Executing: array ( 0 => 'image_default_align', )

Error occurred at line 1715 in Function execute_query.
Error message was: Error while executing query! Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: wp_options.option_value

#0 /disk19/home/solano/public_html/wp-content/db.php(2746): WP_SQLite_DB\PDOEngine->get_error_message() #1 /disk19/home/solano/public_html/wp-includes/class-wpdb.php(2716): WP_SQLite_DB\wpsqlitedb->query('...') #2 /disk19/home/solano/public_html/wp-includes/option.php(955): wpdb->update('...', Array, Array) #3 /disk19/home/solano/public_html/wp-admin/options.php(344): update_option('...', NULL) 

]
UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_align'

WordPress database error: [

 

Queries made or created this session were

1. Raw query: UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_link_type'
2. Rewritten: UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_link_type'
3. With Placeholders: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
4. Prepare: UPDATE wp_options SET option_value = NULL WHERE option_name = :param_0
5. Executing: array ( 0 => 'image_default_link_type', )

Error occurred at line 1715 in Function execute_query.
Error message was: Error while executing query! Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: wp_options.option_value

#0 /disk19/home/solano/public_html/wp-content/db.php(2746): WP_SQLite_DB\PDOEngine->get_error_message() #1 /disk19/home/solano/public_html/wp-includes/class-wpdb.php(2716): WP_SQLite_DB\wpsqlitedb->query('...') #2 /disk19/home/solano/public_html/wp-includes/option.php(955): wpdb->update('...', Array, Array) #3 /disk19/home/solano/public_html/wp-admin/options.php(344): update_option('...', NULL) 

]
UPDATE wp_options SET option_value = NULL WHERE option_name = 'image_default_link_type'

Warning: Cannot modify header information - headers already sent by (output started at /disk19/home/solano/public_html/wp-content/db.php:2657) in /disk19/home/solano/public_html/wp-includes/pluggable.php on line 1435

WordPress database error: SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: wp_options.option_value
The problematic query is typically:

UPDATE wp_options SET option_value = NULL WHERE option_name = 'some_option'

This behavior seems to stem from WordPress allowing NULL values, but the SQLite database schema used by the plugin enforces NOT NULL on the option_value column.