Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Mass removal of comments possible?  (Read 9216 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.038 seconds with 20 queries.