dotnetnukedotnetnuke-6dotnetnuke-settings

DotNetNuke 6 Child site can't have a site alias which already exists even though it doesn't

I have a DNN6 Website which has a child site. The child sites Site alias is currently of the form 111.111.111.111/child-site-name (obviously not its real name).

I want to change this to www.mainsite.com/child-site-name. So I go to the site settings like a normal person would do and try to add a new site alias. No dice. The error is that a site with that alias already exists, even though it doesn't.

Does anyone have any idea what is going on here?

My thought is that a previous child site used that alias, and upon deletion, did not free up the alias for later use. I have no idea where that information would be recorded though.

Thanks in advance everyone.

Solution

  • You can login as host and go to Host>SQL, then paste the following script:

    SELECT * FROM {databaseOwner}[{objectQualifier}PortalAlias]

    and run without ticking the "Run as script" option.

    This will show you all portal aliases you have in your database.

    Then if you find it there, you could eventually backup your database and try to delete it from there.