1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Spam Cleaner Not Doing Anything When Attempting To Delete All User Activity

Discussion in 'Troubleshooting and Problems' started by Rambro, May 2, 2014.

  1. Rambro

    Rambro Well-Known Member

    So I ran into this problem today where the spam cleaner doesn't seem to be doing anything. I had a user ask me to delete his user name and all of his posts. I figured the easiest way was to use the cleaner. I set the maximum options at 10,000 for all three options, and then went in and clicked on spam in one of his posts. All boxes present are checked. I hit 'clean up', the progress bar runs, and then it just stops and nothing changes. No activity is present in the log. I've tried this now in two separate browsers and I can't get it to work. Suggestions?

    Also, as a related question, how can I get the cleaner to work on posts of this user that have been quoted?
  2. Mick

    Mick Member

    Witch Version of XF are you running tho?

    Please note that the spamcleaner might be a bit buggy when you are using XF 1.1.*

    I saw that the "Delete posts" addon also didn't work for you. If you are using any outdated version of XF, please considder updating to atleast 1.2.* :D
  3. Rambro

    Rambro Well-Known Member

  4. Mick

    Mick Member

    You can also take a try using the unbuild health checker tools.. These are located in the "Tools" Section of the AdminCP

    If you are using a CDN like CloudFlare you might want to change the caching level. CDN's caching sometimes ****s with "Floating" menu's and other "non-static" content
  5. Rambro

    Rambro Well-Known Member

    Not using a CDN.
  6. Chris D

    Chris D XenForo Developer Staff Member

    How many posts does he have?

    If he has a lot of content it's very possible that you are hitting various server limits, such as max_execution_time when processing him. Maybe there are some PHP or Apache logs that may have logged more information assuming nothing is being logged in the XF Server Error log?

    Spam cleaner isn't purpose built for clearing thousand of messages. Typically a spammer would be cleaned after tens of messages rather than hundreds or thousands.

    One option would be to change his name to something like "Deleted User" and then delete him from the Admin CP. All of his content will now have the name "Deleted User" but the content will still exist.

    Another option would be to delete his posts using a database query.

    To answer your final question, there is no way to delete content where he has been quoted.
  7. Rambro

    Rambro Well-Known Member

    About 4,600. No server error logs. Not sure how to check the php/ apache logs.

    It's weird the way the cleaner runs. It just sort of gives up mid attempt.

    Unfortunately, the reason he wants to be deleted is privacy related so deleting the content of the posts is essential to the process.

    Oddly, I tried Andy's delete posts addon and it brought backs errors as well. Kind of wonder if there's a larger issue at play.

    I'd be willing to give the database query a go but have absolutely no idea how to do that.
  8. RoldanLT

    RoldanLT Well-Known Member

    I experience this lately and it's server resource related.
    You current server can't handle that transaction, 10K of post to delete?
  9. Mick

    Mick Member

    Are you sure your webserver meets the (additional) system requerements for XenForo

    Please check the php information of your webserver
  10. Rambro

    Rambro Well-Known Member

    Database server
    • Server: Localhost via UNIX socket
    • Server type: MySQL
    • Server version: 5.5.34-cll-lve - MySQL Community Server (GPL)
    • Protocol version: 10
    • User: dressedw@localhost
    • Server charset: UTF-8 Unicode (utf8)
    Web server
    • cpsrvd
    • Database client version: libmysql - 5.0.96
    • PHP extension: mysqli [​IMG]

    My current version of pHp listed in cPanel is 5.3
  11. Mick

    Mick Member

    Well, that should work by base..

    Since when is this problem occuring? If it never worked before you might want to contact your Webhost for possible error logs or weard perfomence peaks during the cleaning progress. If the Spamcleaner does randomly stop without a error you might got a chance that your webhost can help you further (Normaly this kind of behaviour should give errors, possible not logged but it should atleast being displayed)
  12. Rambro

    Rambro Well-Known Member

    I setup a ticket with my host. Will report back.
  13. Mick

    Mick Member

  14. Mick

    Mick Member

    You can also check a detailed server information (php + extensions) using a php info code

    to do so please follow these steps:

    1. Create a php file in the domains root directory called "phpinfo.php"
    2. Edit the file and add the following line to it
    <? phpinfo(); ?>
    3. Browse to <yourdomain>/phpinfo.php and see the results.

    If you are not acquainted to the requerements of XF you can also send me a link of the phpinfo file :D
  15. Chris D

    Chris D XenForo Developer Staff Member

    It's really not going to be a requirements issue.

    XenForo can't expect every server to be able to handle the mass deletion of thousands of records in one transaction.

    That would struggle on even the most advanced server configurations.
  16. Mick

    Mick Member

    I've got no single problem with it. I was targeting @ Apache extensions such as Pagemod witch may **** with proccessing big requests..
  17. Tracy Perry

    Tracy Perry Well-Known Member

    Actually, all you have to do with the 1.3 is go to yourdomain.com/admin.php?tools/phpinfo
  18. Mick

    Mick Member

    Yeah right, forget about that :) XF has phpinfo included #Smart XD
    Last edited: May 3, 2014
  19. Brogan

    Brogan XenForo Moderator Staff Member

    That link has been there since the first release.
  20. Rambro

    Rambro Well-Known Member

    Is there a specific bit of info you're looking for there? The whole PHP output is pretty long.

    Ok, how about deleting them in small batches then?

Share This Page