Incorrect Datetime Bug Fix wordpress plugin resources analysis
| Download This Plugin | |
| Download Elegant Themes | |
| Name | Incorrect Datetime Bug Fix |
| Version | 1.1 |
| Author | Eddie Moya |
| Rating | 100 |
| Last updated | 2013-01-07 07:49:00 |
| Downloads |
1190
|
| Download Plugins Speed Test plugin for Wordpress | |
Home page
Delta: 0%
Post page
Delta: 0%
Home page PageSpeed score has been degraded by 0%, while Post page PageSpeed score has been degraded by 0%
Incorrect Datetime Bug Fix plugin added 13 bytes of resources to the Home page and 15 bytes of resources to the sample Post page.
Incorrect Datetime Bug Fix plugin added 0 new host(s) to the Home page and 0 new host(s) to the sample Post page.
Great! Incorrect Datetime Bug Fix plugin ads no tables to your Wordpress blog database.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_modified_gmt','post_parent','menu_order','guid') VALUES (’1′,’2011-08-23 03:32:43′,
’0000-00-00 00:00:00′,”,”,’Auto Draft’,”,’auto-draft’,'post’,'closed’,'open’,”,”,”,”,’2011-08-23 03:32:43′,’0000-00-00 00:00:00′,’0′,’0′,”)The inability to pass zero dates breaks the ability to actually create a new post, but it also seems to have the odd secondary effect of confusing the heck out of nonces (noces are a security feature), probably because they too rely on timestamps.
This plugin strips out the sql_modes listed below from @@SESSION, thereby eliminating the problem while only effecting database sessions WordPress starts and not the whole database.
