Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Primary Site AliasPrimary Site Alias
Previous
 
Next
New Post
10/29/2015 1:55 PM
 

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

 

 
New Post
10/29/2015 2:09 PM
 
Well, how about that. It turns out that I posted the exact question back 2008 and the solution was to run a SQL script that forced the isPrimary entry to true. I ran it this time and I'm good to go!

Thanks for the tip Sebastian (the first time and this time ;-)
 
New Post
10/30/2015 3:54 PM
 
Thansks, please note that isPrimary has different requirements, if using Advanced URL rewriter in DNN 7.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/3/2017 8:01 PM
 

Hi again Sebastian,

Well, I have another site that I need to do this same thing to. But, for some reason, my searches on the forum are only going back a year or so. I have 277 posts, but I can only see 18 of them? I only found this older thread using by using Google (not the DNN forum search)...

Anyway, is there any way you can post the same SQL script that will allow me to set/reset the primary alias (isPrimary)? Or maybe provide a link to the 2008 thread? Thanks!

Jim

 
New Post
4/3/2017 10:58 PM
 
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
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Primary Site AliasPrimary Site Alias


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out