WordPress.org

Ready to get started?Download WordPress

Plugin Directory

Incorrect Datetime Bug Fix

Fixes sql_mode values that cause error:Incorrect datetime value: '0000-00-00 00:00:00' for column 'post_date_gmt' at row 1

  1. Upload plugin-name.php to the /wp-content/plugins/ directory
  2. Activate the plugin through the 'Plugins' menu in WordPress

Will this fix sql_mode during installation?

No, plugins are not loaded during installation. For alternative solutions see "Other manifestations, alternative solutions" on the plugin home page

Will this effect other applications that might run on the same database, and depend on these sql_mode settings?

No, it uses @@SESSION.sql_mode to change the settings for each WordPress session individually.

How do I undo what this plugin does?

Just turn off the plugin - because it uses @@SESSION, the changes wont persist.

If you've made other modifications explained in this plugin's documentation, you will have to run similar SQL commands to apply the old settings.

Compatible up to: 3.2.1
Last Updated: 2013-1-7
Downloads: 1,124

Ratings

5 stars
5 out of 5 stars

Support

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1
100,2,2
100,1,1
100,1,1