By polar-bear on

I have one article promoted to the frontpage but only thing is containes is "n/a". Here is my website

http://www.kseauk.org/sig-p/

Could someone tell me which table in MySQL DB containes nodes, please?

Thank you.

⋅ Categories: Drupal 5.x

Comments

catch’s picture

catch
he/him
Primary language English
commented

You should be able to take it of your front page by either editing the node and unchecking "promoted to front page" in publishing options, or going to admin >> content administration and using the content administration to find the node and change status.

If not, the content of the node and whether it's on your front page or not are stored in two seperate places in the DB, so you'd need to say exactly what you want to change. I'd go via the node edit or admin interfaces first though.

polar-bear’s picture

polar-bear commented

I cannot edit the node because there is no link from the frontpage.

If I go to admin >> content the node does not appear on the list. I even filtered the list with "status" "published" but it does not appear on the list. What is even wairder is that the list containes 7 items but on the frontpage there are 8 items if I include the "n/a" teaser!

catch’s picture

catch
he/him
Primary language English
commented

I took a look at the source code for your page, and it's definitely trying to print a node there. However there's no node id to reference it against.

I'm don't have drupal 5.1 tables to hand, but you should probably look at the node table first. It's a strange issue though and I'm wondering if it might be to do with your theme (or views?) instead.

polar-bear’s picture

polar-bear commented

I just tried other themes (currently I am using Barlow but tried Bluebreeze and Zen) but others still have the "n\a" teaser. However, interestingly, the background colour of "n\a" teaser with Bluebreeze and Zen was different from the rest of the teaser.

I also deleted my customerized frontpage "View" to revert back to the standard frontpage and it is still there so I don't think it is the View either.

polar-bear’s picture

polar-bear commented

I have fixed the problem.

I found one of the spams has been posted as image and (I think) Spam module unpublished it. However the node has been promoted to the frontpage and it created "n/a" nodeteaser.

I have change "node" table so that the node is not promoted to the frontpage and "n/a" teaser is gone.