Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...transferring web sitetransferring web site
Previous
 
Next
New Post
1/29/2007 10:45 PM
 

Hi,

I need your help here for transfering my web site to another server...  I copied all my site files to my new server, I've backup my database and restored it to the new server.  After I've made the modification to the webconfig file.  After that, when I try my temporary address of my new server, I'm redirected to my old server address !!!

Trying to solve my problem, I did log in as the host on my portal and checked under host menu, portals.  The portal address that is indicated is my old address on my old server.... should I change this adress to my new server address before backing up the database or before copying the site files ?  Is this the answer to the redirection to my old server ?

thanks for your help

 
New Post
1/30/2007 8:43 AM
 
Yes, it must have something to do with your problem.  What I usually do is modify my PortalAlias table in my db once it is copied to the new server.  You just have to enter your new url and everything should work.
 
New Post
1/30/2007 10:33 AM
 

I don't think the fix is just that simple.  I had a "similar" issue, but same server.  I actually changed the alias to one of the portals on my development server and deleted the old alias... all "auto-generated" links work great, but any of the links in the HTML editor still pointed to the old alias under which they were created (using the FCKEditor provider).  In other words, I may have had a link that referenced http://www.someoldalias.com/somepages/tabid/etc that, upon deleting the old alias will obviously come up "page cannot be displayed".  The problem is that the new alias doesn't automatically propagate over all of the "static" links.

What I ended up doing was writing a little SQL script to modify the HtmlText table en masse for this specific portal and replace all instances of "someoldalias" with "somenewalias".  The caveat to this is that for my script to work, none of the HtmlEditor areas could have more than 8000 characters (including source HTML), otherwise it would have suffered data loss.  Luckily, my biggest one was only 5k characters.  My script:

--SELECT script to make sure I wouldn't suffer data loss

SELECT    
                dbo.HtmlText.ModuleID,
                dbo.HtmlText.DesktopHtml,
                dbo.HtmlText.DesktopSummary,
                dbo.HtmlText.CreatedByUser,
                dbo.HtmlText.CreatedDate,
    len(convert(varchar(8000), desktophtml)) as charcount
FROM        
                dbo.HtmlText INNER JOIN
                dbo.Modules ON dbo.HtmlText.ModuleID = dbo.Modules.ModuleID
WHERE    
                (dbo.Modules.PortalID = 5)
                AND (dbo.HtmlText.DesktopHtml LIKE '%foober.homeip.net%')
 
-- UPDATE script to replace all the old instances with new instance

UPDATE
                dbo.HtmlText
SET
                DesktopHtml = REPLACE(CONVERT(varchar(8000), DesktopHtml), CONVERT(varchar(8000),'foober.homeip.net'), CONVERT(varchar(8000),'sleepingbag.homeip.net'))
FROM
                dbo.HtmlText INNER JOIN dbo.Modules 
                ON dbo.HtmlText.ModuleID = dbo.Modules.ModuleID
WHERE
                (dbo.Modules.PortalID = 5)
                AND (dbo.HtmlText.DesktopHtml LIKE '%foober.homeip.net%')

What would be nice is if changing the alias could go change all the Html areas and remove the old alias and replace with new alias... but in the meantime, at least a script can do it.

-- Fooberichu


-- Jon Seeley
DotNetNuke Modules
Custom DotNetNuke and .NET Development
http://www.seeleyware.com
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...transferring web sitetransferring web site


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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out