phpBB uses a postgres unsupported query format. ORDER BY columns must be in the select. I used attached patch to fix the issue for my site.