Hi,

We have recently changed over from a development site to a live site and in process changed the domain name. I had added the live domain name as an Alias before the change over. The previous development name no longer points to the same hosted space (it's a shared hosting environment, so multiple sites share a single IP address).

My issue is that one of the main modules on the site uses the site alias marked as "primary" to determine the URL for a link back for social media use. And as it stands the one marked as "primary" is the development domain name (which I can no longer access the site with). And DNN will not let me edit the current site alias (not even to mark it as primary). 

So, I edited the older site alias and unchecked primary. So now neither alias is marked as primary. So, I deleted the older alias (just leaving a single alias) and recycled the app pool and that doesn't mark the current domain alias as primary (the social media linkback URL is created with no domain in it now). My assumption being that if there is only one alias, then by default, it is the primary -- but apparently not...

So, how do I go about marking the only listed site alias as primary? Is it even possible?

Thanks for any help offered...

Jim

 

Thansks, please note that isPrimary has different requirements, if using Advanced URL rewriter in DNN 7.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Hi Sebastian,

I found the post (using Google again ;-) and it was from 2015, not 2008. Anyway I was able to use the same SQL script get the primary alias set correctly.

Here it is again just in case someone might need it:

UPDATE {databaseOwner}[{objectQualifier}PortalAlias] SET isPrimary = 0 WHERE HTTPAlias = 'olddomain.com'
GO
UPDATE {databaseOwner}[{objectQualifier}PortalAlias] SET isPrimary = 1 WHERE HTTPAlias = 'newdomain.com'
GO