Delete all comments ?

SpookiePower

Joined: 2005-10-04
Posts: 164
Posted: Mon, 2007-04-02 12:36

Is it possible somewhere to delete all the comments
and to see them ?

--
My Gallery
www.photo.box2600.dk

Gallery version = 2.1.2 core 1.1.0.2
PHP version = 4.3.10-18 cgi-fcgi
Webserver = Apache/2.0.54 (Debian GNU/Linux)
Database = mysql 4.1.11-Debian_4sarge7-log, lock.system=flock
Toolkits = ArchiveUpload, Exif, ImageMagick, NetPBM, SquareThumb, Thumbnail, Gd, Getid3
Acceleration = none, none
Operating system = Linux web1 2.6.8+vserver #1 SMP Wed Jun 7 23:09:25 CEST 2006 i686
Default theme = PGtheme
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Mon, 2007-04-02 13:21

@see:
-> in g2.2, go to your main.php page and click "view latest comments"

@delete:
to delete all comments, uninstall the comment module. then install it again.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
SpookiePower

Joined: 2005-10-04
Posts: 164
Posted: Mon, 2007-04-02 13:25

Thanks :)

I had 14555 porn comments in my gallery. Now I'm clear again :)
 
sparker

Joined: 2004-02-18
Posts: 27
Posted: Tue, 2007-07-17 03:13

Steve

I tried the "uninstall/reinstall" but all the comments are still there.

Any other ideas?

Whoops. Tried deactivate, but not uninstall. My gallery got slammed with 1.7Gb of garbage the other day, so I need some way to clean this up. I'll do the uninstall thing now... :)

I'll modiy permissions (my fault entirely for leaving them set to the default) after I get this cleaned up.

Steve
 
sparker

Joined: 2004-02-18
Posts: 27
Posted: Wed, 2007-07-18 02:29

OK. It's worse than I thought....

I got hit with just over 150,000 comments. I can't seem to uninstall the comment module (I mistakenly said "Gallery" before, and edited this post). When I click the confirm button on the uninstallation, it runs for about 30 seconds, and then just returns with a blank, white screen.

Can I use phpMyAdmin to simply delete allrows from the comments table without hurting anything? Are there any cross references I'll have to be concerned with?

Thanks,

Steve
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2007-07-18 07:31

> Can I use phpMyAdmin to simply delete allrows from the comments table without hurting anything?

no.
please see existing forum discussions on the topic.

you can also use the "commentblaster" script which is listed on the download page.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
Edman

Joined: 2007-07-29
Posts: 12
Posted: Sun, 2007-07-29 16:34

Maybe a feature to write out the letters/symbols in a box can solve the comments problems against spambots.

________________________________________________________________________________________________
 
mukan
mukan's picture

Joined: 2007-07-28
Posts: 17
Posted: Mon, 2007-07-30 18:40

take a look here: http://gallery.menalto.com/node/55122
But there is no good solution about this, we are all waiting.
------------------------------------
 
skunker

Joined: 2005-02-04
Posts: 304
Posted: Tue, 2007-11-06 15:48

To view all the comments in G2, valiant suggested to go to the main root of your gallery and click on VIEW ALL COMMENTS to see the list of all the comments. HOwever, when I do this, I do not see any comments listed. It says no comments have been posted. How can this be when I do have comments posted for some photos?
 
cameli
cameli's picture

Joined: 2003-07-21
Posts: 37
Posted: Mon, 2008-02-25 15:48

I tried this ... but i can't unistall the module .. always get this error message

Quote:
Warning: fopen(): open_basedir restriction in effect. File(/tmp/GalleryPluginHelper_fetchPluginStatus.incnbSsas) is not within the allowed path(s): (/home/www/web212/:/usr/bin) in /home/www/web212/html/apps/gallery/modules/core/classes/GalleryPlatform.class on line 403

Warning: fopen(/tmp/GalleryPluginHelper_fetchPluginStatus.incnbSsas): failed to open stream: Die Operation ist nicht erlaubt in /home/www/web212/html/apps/gallery/modules/core/classes/GalleryPlatform.class on line 403

Warning: fopen(): open_basedir restriction in effect. File(/tmp/GalleryPluginHelper_fetchPluginStatus.inclUWO6D) is not within the allowed path(s): (/home/www/web212/:/usr/bin) in /home/www/web212/html/apps/gallery/modules/core/classes/GalleryPlatform.class on line 403

Warning: fopen(/tmp/GalleryPluginHelper_fetchPluginStatus.inclUWO6D): failed to open stream: Die Operation ist nicht erlaubt in /home/www/web212/html/apps/gallery/modules/core/classes/GalleryPlatform.class on line 403

Warning: unlink(/home/www/web212/html/apps/gallery/g2data/cache/module/rewrite/0/0/0.inc): Keine Berechtigung in /home/www/web212/html/apps/gallery/modules/core/classes/GalleryPlatform.class on line 545

May someone help me? This f***ing comments are SPAM !!!

=====
Systeminformation
Gallery-Version = 2.1.1 Kern 1.1.0.1
PHP-Version = 4.3.11 apache
Webserver = Apache
Datenbank = mysql 4.0.27, lock.system=database
Werkzeuge = Exif, Gd
Beschleunigung = none, none
Betriebssystem = Linux tux11 2.6.11.4-21.17-default #1 Fri Apr 6 08:42:34 UTC 2007 i686
Standard-Motiv = matrix
Sprache = de_DE
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.12