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 StartedNew to DNN Plat...New to DNN Plat...Orphan Pages and SQL TablesOrphan Pages and SQL Tables
Previous
 
Next
New Post
4/16/2010 3:10 PM
 

Hello,

I am experimenting with adding pages and child pages to the basic fresh install DotNetNuke site.  I noticed that if I edit the page properties and set the parent page, the Admin/Pages tab control does not reflect the hiearchy with ...pagename.  It appears that one should ONLY use the tab control to set the parent page by moving the prospective child under the parent in the list and clicking the green arrow to "move select page down one hierarchcial level".  If you set the parent through the settings screen, you have to reset it to "none specified"  and then use the tab control to regain the graphical representation of the hierarchy.

MUCH WORSE, in pulling my hair trying to figure out why it wasn't working, I managed to orphan several pages.  I have just done it again!  I had a page "RaviHome" and a child page "RaviChild4" that displayed properly in the tab control as "...RaviChild4".  I hit the left arrow to "move selected page up one hierarchical level".  It displayed in the list without the "..." (I actually hit the arrow several times, but don't think that matters.)  I check the settings for the page "RaviChild4" and the parent is "none selected" (as I would expect).  Then in the setting screen I select "RaviHome" as the parent and click update.  The page has disappeared from the menu system and from the tab list.  GONE.

I added a new child to the "RaviHome" parent page, specifying the parent on creation, and it placed it in the menu, but did not put the "...RaviChild5" in the tab control.  Listed it as though it was a top level page, "RaviChild5". As are the other children.  I click the left arrow a couple of times; it shows in the main menu as a top level page; go to settings and specify "RaviHome"; click update, and its GONE.  NO WAY TO FIND IT.  No longer in the menu and no longer in the tab control. I tried the same thing with a second parent page and repeated the same problem with a new child page.  I easily orphaned it.

If I look in the SQL table "ContentItems", I see all my orphan pages listed as well as the modules they contained.  The table has a unique ContentItemID field and a ContentTypeID (1 for a page; 2 for a module), but I see nothing in this table that ties the pages together in terms of Parent/Child or order of Children.

SO, to summarize my questions:

1.  What is causing the child pages to disappear by reassigning the parent page in the settings screen, causing the new parent to eat its children?

2.  What is the name of the SQL table that glues parents and children together and stores the ordering and hierarchical information? 

One piece of informatioin that may or may not be related:  I added a Tab module to one of the original Child pages that is now orphaned.  I'm sure I tried to use that tab module to rearrange pages.  I can see that tab module still listed in the SQL table.  Since then I have been using the tab module on the the Admin/Pages screen.  Is it taboo to add a tab module to another page?  Could that orphaned tab module be interfering somehow?

Thank you for any light anyone can shed on this wierdness.

Ravi 

 
New Post
4/16/2010 4:53 PM
 

Following up:

I have just repeated this issue on an entirely different computer at home with its own fresh install of DotNetNuke.  The first computer at work is running Windows 7, SQLExpress 2008, and the current version of DotNetNuke 05.03.01.  The second computer is running Vista SP1 and the same SQLExpress 2008 and DNN 05.03.01.

On this computer, I did NOT ever put a tab module on a page.  It is a brand new install.  I created a RaviHome page, and 3 child pages.  Just by using the tab control in combination with the settings page as described in my first post, I have orphaned all three child pages.  I know of no way to bring them back.  As before, they are still listed in the ContentItems table.

This would seem to confirm that there is a bug in DNN.  It would be a real problem on a production site!

Ravi

 
New Post
4/16/2010 7:25 PM
 
I have now realized that even though the child pages are gone from the menu, I can still access them directly through their url, for example .../ravihome/ravichild1.aspx. Once the page is displayed I can click Settings under Page Functions and select "" for the parent page. This puts the page back on the main menu and on the Admin/Pages tab control. However it is not possible to reorder the page or move its level with the tab control, and reassigning the page to a parent on the settings screen makes the page disappear again from the menu. If you know where you put it, you can access it again with its url. Seems very odd to me. -r
 
New Post
5/11/2010 3:03 PM
 
We have the same issue on our site. IIS 7 on Server 2008 with SQL 2005 db.
 
New Post
5/13/2010 4:55 AM
 
I'm having the same problem.

I brought back one of the orphaned pages as described above. I couldn't get the other to show up however, so I navigated to it by using it's URL (as described above) and deleted the page.

I'm unable to recreate the page though, since I get the message the page is in the recycle bin, so I should undelete it. If I go to the recycle bin however, there isn't an item for the orphaned page. So at this point I neither can restore the orphaned page from the recycle bin nor can I recreate the page, since I can't use the same name.

How can I "hard-empty" the recycle bin? Or how do I fix this?
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Orphan Pages and SQL TablesOrphan Pages and SQL Tables


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