coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: magus on September 28, 2006, 10:51:06 PM

Title: Delete all comments
Post by: magus on September 28, 2006, 10:51:06 PM
Hi, is there anyway of deleting all comments from the gallery? I have been spammed and I have to manually click every single check box to delete over 1000 pages!!!!  >:(

It would also help if there was a feature in reviewcom.php that lets you choose to "select all" in current page.  Can anybody assist me with this problem?  :'(
Title: Re: Delete all comments
Post by: Nibbler on September 28, 2006, 10:53:45 PM
You can empty the comments table using phpmyadmin.
Title: Re: Delete all comments
Post by: magus on September 29, 2006, 02:18:34 PM
I cant figure it out, can you send me more information on how to do that
Title: Re: Delete all comments
Post by: Sami on September 29, 2006, 02:28:20 PM
use phpmyadmin and run this command

truncate table xxx_comments

you should change xxx ,with your table prefix
- next time please post to proper board this board is not for support request !(labaled as a no support)
Moving ...