Deleted content tab

Well, despite all my warnings and explicit instructions, one of my users up and deleted content by clicking on the "View/Edit Content" tab and deleting the entire page and consequently the Tab for it as well.

Is there any way to recover from this mistake? The content appears to still be there in the content_history table.

Go to the View Edit Content page in the PowerCMS Admin section, find the page for the content that was deleted and click the History button.

This will show the history for any CMS Content, and allow you to revert to a backup by click ing the revert link.

Originally Said By: Jason Byrnes

  Go to the View Edit Content page in the PowerCMS Admin section, find the page for the content that was deleted and click the History button.

This will show the history for any CMS Content, and allow you to revert to a backup by click ing the revert link.  

Ya, that would work had the users not deleted the page itself. I'm thinking that if I just recreate the "Page" that I could copy the deleted content that seems to still be in the "content_history" table. Anyone knwo if that will work?

Ahhh OK, now i understand the problem a bit more.


You will need to get into the database and make some changes there for this to work. I strongly recomend backing up the DB before proceeding, just in case.


each Page Name | Content Area is given a unique ID


You can recreate a new Page Name | Content Area record on the insert tab, then you will need to go into the "contents" table and find the "ContentID" value for the record tha twas just created.


Now, open the "contenthistory" table, the "HistoryContentID" column is a foriegn key relation to the "contents.ContentID column, find the record histories that belong to the page that was deleted, and you can change the HistoryContentID value to the new one that was created to relate them.

This should allow you to retrieve the old content through the history page.

Thanks Jason, that exactly the scenario I was thinking would work - though I wasn't sure of which table I needed to work with.

Jeff