Today I found a new issue with commit emails. They aren’t perfect. Neither is the code.
The problem arose with this email:

philip 2010-07-31 14:57:38 UTC

FreeBSD src repository

Modified files:
. […]

In a previous post, I wrote about a suspected LIMIT problem. It turns out that suspicion proved correct. The solution was to move to a nested query which limits the underlying data and then allows the outer query to grab all the associated fluff that surrounds it.
Here is the fix to the original […]

Bjoern A. Zeeb pointed out a problem today. On the following URL, there should be more commits per page. Only three are shown (at the time of writing).
http://www.freshports.org/search.php?stype=committer&method=exact&query=jb&num=100&orderby=category&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits
The page is showing 100 results per page. This should be 100 commits, but the result set is showing only 100 files. The SQL […]