Updating old code for new engine

Good morning,

I have been setting up a server at home as a workbench to learn PHP,
Postgres, and a few other tools. I recently installed an application
(PHPRecipeBook) that was written for Postgres 7.2.3. But I have 8.2.3
installed. When I try to access the recipe book, I get a few errors;
surprise, surprise. Is there any way to identify what adjustments I need
to make in the queries to compensate for the difference in target
versions? My dream option would be a form in which I enter the original
target and the new target and get back a list of all the syntax changes
I need to account for. I started to walk through the release notes, but
there are far too many changes spread too widely to make sense of.

The first level errors I get are:

SELECT count(*) FROM recipe_recipes WHERE recipe_name LIKE 'A%' OR
recipe_name LIKE 'a%' ORDER BY recipe_name
ERROR: column "recipe_recipes.recipe_name" must appear in the GROUP BY
clause or be used in an aggregate function

SELECT recipe_id,recipe_name FROM recipe_recipes WHERE recipe_name LIKE
'A%' OR recipe_name LIKE 'a%' ORDER BY recipe_name LIMIT OFFSET 0
ERROR: syntax error at or near "OFFSET" LINE 1: ...R recipe_name LIKE
'a%' ORDER BY recipe_name LIMIT OFFSET 0 ^

I fully expect there will be more after I get these corrected. My setup
is as follows:

Slackware 10.2
Apache 1.3.37
PHP 4.4.5
PostgreSQL 8.2.3

Thank you,

Bob McConnell
N2SPP