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: Delete old comments  (Read 6819 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.024 seconds with 21 queries.