+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / What database table contains the list of "multiple URL"s allowed for a single page?

What database table contains the list of "multiple URL"s allowed for a single page?

3 posts, 1 answered
  1. Corby
    Corby avatar
    48 posts
    Registered:
    19 Sep 2011
    09 Oct 2013
    Link to this post
    Basically I have 5000+ pages in Sitefinity.  When I try to create a multiple URL for a new landing page, for example ~/WelcomeHome, I'm getting a warning that some other page already has it.

    I need to know what table to look in to see what page is already associated with the ~/WelcomeHome URL so I can delete the multiple url value from that page and assign it to my new page.
  2. Jonathan
    Jonathan avatar
    119 posts
    Registered:
    19 Dec 2012
    09 Oct 2013 in reply to Corby
    Link to this post
    This should help:

    SELECT * FROM [dbo].[sf_url_data]
        WHERE  url = '~/WelcomeHome'

    The [dbo].[sf_url_data].[id2] column will relate to the [dbo].[sf_page_node].[id]

    SELECT * FROM [BostonReedDev].[dbo].[sf_page_node]
      WHERE ID = 'GUID from id2 col'


    Answered
  3. Corby
    Corby avatar
    48 posts
    Registered:
    19 Sep 2011
    09 Oct 2013 in reply to Jonathan
    Link to this post
    Excellent.  That is exactly what I needed.  I found it!  Thank you.
3 posts, 1 answered