Spam attacks - need help!

catnipmercer · September 27th, 2006, 02:51 PM

Our photoboard has been under increasing spam attacks with HUGE spam messages being sent to it. I moderate all posts but wish you had a "remove all" not just a "approve all" link since there are few comments that I approve and ALL the 100-200 others are generally spam each day.

Today I had a far worse problem. I tried to log in to moderate comments and received this message:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2927174 bytes) in /hermes/web03/b460/pow.catnip/htdocs/photopost/adm-misc.php on line 2279

How do I protect our photoboard from being overwhelmed like this? Is there some way I can simply make it impossible for nonregistered participants to post anything at all and still allow registered members to post?

HELP! I may be posting this to the wrong section.. couldn't find one that fits this subject well. If so, my apologies.

Linda

Chuck S · September 27th, 2006, 03:14 PM

This would depend on your setup and it would seem you have guests allowed to upload and or post

Simply in usergroup options in admin set them to do nothing

catnipmercer · September 30th, 2006, 11:25 AM

Found it! Thank you!

Linda

catnipmercer · September 30th, 2006, 12:31 PM

Please....Is there some way to quickly remove 500+ comments from the moderator interface? They are HUGE comments that cause the frame to extend to the left of the page so I have to scroll, and removing them one by one will take FOREVER.

Linda

Chuck S · September 30th, 2006, 12:39 PM

No there is no way to do that they need to be removed one at a time

Michael P · September 30th, 2006, 12:55 PM

I wish I had a quick fix for you - it's something we could look to add in the future; but other than running an SQL statement manually in phpmyadmin, I'm not sure how else to tell you to proceed.

catnipmercer · September 30th, 2006, 03:52 PM

I have removed 500 and there 500 more.. looking at the comment counts on the site there are THOUSANDS. Please, how do I get rid of them without losing the photos, too by overwriting the whole database?

Chuck S · September 30th, 2006, 04:26 PM

The only thing we can do to assist would tell you to delete all comments via phpmyadmin you should be able to hit the empty link for comments

Whether you do that is up to you but as Michael and I posted not much else we can suggest.

catnipmercer · September 30th, 2006, 06:18 PM

Ok, I cleared them all once I realized one category had 10,000 comments! (Gosh, a week of vacation and they trashed the board in my absence!)

How do I reset the comment numbers.. though there are no comments the numbers still show huge comment numbers in the columns.

Linda

Chuck S · September 30th, 2006, 06:23 PM

You can scan database in admin and hit update counts

catnipmercer · September 30th, 2006, 07:46 PM

That reset the numbers under each picture but the numbers shown in the comments column of the main page still are high. What am I doing wrong?

Chuck S · September 30th, 2006, 07:48 PM

Did you wait for your cache to reset?

Try turning off the cache in global options view the index then turn it back on.

catnipmercer · September 30th, 2006, 07:59 PM

Ok, got it now. Thank you.

Linda

catnipmercer · September 30th, 2006, 08:08 PM

Thank you just doesn't seem enough.. I really appreciate the time you spent and your quick replies.

MEGA THANK YOUS!

Linda

Chuck S · September 30th, 2006, 08:09 PM

Have a great weekend

skidpics · October 22nd, 2008, 10:16 PM

Quote:

Originally Posted by Michael P

I wish I had a quick fix for you - it's something we could look to add in the future; but other than running an SQL statement manually in phpmyadmin, I'm not sure how else to tell you to proceed.

Hmm - posted in 2002 - When will a feature like this be added? Removal of Comments and/or admin option to bulk 'Action' comments??

Chuck S · October 23rd, 2008, 07:17 AM

Well this is posted in 2006 not 2002 and this is a perfect example of when I tell people if they have suggestions post them in the suggestions forum.

You can not post in a support forum itself and expect the developer to find anything there thats why we have the suggestions forum where he can find ideas customers wish.

skidpics · October 23rd, 2008, 07:38 AM

I will browse the suggestion, but I am sure it has been added. Michael has a lot on his place though, so sql editing is pretty simple also..

Chuck S · October 23rd, 2008, 07:42 AM

I am sure you will not find it. Probally 90% of things people throw out daily they never post in suggestions forum. Thats why I always post to them when I see posts nowadays