Dear Joe,
Since yesterday I have this problem again!! There are in my portal 4 or 5 pages generating the error described in my first post, I visited those pages two days ago without problems.
Like the last time, if I see the records in mp_friendlyurls table, there aren't the records corresponding to the pages giving the error (but they are correctly written in mp_pages table).

Please can you tell me what are the pages or the functions in which there is a "delete form mp_frindlyurls" query?
I want to detect them.

I want also to know the exact meaning of the fields of mp_friendlyurls table, because now I have to execute an insert query to solve my problem and I'm not sure about some fields:

siteid = in my case is always 1
friendlyurl = mynamepage.aspx
realurl = ~/Default.aspx?pageid=id from mp_pages table
ispattern = in my case is always FALSE --> what is the meaning?
siteguid = it is always the same (taken from the other correct records)
itemguid = what have I put in?
pageguid = what have I put in?

I hope in your help!!

Thanks very much

1. Can you tell me the name of the pages in which there is a "delete from mp_friendlyurls" code?

2. The autogenerated itemguid is then used in another place?

Thanks

Dear Joe,
After a lot of tests, I think I have found a bug in the sql function: mp_friendlyurls_deletebypageid(character varying)

In this function in fact there is a delete query using a like:
delete from mp_friendlyurls where realurl like _pageid

and in my db log I notice that the like is a '%word%' like, so when I delete for example a page having id=10 the query is
delete from mp_friendlyurls where realurl like '%pageid=10%'

But this query deletes also all the records having pageid=100, 101, 102, etc.

I think the solution is to delete the second % so the query becomes
delete from mp_friendlyurls where realurl like '%pageid=10'

What do you think? Is this a bug?

I solved the problem directly in the stored procedure declaring a new variable --pageidnew-- and giving it this value:

_pageidnew=replace(_pageid, '%', '');
_pageidnew='%' || _pageidnew;

Bye!!!