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: . access mentors Log: SVN rev 210685 on 2010-07-31 14:57:38Z by philip Take cbzimmer’s commit bit into safekeeping per his request. Approved by: core […]
Commit email problems Read More »
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 code:
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 query has
Search doesn’t display enough commits per page Read More »