When trying to delete a friendly URL, the following is added to mojoportal-log.txt:

2005-06-28 02:38:27,928 [1105198000] ERROR mojoPortal.Web.Global [(null)] - www.brettle.com
Npgsql.NpgsqlException:
function mp_friendlyurls_selectone("unknown") does not exist
Severity: ERROR
Code: 42883
Hint: No function matches the given name and argument types. You may need to add explicit type casts.

The problem is that 3mojoPortal.PostgreSQL.CreateStoredProcedures.sql define mp_friendlyurls_select_one() instead of mp_friendlyurls_selectone().  Patch is below.

Cheers,
--Dean

--- 3mojoPortal.PostgreSQL.CreateStoredProcedures.sql.orig      2005-06-28 01:54:05.886516064 -0500
+++ 3mojoPortal.PostgreSQL.CreateStoredProcedures.sql   2005-06-28 02:41:58.724778264 -0500
@@ -6736,7 +6765,7 @@
        ispattern bool
 );

-create or replace function mp_friendlyurls_select_one (
+create or replace function mp_friendlyurls_selectone (
        int --:urlid $1
 ) returns setof mp_friendlyurls_select_one_type
 as '
@@ -6753,7 +6782,7 @@
 where
         urlid = $1;'
 security definer language sql;
-grant execute on function mp_friendlyurls_select_one (
+grant execute on function mp_friendlyurls_selectone (
        int --:urlid $1
 ) to public;