Posted by mdowsett on October 14, 2008 at 4:32pm
Jump to:
| Project: | Weekly Archive by Node Type |
| Version: | 6.x-2.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
some blog postings are not shown in weekly listing...what could cause this? I double-checked and they are blog posts, they are published and the dates are in that range?
Comments
#1
Same problem for me.
#2
Try the 6.x-2.0 version.
I believe the problem was using options in MySQL that made sense BUT didn't match the way PHP processes weeks. PHP assumes weeks start on Monday and the first week of the year is the week containing the first Thursday (a.k.a ISO8601 format). Meanwhile MySQL lets you assume
a: the week starts Sunday or Monday, and
b: lets the first week of the year be the first week with three days in it OR the first week with the day with a Sunday or Monday in it.
It's very easy to get a mismatch in there, and in fact I still need to keep an eye on it.
#3