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

sillygwailo’s picture

Assigned: Unassigned » sillygwailo
sillygwailo’s picture

Status: Active » Fixed

Committed to the 6.x and 7.x dev branches.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.