Ticket #2216 (closed patch: fixed)

Opened 11 months ago

Last modified 4 months ago

Archive page doesn't show blogs on last day of month

Reported by: lancer Owned by: aoneil
Priority: medium Milestone:
Component: Modules - blog Version:
Severity: medium effort / impact Keywords: blog,archive
Cc: Hours:

Description

If I browse the archive for a given month, blogs that took place on e.g. 2008-01-31 don't show up.

This is due to the fact that the query is done for dates between 2008-01-01 and 2008-01-31. This should be 2008-01-01 00:00:00 and 2008-01-31 23:59:59

Attachments

BlogHolder.patch (0.7 kB) - added by lancer 11 months ago.

Change History

Changed 11 months ago by lancer

Changed 4 months ago by aoneil

  • status changed from new to closed
  • resolution set to fixed

Changed the BlogHolder? to use SQL MONTH() and YEAR() functions, and added unit tests in r62289.

Note: See TracTickets for help on using tickets.