Hi everybody,
I have a problem since twice weeks. Every time I insert a new content in a page I see the content correctly.
If I visit that page later (when I say later I mean a random time: after two hours or the next day or after two days) I see the message:
----------------------------------------------------------
Server Error in '/' Application.
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /pagename.aspx

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
----------------------------------------------------------
I notice that there isn't the record related to that page in the table mp_friendlyurls (but only in mp_pages table), so I have to execute insert query to add that page to the db.

What does it happen?

Thanks
 

Hi Joe,
the version I'm using is 2.2.7.8, db Postgres, OS is windows server 2003 and I have no script that could do this (in fact I descovered that table only searching for a solution, I have never used it before!!!)

Hi Joe,
Yesterday I activated a pgLog so now I can see all the queries executed.
In the morning I tested to create a new page, add an html content, then change the module name and at the end change the name of the page. These are the actions my colleagues did yesterday when the error appeared.
At the moment everything seems ok in the site and in the db log file too.

So now I verify if the mp_pages table has unique pageguid on each row and that they correspond to pageguid in the mp_friendlyurls table..

wait for a news!!!
 

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!!!