Title: thomas66's Replies | WordPress.org

---

# thomas66

  [  ](https://wordpress.org/support/users/thomas66/)

 *   [Profile](https://wordpress.org/support/users/thomas66/)
 *   [Topics Started](https://wordpress.org/support/users/thomas66/topics/)
 *   [Replies Created](https://wordpress.org/support/users/thomas66/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/thomas66/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/thomas66/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/thomas66/engagements/)
 *   [Favorites](https://wordpress.org/support/users/thomas66/favorites/)

 Search replies:

## Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Options->Discussions unchecked Checkboxes issue?](https://wordpress.org/support/topic/options-discussions-unchecked-checkboxes-issue/)
 *  Thread Starter [thomas66](https://wordpress.org/support/users/thomas66/)
 * (@thomas66)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/options-discussions-unchecked-checkboxes-issue/#post-12294540)
 * No, I made the problem visible with that demonstration.
 * Anyway I created an official [bug report](https://core.trac.wordpress.org/ticket/49135)
   here.
 * regards,
    Thomas
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Options->Discussions unchecked Checkboxes issue?](https://wordpress.org/support/topic/options-discussions-unchecked-checkboxes-issue/)
 *  Thread Starter [thomas66](https://wordpress.org/support/users/thomas66/)
 * (@thomas66)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/options-discussions-unchecked-checkboxes-issue/#post-12294230)
 * I was able to reproduce the bug with the following steps with MySQL:
 * 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
 * I don’t know why there was a decision to put MySQL mode “STRICT_ALL_TABLES” to
   the incompatibility list. I don’t think that was a good idea. It’s like allowing
   unclean code.
 * Anyway, if you do this, you can no longer uncheck checkboxes at the options page
   and you’ll get:
 * WordPress-Database-Error Column ‘option_value’ cannot be null für query UPDATE`
   wp_options`SET `option_value`= NULL WHERE `option_name`= ‘page_comments’ of update_option(
   translated)
    -  This reply was modified 6 years, 6 months ago by [thomas66](https://wordpress.org/support/users/thomas66/).
    -  This reply was modified 6 years, 6 months ago by [thomas66](https://wordpress.org/support/users/thomas66/).
    -  This reply was modified 6 years, 6 months ago by [thomas66](https://wordpress.org/support/users/thomas66/).
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Options->Discussions unchecked Checkboxes issue?](https://wordpress.org/support/topic/options-discussions-unchecked-checkboxes-issue/)
 *  Thread Starter [thomas66](https://wordpress.org/support/users/thomas66/)
 * (@thomas66)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/options-discussions-unchecked-checkboxes-issue/#post-12293276)
 * Found the reason. I’m using the SQLITE plugin “sqlite-integration” and a SQLITE
   database behind. I made a test installation with MySQL and the issue disappears
   in it’s visibility but only because MySQL slightly ignores the issue with a warning.
   ”
   Warning: #1048 field ‘option_value’ must not be NULL” (translated)
 * So my understanding is, that switching the database revealed this unclean coding
   of the options page. I’m afraid nobody will care but I will try your report suggestion.
 * Thanks
    Thomas
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Error while trying to upload a picture.](https://wordpress.org/support/topic/error-while-trying-to-upload-a-picture/)
 *  [thomas66](https://wordpress.org/support/users/thomas66/)
 * (@thomas66)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/error-while-trying-to-upload-a-picture/#post-12292448)
 * Moving your site to another domain may require some changes to your config.
 * Try this at the beginning of wp-config.php, this makes your page independ from
   your host. Use http if have no ssl.
 *     ```
       /* override the admin settings */
       define('WP_SITEURL', 'https://' . $_SERVER['HTTP_HOST']);
       define('WP_HOME', 'https://' . $_SERVER['HTTP_HOST']);
       ```
   
 * and you may require the plugin “make-paths-relative”
 * regards,
    Thomas

Viewing 4 replies - 1 through 4 (of 4 total)