coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: peu on September 07, 2007, 06:53:42 PM

Title: Help: Flooded, want to remove ALL comments
Post by: peu on September 07, 2007, 06:53:42 PM
I update my photo album every now and then, and I dont recall the last time I checked the photos, my mistake, just today and after months I noticed the comment system was flooded with spam.

After blocking access to invited users to post, and limiting the comment lenght, I started deleting comments by the 100s but its an endless task, next step was to modify reviewcom.php to erase 999 at a time, but it also seems to never end.

My question is, is there a way to delete all the comments at once? Im using v1.4.4

Thanks!
Title: Re: Help: Flooded, want to remove ALL comments
Post by: Nibbler on September 07, 2007, 08:07:20 PM
First update your gallery. Then empty (not drop) the comments table using phpmyadmin.
Title: Re: Help: Flooded, want to remove ALL comments
Post by: peu on September 08, 2007, 01:47:38 AM
thanks, updated and did what you suggested.

Now, is there a way to block comments from guests or only allow comments by registered users?

Title: Re: Help: Flooded, want to remove ALL comments
Post by: Nibbler on September 08, 2007, 01:51:28 AM
Yes, set the permissions you want on the groups page.
Title: Re: Help: Flooded, want to remove ALL comments
Post by: peu on September 10, 2007, 04:48:50 AM
thanks again!