felixq
Forum Replies Created
-
Forum: Installing WordPress
In reply to: Lots of errors after setting up wp-config.phpThere 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.htmlNO_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).
———————————————Forum: Installing WordPress
In reply to: Lots of errors after setting up wp-config.phpStill 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.phpIn 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.