Can't delete friendly URL

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
6/27/2005 9:49:21 PM
Gravatar
Total Posts 148

Can't delete friendly URL

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;

6/28/2005 2:58:31 PM
Gravatar
Total Posts 18444

Re: Can't delete friendly URL

Dean,

Can you send me those patches as attachments? I'm having trouble applying them after pasting from the web page. TortoiseSVN says it doesn't have the Index line.

Thanks for not only pointing out the bugs but also sending the fixes!

Joe
You must sign in to post in the forums. This thread is closed to new posts.