1
Ace_Armstrong
Wipe it out and start over!

I just heard from a client who (against my advice) had allowed for anonymous posting on his site, and you can guess what he now has eight million of. What's the best way to wipe out the guestbook and forums to start over? Anyone know? Guestbook is xfguestbook and the forums are the old newbb forums module.

Thanks!
Ace Armstrong
The Man. The Myth. The Mammal.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Intelligent, informed debate good. Innuendo bad. See for yourself!
www.GLOAMING.us

2
jdseymour
Re: Wipe it out and start over!

If it is just those modules, and you don't mind loosing worthwhile posts, just uninstall and reinstall the modules. The database tables will be dropped during uninstall, so when you reinstall the modules they will be brand new and empty.

3
MadFish
Re: Wipe it out and start over!
  • 2007/4/18 2:17

  • MadFish

  • Friend of XOOPS

  • Posts: 1056

  • Since: 2003/9/27


If you want to throw it all in the river, just uninstall the module and reinstall it. Easy.

4
Catzwolf
Re: Wipe it out and start over!
  • 2007/4/18 2:40

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Or find the database tables that hold the posts and empty them, that way you keep everything else intact.

5
jmorris2
Re: Wipe it out and start over!
  • 2007/4/18 2:57

  • jmorris2

  • Just popping in

  • Posts: 46

  • Since: 2007/4/17


Use phpMyAdmin to "select all" of the posts, then go through them and deselect the valid posts, then use the drop option to remove the offending posts.

The other option would be a long MySQL drop statement that could be a real pain in the butt.
The lights are on... nobody's home

6
Catzwolf
Re: Wipe it out and start over!
  • 2007/4/18 4:17

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


A, He did say he wanted to basically remove all the posts and what i suggested would do that without losing categories and forum permissions. (And if I wasn't clear enough before I would suggest using phpmyadmin for this).

Quote:
The other option would be a long MySQL drop statement that could be a real pain in the butt.


2. Pardon me? But if I had to go through 40,000+ posts I would consider that a pain in the butt. Personally I would just empty the tables and start fresh. But am sure you would like to volunteer to do this? lol

7
jmorris2
Re: Wipe it out and start over!
  • 2007/4/18 12:14

  • jmorris2

  • Just popping in

  • Posts: 46

  • Since: 2007/4/17


I was just making a suggestion. Take it for what it is worth.
The lights are on... nobody's home

8
mortuk
Re: Wipe it out and start over!
  • 2007/4/18 12:35

  • mortuk

  • Not too shy to talk

  • Posts: 122

  • Since: 2005/12/13


it waz a gud idea nobody - but mite take a long time

9
AndyM
Re: Wipe it out and start over!
  • 2007/4/18 13:17

  • AndyM

  • Quite a regular

  • Posts: 296

  • Since: 2003/8/31


Usually, I'd do a manual MySQL query, either from command line, or in phpmyadmin, but forum post data is spread across two tables in newbb/cbb, which makes that harder.

In the guestbook, I imagine this should still be possible (I can't be sure without checking the DB structure), but a MySQL query like the following should do the job:

DELETE FROM guestbook_table_name WHERE text_field LIKE '%viagra%';


That will delete all messages that contain "viagra", for example.

Login

Username:
Password:

Lost Password? Register now!

Who's Online

59 user(s) are online (28 user(s) are browsing Support Forums)


Members: 0


Guests: 59


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits