PluginSift
PluginsThemesCompare
Directory
  • Plugins
  • Themes
  • Compare Plugins
Plugin Comparisons
  • SEO
  • Security
  • Ecommerce
  • Page Builders
  • Caching
  • Backup
  • Forms
  • Analytics
Resources
  • About
  • Contact
  • llms.txt

© 2026 PluginSift. Data sourced from WordPress.org. · [email protected]

  1. Home
  2. Plugins
  3. Sql
  4. Incorrect Datetime Bug Fix
Incorrect Datetime Bug Fix icon

Incorrect Datetime Bug Fix

This plugin was create to work around a problem caused by certain configurations in MySQL that lead to several odd symptoms including but not limited …

By Eddie Moya·Sql·Free
5(2 reviews)
·50 active installs·Updated 13 years ago
DownloadVisit HomepageCompare

As of April 2026, Incorrect Datetime Bug Fix is a WordPress sql plugin with 50 active installations and a 5/5 rating from 2 reviews. It has been downloaded 3.5K+ times in total. Requires WordPress false+ and PHP false+. Available on WordPress.org since 2011. Last updated 13 years ago — may have compatibility concerns. Top alternative: Search & Replace.

5/52 reviews
50active installs
3.5K+total downloads
15 yearssince 2011

Overview

This plugin was create to work around a problem caused by certain configurations in MySQL that lead to several odd symptoms including but not limited to:

  • Loss of ability to create new posts
  • Loss of ability to update posts
  • Errors regarding invalid timestamps
  • Admin interface reverts to lowest permissions ex:‘Publish’ button says ‘Submit Draft’.

In addition, this problem is often accompanied by an error like the following:

WordPress database error: [Incorrect datetime value: '0000-00-00 00:00:00' for column 'post_date_gmt' at row 1]
INSERT INTO 'mg_posts' ('post_author','post_date','post_date_gmt','post_content','post_content_filtered','post_title',
'post_excerpt','post_status','post_type','comment_status','ping_status','post_password','post_name','to_ping','pinged',
'post_modified','post_…
Read full description on WordPress.org

Ratings & Reviews

52 reviews
5 ★
2
4 ★
0
3 ★
0
2 ★
0
1 ★
0

Compatibility

WordPressfalse+ requiredTested up to 3.2.1
PHPfalse+ required

Top Alternatives to Incorrect Datetime Bug Fix

Search & Replace icon
Search & Replace
4.3100K+ installsUpdated 1 year ago
ViewCompare
Database Manager – WP Adminer icon
Database Manager – WP Adminer
520K+ installsUpdated 5 days ago
ViewCompare
Database Cleaner icon
Database Cleaner
510K+ installsUpdated 1 month ago
ViewCompare
SQL Buddy – Database Management Made Easy icon
SQL Buddy – Database Management Made…
56.0K+ installsUpdated 9 months ago
ViewCompare
SQL Executioner icon
SQL Executioner
4.62.0K+ installsUpdated 9 years ago
ViewCompare
View all sql plugins →

Frequently Asked Questions

Changelog

1.0

  • Initial plugin release
View full changelog on WordPress.org

Contributors

Eddie MoyaEddie Moya
Plugin Info
Version
1.1
Last Updated
Jan 7, 2013
WP Requires
false+
Tested Up To
3.2.1
PHP Requires
false+
Active Installs
50
Downloads
3.5K+
Added
Aug 23, 2011
Business
Free

Tags

sqlmysqlsql_modeno_zero_dateno_zero_in_date

Developer

E
Eddie Moya
4 plugins0.0M+ total installs
View all plugins →

Quick Compare

Incorrect Datetime Bug Fix vs Search & Replace→Incorrect Datetime Bug Fix vs Database Manager – WP Adminer→Incorrect Datetime Bug Fix vs Database Cleaner→

Plugin data sourced from WordPress.org. Analysis and metrics by PluginSift.