[SOLVED] panic - 'lost' homepage

Hi,

Just been trying to sort out permissions for different user groups and wanted to restrict access to certain parts of the site to certain users. I did some dragging of pages of the main tree and realised that I had added "home" to a resource group. I right clicked it and said "remove from resource group". However, now I have ’lost’ the homepage from the manager tree. The site is still working, but I can’t manage the homepage anymore, can’t access. I then removed all resource groups and removed all resource group access from the user groups but still nothing. Help, what can I do to get my homepage back into my tree???

OK, here is what I *think* happened:
before I right clicked the "home", I thought I could maybe just drag it back to the right hand side. This didn’t work, so I then removed it by right clicking as described above.
However, what seems to have happened is that the dragging of the homepage across onto the "homepage" on the right hand side triggered an update to the database and made the homepage have a parent of "1", i.e. the page was it’s own parent. This meant it wouldn’t display in the tree. I went to the database to see if I could see anything anywhere and when I saw that the homepage had the parent of 1 I realised this looked wrong. Setting it to 0 and reloading the tree solved it. Phew! However, it’s a little odd that I should be able to reorder the tree in the "Reource groups" function? Should not happen there I don’t think - or maybe it was just an accidental glitch? Don’t want to try it again

This just happened to me, I lost three pages. They are still on the website, but they are gone int he doc tree.

Rev 2.1.4

I don't really understand the database changes I need to make to fix this. If someone understands this and can help me change this in phpmyadmin, that would be awesome!

Go to PhpMyAdmin in your host's cPanel and select the MODX database.

Select the modx_site_content table and find the home page line (it should be at or near the top). Look at the 'parent' field. It's normally 0 and it should definitely not be the same as the ID field. If it is, there's an icon that lets you edit that record -- just change the content of that field to 0 and save the record.

If you want to play it safe, you can select the DB and then click on "Export" to export the DB to a local .SQL file. Then you'll have that export as a backup (a good thing to have in any event).

Thanks, I got it. Much easier than I had thought.