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 »
Help them meet their 2009 target: http://www.freebsdfoundation.org/donate/
Donate to FreeBSD Foundation Read More »
All FreshPorts servers are now running PostgreSQL 8.4 (they were running 8.3). The upgrade process was rather straight forward. I documented it during the first upgrade (of my development server). I then used the same process for both the beta server and the production server. All went well. Merry Christmas.
Now on PostgreSQL 8.4 Read More »
I was annoyed earlier tonight to find that my configuration files for security/phpmyid were overwritten by an upgrade. I started to compose an email to the maintainer only to discover I am the maintainer.
security/phpmyid overwrites configuration files Read More »
From http://bsdtalk.blogspot.com/ Interview with Dan Langille. We talk about the 2010 BSDCan and PGCon conferences. More information at http://www.bsdcan.org/2010/ and http://www.pgcon.org/2010/. We also talk briefly about FreeBSD 8. File Info: 16Min, 8MB.
The RESTRICTED value on ports has been incorrectly recorded for some time. The code fix: $ cvs di port.pm Index: port.pm =================================================================== RCS file: /home/repositories/freshports-1/scripts/port.pm,v retrieving revision 1.54 diff -r1.54 port.pm 168c168 < $restricted_alt = FreshPorts::Utilities::NULLIfEmpty($dbh, $this->{restricted_alt}); — > $restricted_alt = FreshPorts::Utilities::NULLIfEmpty($dbh, $this->{restricted}); This is clearly a case of insufficient testing. I found this bug
RESTRICTED not correctly reported Read More »
The new virtual category docs was recently added. Interestingly enough, FreshPorts has a /docs/ directory, which directly conflics with this. As such, if you were to browe to http://www.freshports.org/docs/, you’d see this: Index of /docs Name Last modified Size Description Parent Directory – 404-for-virtual-pages.php 25-Oct-2007 12:57 8.2K Using 404 errors to serve up virtual pages
Virtual category: docs Read More »
This is news to me (thanks Pav): $ make -V VALID_CATEGORIES accessibility afterstep arabic archivers astro audio benchmarks biology cad chinese comms converters databases deskutils devel docs dns editors elisp emulators finance french ftp games geography german gnome gnustep graphics hamradio haskell hebrew hungarian ipv6 irc japanese java kde kld korean lang linux lisp mail
List of categories Read More »