Today I upgraded from 1.6.2 to 1.7.
All is fine, no upgrade problems.
However, I have a little issue with the statistics plugin which is still not working in 1.7 (did not work in 1.6.2 either).
So I am reporting it now:
The number of visitors per week is not showing at all. I am using Postgresql as the backend, so probably it has to do with that. I have messed with the code in the plugin myself, but to no avail.
The number of visitors this month and today are showing just fine.
The relevant lines of code (in serendipity_plugin_statistics.php) are:
Code: Select all
if (serendipity_db_bool($this->get_config('show_weekvisitors'))) {
$res = serendipity_db_query("SELECT sum(visits) AS weekvisitors FROM {$serendipity['dbPrefix']}visitors_count WHERE CONCAT(year,month,day) >= '".$lastmonday."' AND CONCAT(year,month,day) <= '".$nextsunday."'", true, 'assoc');
if (is_array($res) && isset($res['weekvisitors'])) {
$content .= '<div class="stat_weekhvisitors">' . sprintf($this->get_config('text_weekvisitors'), '<span class="stat_number">' . $res['weekvisitors'] . '</span>') . "</div>\n";
}
}
Regards
Jos