Lots of errors after setting up wp-config.php

  • The install didn’t work, but it says it did. This is what I got after entering the config.php info:

    WordPress database error: [Invalid default value for ‘user_registered’]
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(64) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(60) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARACTER SET utf8

    More errors but all have a common denominator.

    The problem is the default value for dates (‘0000-00-00 00:00:00’).
    The MySQL server is configured to not allow invalid dates.
    This is my setup:
    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

    It can be fixed if it is removed the default (‘, user_registered datetime NOT NULL,’).

    I can not change the server settings because it affect other databases that are in it.
    Excuse my English, my native language is Spanish.

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

  • Delete that install and empty the database. Then download a fresh copy of WordPress and try and new install.

    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.

    There is nothing wrong with the WordPress core files. Have you spoken to your hosts about this?

    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).
    ———————————————

    WordPress won’t support MySQL strict mode but 3.9 will “fix” this by disabling NO_ZERO_DATE, ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, STRICT_ALL_TABLES, TRADITIONAL modes.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Lots of errors after setting up wp-config.php’ is closed to new replies.