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

Rafael Cansinos’s picture

Rafael Cansinos
Primary language Spanish
Location Alcobendas (Madrid)
commented
Version: 5.x-1.2 » 6.x-1.x-dev

Same problem for me.

Prometheus6’s picture

Prometheus6 commented
Version: 6.x-1.x-dev » 6.x-2.0
Status: Active » Needs review

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.

Prometheus6’s picture

Prometheus6 commented
Status: Needs review » Closed (fixed)