thomas66

Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)
  • Forum: Fixing WordPress
    In reply to: Options->Discussions unchecked Checkboxes issue?
    Thread Starter thomas66

    (@thomas66)

    6 years, 4 months ago

    No, I made the problem visible with that demonstration.

    Anyway I created an official bug report here.

    regards,
    Thomas

    Forum: Fixing WordPress
    In reply to: Options->Discussions unchecked Checkboxes issue?
    Thread Starter thomas66

    (@thomas66)

    6 years, 4 months ago

    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_optionsSET option_value= NULL WHERE option_name= ‘page_comments’ of update_option (translated)

    • This reply was modified 6 years, 4 months ago by thomas66.
    • This reply was modified 6 years, 4 months ago by thomas66.
    • This reply was modified 6 years, 4 months ago by thomas66.
    Forum: Fixing WordPress
    In reply to: Options->Discussions unchecked Checkboxes issue?
    Thread Starter thomas66

    (@thomas66)

    6 years, 4 months ago

    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
    In reply to: Error while trying to upload a picture.
    thomas66

    (@thomas66)

    6 years, 4 months ago

    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)