[wp-trac] Re: [WordPress Trac] #4071: Searching for unpublished post has date of 1969

[WordPress Trac]

#4071: Searching for unpublished post has  date of 1969
------------------------------------+---------------------------------------
 Reporter:  robertaccettura         |        Owner:  anonymous
     Type:  defect                  |       Status:  new      
 Priority:  low                     |    Milestone:  2.2      
Component:  Administration          |      Version:  2.1.3    
 Severity:  minor                   |   Resolution:           
 Keywords:  date admin edit search  |  
------------------------------------+---------------------------------------
Comment (by SteveLewis):

 Cannot duplicate with wp 2.10+ using MySQL 5.0.22.

 == Investigation ==
 I inspected this ticket thinking it may be an easy one to offer a patch
 for, but I can neither verify it nor postulate conditions to possibly
 recreate.

 I see that ryan committed code for this in changeset [4491] (11/19/06
 07:24:55).  This code is part of the 2.1.3 tag (source:/tags/2.1.3/wp-
 admin/edit.php#L180).

 It occurred to me that the reporter may have a broken value for the
 post_modified datetime in the database.  Inspecting upgrade-schema.php, I
 can see that the table schema for that field has not changed historically
 and the field default is as-expected.

 Possible points for further investigation:
  * does MySQL have a bug/documented 'feature' in datetime handling in the
 version being used by the reporter?
  * was date_modified set incorrectly in the past as part of a now-resolved
 bug in post updating?
  * was date_modified set incorrectly as a result of a php / mysql lib /
 platform bug?

 We would need more information about a failing environment to determine
 what to do.

 Feel free to double check my work.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4071#comment:2>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software