Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Manually delete applicants?

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!

Comments

  • Options
    R_JR_J Ex-Fanboy Munich Admin

    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

  • Options
    peregrineperegrine MVP
    edited December 2013

    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

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options

    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?

  • Options

    @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

    There was an error rendering this rich post.

  • Options
    peregrineperegrine MVP
    edited December 2013

    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

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • Options
    hgtonighthgtonight ∞ · New Moderator

    Bulk Edit does nothing on the applicants screen.

    I would suggest going with cleanser by peregrine.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • Options

    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!

  • Options
    peregrineperegrine MVP
    edited December 2013

    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.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

Sign In or Register to comment.