The submitted Page URL is not available

aderson@dnnhero.com | 1-855-DNN-HERO

Forum

Search Home

Home

Premium

Administration

The submitted Page URL is not available

6/22/2017 5:25 AM

Stephen

Joined: 7/29/2012

Posts: 403

Re: The submitted Page URL is not available

1Hi Aderson,

Thank you for your reply.

I did another check on entries within the TabsUrl table for a given tab id. Pairs of redirects exist for the previously mentioned pages, for example:

tabid seqnum url httpstatus

191 0 /Blog/TheHike/Week1 200

191 1 /Blog/TheHike/Week7 301

i.e. '/Blog/TheHike/Week7' redirects to '/Blog/TheHike/Week1'.

So I think I can just delete the unwanted records, but will rename them just in case.

I also now remember creating week 7 pages as a continuation of another sequence, then changing them to start a new sequence, so that explains how they got there :-)

Best Regards,

Steve

6/23/2017 7:40 AM

Stephen

Joined: 7/29/2012

Posts: 403

Re: The submitted Page URL is not available

Hi Aderson,

Just to conclude, I renamed all the 'orphaned' urls which preventing the url for new pages being set with a simple piece of SQL for each offending entry:

update [thinkingdb].[dbo].[TabUrls]
set url = '/Blog/TheHike/Week7x'
where url = '/Blog/TheHike/Week7'

I can't imagine that I'd need to go back, or that this would do any harm, but I can if need be.

I've now been able to rename my pages correctly and the rest of the site is still working :-)

Thank your for your help once again.

Best Regards,

Steve