[wp-hackers] Draft timestamps and MySQL 5 strict

Ryan Boren ryan at boren.nu
Sun Jan 1 21:00:08 GMT 2006


On Sat, 2005-12-31 at 13:28 -0800, Ryan Boren wrote:
> On Thu, 2005-12-29 at 13:25 -0800, Ryan Boren wrote:
> > http://trac.wordpress.org/ticket/2175
> > 
> > I think this is because we use an empty timestamp for drafts as per
> > #1837.
> > 
> > http://trac.wordpress.org/ticket/1837
> > 
> > See also #2148:
> > 
> > http://trac.wordpress.org/ticket/2148
> > 
> > 
> > Thoughts on how to fix this up while preserving the behavior requested
> > in #1837?
> 
> I think this is due to strict mode enforcing NO_ZERO_DATE.
> 
> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html
> http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

I tried INSERT IGNORE and UPDATE IGNORE to get around this.  If you were
seeing bug #1837, please try out a nightly or svn and let me know if it
helps.

Ryan



More information about the wp-hackers mailing list