Hi,

I have a site (www.successfulspeaking.co.nz) which has been running quite happily on SS 2.0.1 for several years.

Anyway, was just working on some new pages in the CMS when all the the site content disappeared from the tree. All that is showing now is the 'Site Content' icon and 'page not found'. Thankfully, the live site seems to be unaffected (so I assume the db, template, content display functions are all still working).

So, I'm a bit confused as to what happened or how to restore the site - especially as there is nothing in the history tab either.

Help?

Cheers,
Jon

You might want to consider upgrading to 2.3.6, since 2.0.1 is quite old! 2.4.0 is on the way too, so now could be the time.

Of course, you should upgrade and test locally in your dev environment with the live database first!

A few things to check with the existing site:

* Is the SiteTree table still containing all the data? SiteTree_Live should definitely have everything if the site's still showing pages
* Cross checking the ParentID columns of the pages in the SiteTree and SiteTree_Live - the top level pages should have a ParentID of 0

Sean

Hi Sean,

Thanks for the reply. I guess it is about time we upgraded - I think I may wait for 2.4 if that's possible.

I have looked at the database, and as far as I can see, everything is where it should be in sitetree and sitetree_live. Just not showing up in the CMS.

Strangely enough, the only page in sitetree that has a parentid = 0 is the pagenotfound page. All the top level pages have a parentid = 1. Is this significant?

Cheers,
Jon

That is, and this most likely explains why they don't show up in the CMS. Do the entries in SiteTree_Live have ParentID = 0? You could try backing up SiteTree, then copying the contents of SiteTree_Live into SiteTree. This could be a temporary fix before you decide to upgrade. :-)

Sean

Hi Sean,

I looked through sitetree_live, and the only entries with parentid = 0 were the homepage and the error page. All the other top-level pages have a parentid=1, same as in sitetree.

Cheers
Jon

*bump*

Hi Sean,

I found out what was causing the site to be not displayed in the CMS interface - turned out that the parentid of the home page was set to 31 instead 0. Since 31 in the id of a page in the site, I assume it set up some kind of circular reference which it couldn't resolve.

I was just about to copy sitetree_live into site tree and decided to do one final check of the data in those tables. When I found the problem, I took a backup and just overwrote the parentid of home page with 0 and the site was "magically" restored! Not sure how that could've happened, but I guess it may have been a stray click. Can the parentid of a page be set through the GUI?

Anyway, thanks for the suggestions. If nothing else, it has added to my knowledge of Silverstripe! ;-)

Cheers,
Jon