My first ever node (Welcome to our site) for a 3 year old site has disappeared.
On my home page in place of the node is simply a light red block and text "n/a".

I can find the node in my content and when I call it directly the page returns the following text and is not editable:
"Content
2"

In the database I can find the title of the page in the Nodes table but am not sure where to find the content.
I have backups.

How can I restore this page?

tia
- snack

Comments

level02’s picture

snack, check the node_revisions table for body text. How and why did it disappear after 3 years is the question? What changes where made lately?

snackmaster’s picture

The node doesn't exist in the node_revisions table.
Don't know how I did it. My RSS feed for the site did notify me of new content after the site update and it was the page/node in question with the content "n/a".

I have database backup from prior to the upgrade and from past, how can I find the node content and restore?

thanks

snackmaster’s picture

Got it - node_revisions is where the page lives.
Used Insert to add my backed up data to node_revisions and the data is showing up again.