Closed (fixed)
Project:
On This Day
Version:
6.x-1.1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
29 Apr 2010 at 04:02 UTC
Updated:
13 May 2010 at 18:30 UTC
The SQL query used to generate the list of items misses those posted on the stroke of midnight.
This might seem unusual but can be easily achieved by manually setting a date without a time as the create date.
The current query is:
SELECT nid, title FROM {node} WHERE status = 1 AND created > %d AND created < %d ORDER BY created ASC;"
The working query is:
SELECT nid, title FROM {node} WHERE status = 1 AND created >= %d AND created < %d ORDER BY created ASC;"
Comments
Comment #1
sillygwailoComment #2
sillygwailoCommitted to the 6.x and 7.x dev branches.