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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...trouble after moving pages from one portal to another via databasetrouble after moving pages from one portal to another via database
Previous
 
Next
New Post
6/29/2014 6:36 PM
 
I’m having trouble with a site after moving a whole series of pages from portal 0 over to portal 3 directly in the DB.
I’ve done the process before (easily in older dnn versions 4 and 5, but not recently in 6 or 7). I normally do it across several steps, but this time in the DNN 7.1.1 site, it makes the pages when they load in the portal 3 location take two or three times longer than before to load. 

it's something where the original location in portal 0, the page loaded in a second or so... once it is moved over to portal 3 it takes about 9 seconds to load.

I’ve checked tab permissions, module permissions and more and can’t think of what might be causing this super slow down in their new home… 

I tested moving them back and they’re zippy again. 

Any of you run into something like that or heard of it before? 

I had a suggestion that I should check in the new TabUrls table to see if that was involved and it's certainly a new table now that iFinity URL is integrated in DNN. When I look at one of the tabs that I had moved, it's listed 4 or 5 times in that table by TabId and all of them have HTTP Status 301

I tried deleting all records for that TabId, and then putting back in a single new record but that hasn't proven to help.

This it the type of question I'd ask Bruce Chapman next time I see him at a convention, or at a user group meeting, but I'll need to work out a solution before then ; 0

I had another suggestion to instead work on moving these pages from one portal to the other using the Portal Export Template, I cringed at the thought, but WOW, that's gotten much better lately, the improvements are really nice. I can certainly pick by parent page... 

but even then, it's something like 1700 pages so there's a pretty big move here to do one way or another.

anyone else run into trouble lately or have a suggestion?

thanks!


 
New Post
6/30/2014 12:46 PM
 
Do the users who created the pages, modified the modules, and added the content exist as users in both portals?
 
New Post
6/30/2014 1:20 PM
 
yes, the roles that have editing rights set in the page settings exist in the new portal, and during the db script work the tabs were given the equivalent roleid in the TabPermission table

same with users, they are in these matching roles on the new portal

essentially move process looked like this:
Update Tabs PortalID, Level, TabPath where ParentId IN XYZ
Insert new TabPermission records for each page
Update Modules PortalID where TabModule TabId in XYZ
Insert into UserPortals X user new portal
Insert into UserRoles X user new role from portal
 
New Post
6/30/2014 5:09 PM
 
That's about the extent of my ideas, Ryan. Sorry.
 
New Post
7/1/2014 6:13 AM
 
DNN 7.1.1 has a number of Performance Limits, you may consider upgrading to DNN 7.3.0 and check out my Turbo SQL optimization at http://dnnscript.codeplex.com

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...trouble after moving pages from one portal to another via databasetrouble after moving pages from one portal to another via database


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