Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Mass removal of comments possible?  (Read 8203 times)

0 Members and 1 Guest are viewing this topic.

polaatx

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Mass removal of comments possible?
« on: September 22, 2006, 05:40:21 am »

My site has been victim of spammers: http://lotteryofbirth.com/thumbnails.php?album=lastcom&cat=-8 with many ugly links. I finally figured out how to turn off anonymous comments. But now removing all this crap will take forever. Is there a way to remove all comments quickly? Or at least, is there a way to get it not to ask for comments-delete confirmation?
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Mass removal of comments possible?
« Reply #1 on: September 22, 2006, 07:24:42 am »

You can maualy delete them by phpmyadmin :
- open up the xxx_comments table from database
- here you can delete each of them or you could delete all the comments (both bad and good one) by running this query
Code: [Select]
truncate table xxx_comments
xxx_ is your  table pre fix
Once again , this query will delete all comments from the table be carefull
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Nibbler

  • Guest
Re: Mass removal of comments possible?
« Reply #2 on: September 22, 2006, 07:33:03 am »

To delete any comments containing links:

Code: [Select]
DELETE FROM xxx_comments WHERE msg_body LIKE '%http%'
Backup the table before you run any queries if your comments are important.
Logged
Pages: [1]   Go Up
 

Page created in 0.165 seconds with 19 queries.