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: Delete old comments  (Read 6815 times)

0 Members and 1 Guest are viewing this topic.

ian ditch

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Delete old comments
« on: October 01, 2006, 01:16:43 am »

My gallery has been going for a few years now and i would like to delete any comments over a year old.

Is there any way that i could delete these comments quickly, with-out doing it manually?
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Delete old comments
« Reply #1 on: October 02, 2006, 06:45:45 am »

Yes you can delete them by phpmyadmin or any other mysql manager that you have just go to your database and run something like this:
Code: [Select]
DELETE FROM XXX_comments where msg_date < '2005-01-01'
You should change XXX with your table prefix
Logged
‍I don't answer to PM with support question
Please post your issue to related board
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 22 queries.