Yesterday I spent a good amount of time developing a database back-end and a dynamic page using a repeater element. The page was live on my site and went through several publish actions throughout the day. Today the page and database just vanished from my Site Structure and the page URL no longer resolves. Obviously, this is a big concern for me as I seemingly did not take any knowing action that would have erased the work. How can I recover this data?
Hi Andrew, can you please share the site address?
Bump.
Which database and page disappeared?
It was a dynamic page called CustomerTestimonials and the associated data set.
When did you notice it disappeared? Or when was the last time you remember working on the database? I’m just trying to narrow it down and find the root cause.
I was working on the page Wednesday, had it pretty much ready to go-live, it was still there Thursday morning, at some point during the day Thursday it was gone.
OK, from what I could find, you had more than one editor session open, and around Thursday morning the older one of them saved a version that overwrote the newer session, thus making the database disappear (it was probably created in the other session).
Assuming you saved at least one version that contained the database and the page, you should be able to go to Site History, and restore that version. Your site will return to the way it was in that version, including databases, pages and custom code.
Let me know how that goes.
I will check it out. What you are describing has happened to me several times recently where the editor says I have more than one session open. I check all my browser tabs and verify there is in fact only one open. Strange.
It could be someone else saving the site, like a contributor. Maybe that was the case?
One issue I’m running into is that I have since made a blog post which has a pretty high social engagement. If I restore to a previous version I’ll loose that work and the associated URL which is out on Facebook, Linkedin, etc. Any way for me to pick individual elements to restore rather than wiping out my whole site?
Unfortunately not, you can only restore the entire site.
You can do something instead - recreate the database. You can create a new database with the same name - “CustomerTestimonials”, and it will still show all the data you previously entered.
You still need to create the dynamic page though, but maybe it’s better than restoring the entire site.
That worked, but now the problem exists when trying to connect to the data the only options I get are these
which don’t allign with my database values. Please advise.
Fixed it, I had to go back in to all the database values and add them to the schema and update the field types.
Same happened here only on unplublished site. It has to do with CMS renaming but I cannot restore my collections. Can someone advise please, its imossible to reach customer service.
Many thanks