By Nomex on

I went to the front page of my blog [antiguapressreleases.com] and noticed there were alot of spam articles on my home page.
When i checked the backend I saw that there were a few non authorized accounts that had posted these spam articles so I quickly deleted them.
This removed all of the spam articles but left 'n/a' in their place. I dont know how to remove these articles from the site please advise.

⋅ Categories: Drupal 5.x

Comments

saepl’s picture

saepl commented

You can remove these by going into admin and then content and then from there you can either unpublish, edit or delete them

Nomex’s picture

Nomex commented

I did what you said but when you go into admin>content these n/a posts don't show up, only the regular content is visible.
How do i search for these items in the content area [antiguapressreleases.com]

saepl’s picture

saepl commented

Sorry I miss read your post. I have not experienced the n/a issue you are having. I went to the site but I can't see anything because it is in offline mode.

Nomex’s picture

Nomex commented

I have put the site back online.

saepl’s picture

saepl commented

Those n/a comments are wrapped in a div with class "node-unpublished" Are you generating that list via a view? If you are you should add a filter to only show published nodes

Nomex’s picture

Nomex commented

i found the div wraps and sorted it out

saepl’s picture

saepl commented

What was the issue with them being n/a?

obeiki’s picture

obeiki commented

Dear Nomex,
Could you please kindly give me more details about this div wraps in openpublish. I am a beginner in such issues.

regards,
Omid

brittnigirl’s picture

brittnigirl commented

today I noticed my drupal site's front page was missing.. and replaced with 'N/A'?? what happened?? the way I do a 'front page' is I make a 'page' and click 'promoted to front page' in the publish settings..

I found the content area that lists all the pages.. and my old front page is completely missing..

anyone have any clue how to fix it??

I made a new front page.. but under it, it has the old page that says 'N/A'.. there is no way to click it.. or edit it.. I can't figure out what it is?

~Brittni

chissy’s picture

chissy commented

Did you delete the user who created the page?

chissy’s picture

chissy commented

I also got this error when I deleted some users who had previously posted to the site. You need to delete the nodes from the database. Here's how:

1. Open phpmyadmin and select your database
2. Select the SQL command and paste the following query and press go:
SELECT node.* FROM node
LEFT JOIN users ON node.uid=users.uid
WHERE users.uid IS NULL;
3. After a moment (length of this moment depends on how much content you're deleting) you should see a list of all the unwanted content. Check all the entries and click the big red X to delete them

This should solve the problem, just make sure your cache is empty before you reload

pfeff’s picture

pfeff commented

I had similar problems to this. Turns out the reason was I'd deleted the anonymous user - uid=0.

I installed this module which creates uid=0 if it doesn't exist. Fixed the problems.

http://drupal.org/project/anonymous_user