By SparkyUK on

Drupal 4.7

I am new to Drupal and have spent the last week or so learning by doing. I’d like to start building my actual site now, but I can’t delete my existing faux content. Ideally, I would like to wipe all content from my site, but keep the existing modules and settings.

I’m thinking this probably wasn’t the best way to do this, but as I said, I having been hacking around trying to learn the ins and outs of drupal so… anyway, I’ve deleted a few nodes from the MySQL database and now they are appearing as ghosts (“n/a”) on my frontpage. When I go into content I still see them listed there. If I click on them though it says access denied. If I try to delete them from the content menu, it says they are deleted but they continue to appear. Any advice on how to really get rid of them would be great.

Alternatively, if anyone knows how to delete all content, that would be helpful too. I have only used Bookreview module and page nodes for content.

Cheers.

⋅ Categories: Drupal 4.7.x

Comments

BlackSash’s picture

BlackSash commented

Is to simply import the clean database.*sql file into your database again. Clean settings, clean tables. If you have only 2 modules installed, and not made many changes in settings and so on it will be a work of 5 minutes to set them again.

-------------------------------
GU d- -p+ c++++ l++ e* m* s+ n+ h+ f? g+ w+++ t- r y?
Madcap - design - development - consultancy
http://www.madcap.nl - Running on Drupal, of course.

SparkyUK’s picture

SparkyUK commented

Hi,
I actualy want to maintain my settings if at all possible. While I have only use two modules holding content, I have probably another dozen or so in place just the way I want them, that I'd rather not have to reset.
Can I just clear specific tables associated with content? When I tried to do this before though I got the ghosts...
thanks

geodaniel’s picture

geodaniel commented

Welcome to the community - learning by doing is the best way to do it!

You could try going to http://yoursite.com/?q=admin/node and select all the nodes you want to delete from in there. You may find that this doesn't work though, if you've deleted some bits directly from the database already.

If that doesn't work and you still need to delete things from the database directly, you'll need to empty 'node' and 'node_access' along with the tables for any of the content-type modules you've used (like blog, story, page, etc). As a word of caution though, be very careful when deleting things directly from the database, you should always do it through the Drupal interface.