Author Topic: Thousands of Spam Accounts in Drupal Synced to Civi via Manual Sync (Read 799 times)

zkrebs · April 23, 2012, 09:53:09 am

I did not realize the extent of our spam problem and synced over about 8k new spam records as civi contacts. Fortunately I now have CAPTCHA and Spambot on the Drupal site so new spam won't be an issue. However, I want to be able to manually run this sync users <->contacts from time to time, so I need to get this in order.

What is the most effective way to identify and delete Spam Drupal accounts and now the associated Civi records? Any best practice recommendations are appreciated.

Looks like Spambot will run cron to identify spam records, so that might capture some of them. Then, it marks them as spam somewhere I am assuming in the DB. So, once I know that, what else? Perhaps I could update a Drupal profile field or something for all the spam records, and then do a mass delete.

Jason W · September 25, 2012, 09:58:26 am

Hello zkrebs,

I looked into a couple of things, on the demo site, and I think I've found a way to remove the CiviCRM accounts. Go to advanced search and scroll down to Change Log. Select Added and set the date range to the day that the spam accounts were added. After the search, select all records, open the drop down menu and select delete permanently.

I'm not certain how much memory this might tie up, so you may need to delete them in batches.

Hope this helps!
Cheers,
Jason

CiviCRM Community Forums (archive)

News:

Author Topic: Thousands of Spam Accounts in Drupal Synced to Civi via Manual Sync (Read 799 times)

zkrebs

Thousands of Spam Accounts in Drupal Synced to Civi via Manual Sync

Jason W

Re: Thousands of Spam Accounts in Drupal Synced to Civi via Manual Sync