Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter felixq

    (@felixq)

    There is nothing wrong with the wordpress files when installed with the default setting of MySQL server. Already I tried it.
    But if you define the server to not allow invalid dates, as is normal in other SQL servers (Microsoft SQL Server, PostgreSQL, etc.), it does not work.
    The error is not limited to the installation, if you disable the option in the server to install it and then reboot with the option enabled, parts of the application do not work.

    I am the server administrator. I have other databases on it that would be a disaster if an invalid date is inserted by a programming error.

    You can try to install it on a server that in file ‘my.ini’ has the following lines so you can reproduce the error:
    innodb_strict_mode = 1
    sql_mode = “STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION, ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY”

    ———————————————
    Server SQL Modes
    https://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html

    NO_ZERO_DATE: In strict mode, do not permit ‘0000-00-00’ as a valid date.

    NO_ZERO_IN_DATE: In strict mode, do not accept dates where the year part is nonzero but the month or day part is 0 (for example, ‘0000-00-00’ is legal but ‘2010-00-01’ and ‘2010-01-00’ are not).
    ———————————————

    Thread Starter felixq

    (@felixq)

    Still not working.
    The file ‘schema.php’ definitions still has the date in that format.
    Would have also fix the following files:
    ajax-actions.php
    class-wp-media-list-table.php
    class-wp-ms-sites-list-table.php
    class-wp-posts-list-table.php
    meta-boxes.php
    template.php
    class-wp-xmlrpc-server.php
    general-template.php
    ms-blogs.php
    post.php
    wp-links-opml.php

    In the program should be asked if the date is null instead of ‘0000-00-00 00:00:00’.
    Does not work on servers that do not allow invalid date.

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