Hey Alex, I'm glad you figured it out. If you could put together a pull request with the documentation changes that is probably the best way to get them updated.
Thanks! On Mon, May 5, 2014 at 6:08 AM, Alex <[email protected]> wrote: > After importing blog entries from wordpress I found that they are not > shown on /blog/archive/YYYY/MM/. Empty lists for any month of any year. > Though they are shown on /blog/ or /blog/archive/YYYY/ > > It appeared that Django 1.6 introduced time zone support in database > queries, so filter(publish_date__month=...) becomes > AND EXTRACT(MONTH FROM CONVERT_TZ(`blog_blogpost`.`publish_date`, 'UTC', > 'your_timezone')) = ...) > in MySQL queries: > https://docs.djangoproject.com/en/1.6/releases/1.6/#time-zone-aware-day-month-and-week-day-lookups > > This affects only day, month and week_day lookups. Year is not affected, > filter(publish_date__year=year) is still using direct timestamps and works > as expected: > AND `blog_blogpost`.`publish_date` BETWEEN '2014-01-01 00:00:00' and > '2014-12-31 23:59:59' > > The problem is that CONVERT_TZ in MySQL requires timezone data in > mysql.time_zone* tables. They are empty by default, so CONVERT_TZ always > returns NULL and lookup query returns an empty list. > You have to run > mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql > to import OS timezone information into these tables. See > http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html for further > details. > > Stephen, will you please add this information to the Installation guide or > to FAQs? > > -- > You received this message because you are subscribed to the Google Groups > "Mezzanine Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Mezzanine Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
