Ben,
check that you have the fullquery "select_projects" in logger/www/admin/index-postgresql.xql file. If it does, there seems to be some problem with the parsing of xml files on your server.
I checked the checkout we're working on and the query exists in index-postgresql.xql there. This doesn't sound like a problem that would have anything to do with the version of OpenACS. If a query is not found, it's probably not found in a later version 😊
