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: Gallery overrun by spammers  (Read 2046 times)

0 Members and 1 Guest are viewing this topic.

deeblite

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Gallery overrun by spammers
« on: June 08, 2012, 04:17:27 am »

Hi there everyone.  This is my sob story. 

I have recently inherited the role of "web guy" for my anime club.   Years ago, the club had a Coppermine set up, but the didn't have it locked down properly, and it started to be overrun by spammers.  Rather than lock things down properly, they decided to just abandon it- but they didn't uninstall it, so it's still there, and it has the only copy of about 500 of our old photos. (Yeah yeah, I know).

So I came in, and saw this situation.  I saw that the thing was STILL getting new spammer user signups, several years after it had been abandoned. I saw that it was running a VERY old version of coppermine.   I went in, got the thing locked down so no new users could sign up (so at least the hemmoraghing has stopped!), got it upgraded to the current version, and started going through the user list to clean out the spammers, hoping to salvage the good stuff.  I actually DID manage to get all of the spammers FILES cleared out.   

Then I looked at the sheer number of spammers and spam comments still in there, and wept.   The user manager has over 1,200 pages of users- and only the first 2 of them are legit users.   It will probably take me somewhere in the vicinity of 100 hours to get those all deleted.  There are still tens of thousands of spam comments I need to get rid of...

So what I am asking of this forum is this-
What should I do? 

Is there a faster way to clean out the spammers than just using the user manager?  Some kind of plugin, or something? 

Is there a way to just extract the photos, start over, and re-upload them to a fresh installation? At this point, the only files left in the gallery DO seem to be ours..

Should I just scrap the whole thing and call the old photos a loss, tell the rest of the group to chalk it up as a lesson learned?

Your help and suggestions would be greatly appreciated.   
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Gallery overrun by spammers
« Reply #1 on: June 08, 2012, 10:03:32 am »

You can batch-delete user accounts and comments with a simple SQL query. You can also just copy the albums directory to a fresh installation. It's your decision. I can help you with the SQL query if you want to keep your current gallery, but I'd need some more information.
Logged

deeblite

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Gallery overrun by spammers
« Reply #2 on: June 08, 2012, 04:46:23 pm »

Thank you, rather than messing around with the SQL I think I'll just copy the albums folder over.   

Just to make sure I'm understanding correctly- The new install will automatically see the old galleries, but not the comments?
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Gallery overrun by spammers
« Reply #3 on: June 08, 2012, 05:37:04 pm »

The new gallery will see nothing automatically. After you copied the albums directory to your new gallery, you can either batch-add the pictures to your albums (which you need to create in advance) or try the MassImport plugin, which will create the category/albums structure automatically according to your directory structure.
Logged

deeblite

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Gallery overrun by spammers
« Reply #4 on: June 08, 2012, 05:51:06 pm »

Ok, thank you very much.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.