phpWebLog

There's a small bug in the F_drawresults function from search.inc.php that causes the archive section of the site to not display the results when a specific month is selected.

The bug occurs on lines 193 and 194 where the code reads:

$sql .= "WHERE (month(Repostamp) = '$month' ";
$sql .= "AND year(Repostamp) = '$year') ";

The problem is that the single quotes around $month and $year will cause them to be placed literally into the $sql string, instead of their values, wrecking the query. To fix this, just replace the single quotes with an escaped double-quote:

$sql .= "WHERE (month(Repostamp) = \"$month\" ";
$sql .= "AND year(Repostamp) = \"$year\") ";

-John

Well that doesn't work here. I'm running the latest unstable, and the archive doesn't work at all.
I just get a searchresult = nothing....