If you are new to Habari (version 0.5.1) and are looking to add content to your sidebar you should be aware that the current version of the Monthly Archives plugin, available from Habari Extras, will not work as expected.

I visited the site of a new Habari user yesterday and noted that they were using this version, so I thought I should write a quick note here. The reason it won't work is that there is a change in the way Habari stores dates in version 0.6 and the plugin has been updated for this already. This means it won't organise the posts properly, if at all.

I haven't checked yet (I will do later on today when I have the chance) but there should be a previous version that will work. I'll post the details of that, or a fix, later.

Update: It looks like the previous version supports the older version of FormUI. I am sure it would be easy to switch over (changing Add to Append I think), but instead I have made a minor change to the SQL in version 0.91 which appears to be doing the trick for now.

I changed line 128 from:

$q = "SELECT YEAR( FROM_UNIXTIME(pubdate) ) AS year, MONTH( FROM_UNIXTIME(pubdate) ) AS month, COUNT( id ) AS cnt

to

$q = "SELECT YEAR( pubdate ) AS year, MONTH( pubdate ) AS month, COUNT( id ) AS cnt

If you are using Monthly Archives but only seeing December listed, and seeing URLs with {year} in them then this is one way to get it working until 0.6 comes out.