Manually delete applicants?

rhino777

So I wasn't paying attention the couple of weeks and musta got hella spammed because now I have 7,000+ applicants and I'm guessing that's why I'm getting out of memory errors. Is there anyway to go in the backend and manually delete all those? It won't even load through the dashboard interface. Thanks!

R_J

Try that plugin: http://vanillaforums.org/addon/bulkedit-plugin
I have never used it, but as far as I know it was might for exactly that purpose

peregrine

there is no real clean way to delete applicants manually without a plugin from the backend, unless you remove them from al tables concerned,

better to use a plugin that was designed to do exactly this...

see this comment and associated one in the the thread.

http://vanillaforums.org/discussion/comment/196127/#Comment_196127

since this is a repeat of chanux's earlier question that was closed, I send you there since it answers your question,

which is a duplicate of chanux's

rhino777

The plugin looks good and I will certainly use it in the future. The problem is the forum won't load at all. I get a "Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 19456 bytes) in /var/www/bbs/library/vendors/Smarty-2.6.25/libs/Smarty.class.php on line 1663" error so I can't get to the dashboard to get to the plugin. Any other ideas?

UnderDog

@rhino777 said:
I get a "Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 19456 bytes)

Your server needs to allocate more memory. That's a setting in php.ini

peregrine

rhino777 said:

The plugin looks good

which plugin are you attempting to use? ambiguity gets us nowhere.

If you are trying to delete applicants who haven't made discussions or comments and you have a memory error that can't be fixed by allocating more memory via php.ini or an
ini_set('memory_limit', '128M'). It looks like you currently have 32M

(because of some other problem looping and exhausting memory)

do not attempt to go to user screen in dashboard or click on applicants.

I don't know about bulkedit - it may very well work deleting thousands of applicants.

I do know that people have deleted up to 18000 spam applicants successfully with cleanser.

download cleanser - install in folder.

• set all your plugins to FALSE except for HtmlLawed and Cleanser
• via config.php enabled statements.
• don't touch HtmlLawed

• and set Cleanser to TRUE

• then goto - dashboard/settings/cleanser

hgtonight

Bulk Edit does nothing on the applicants screen.

I would suggest going with cleanser by peregrine.

rhino777

Ok I upped my php memory and got the forums to load.

I was talking about the cleanser plugin...sorry.

Pretty sure I followed the directions correctly but I get "Fatal Error in Gdn_Database.Query();

Unknown column 'u.UpdateIPAddress' in 'field list'" when I try to submit for a cleanser list.

I'm still on Vanilla 2.0.16......do I need to upgrade for the plugin to work?

Thanks again!

peregrine

I would upgrade vanilla if it were me to 2.0.18.9

I never tested it on the version you have. You could comb look in the user table and see what columns exist for ip address and change every entry in the plugin everywhere to the name of the ip column that exists in your user table. but it you might as well upgrade vanilla to 2.0.18.9 for security sake.

one more reason for OP to always mention the exact version of vanilla in your opening discussion whether you think it pertains or not! It will save you days of replies that go nowhere, because assumptions about vanilla version are often incorrect by responders who need to guess or use clairvoyance.