+ Reply to Thread
Results 1 to 42 of 42

Spam, spam, spam, spam...wonderful spam

  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Spam, spam, spam, spam...wonderful spam

    We seem to be undergoing a sustained attack by test0ster0ne-peddling spammers... Currently 6/21 posts on the first page of new posts are spam.

    Is there a simple way to increase the size of the pool of of those select individuals who can kill these threads and bar the spammers? Is the active admin/moderator pool large enough?
    Last edited by Glenn Kennedy; 02-03-2018 at 06:11 AM.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Spam, spam, spam, spam...wonderful spam

    Or is there a way to hide them from feed?

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    If you hide them, we can't deal with them.

    Honestly, it's nothing. Another forum I frequent (not as a moderator) had three pages of it this morning, and that's a daily event.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    Are there enough moderators to cope with the SPAM we get? Yes. That is not to say that there should not be more moderators! Please bear in mind that it's Saturday, and whilst I'm at work, most in the UK are probably pottering or contemplating brunch, and our US cousins will still be a-bed.

  5. #5
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Spam, spam, spam, spam...wonderful spam

    There a tool to move threads. In this case even there is no need to indicate it.
    i'd recommend to name a new subforum as Excel diversification

  6. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Spam, spam, spam, spam...wonderful spam

    Whenever spam threads are spotted or reported we delete them and ban the perpetrators as quickly as we can, please keep reporting any spam posts you find

    We are investigating whether we can do more, e.g. don't allow new users to post links
    Audere est facere

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    Quote Originally Posted by tim201110 View Post
    There a tool to move threads. In this case even there is no need to indicate it.
    i'd recommend to name a new subforum as Excel diversification
    I don't know what you are trying to suggest, Tim, but spammers need banning, not a forum section all of their own.

  8. #8
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Spam, spam, spam, spam...wonderful spam

    This post was originally posted by me in the moderators' forum back in May 2014, after a particularly prolonged spell of fitted kitchen spam being posted that some of you may remember.
    The subject matter of the spam has since moved on somewhat, but the relevance of this post is the same as ever. But come on, it's nearly four years ago now, and we're still no nearer despite countless suggestions and requests.

    Quote Originally Posted by dominicb View Post
    OK. There are new measures in place to stop spam getting through, and it clearly isn't working.
    Apparently, we aren't the only forum suffering from the attentions of the kitchen fitter from hell and all his mates, so clearly it isn't the TT's fault ('cos they seem to get a fair amount of flak over things like this). Why not change the way it's dealt with once it gets through and not focus on stopping it at source.

    Can a "Spam" sub forum not be set up? It's not as daft as it sounds and some other forums (fora?) have them. Allow respected members (gurus etc upwards) to be able to move spam there as and when they find it, rather than having to report it. A mod / admin then have a mass clear-out (delete and ban) once a week. Doing it this way would be far speedier than doing it on the ad-hoc basis going across different forums (fora?) the way it has to be done at the moment. Also it would save respected members of the forum having to report the issues and give them a little extra responsibility as well.

    Thoughts

    DominicB

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Spam, spam, spam, spam...wonderful spam

    Tim/Dominic's suggestion sounds sensible. There are plenty of us who'd be prepared spend a bit of time to help keep the place tidier....

  10. #10
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Spam, spam, spam, spam...wonderful spam

    my 2 cents: without: wait 60 secs

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    And what exactly does that mean, Sandy?

  12. #12
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Spam, spam, spam, spam...wonderful spam

    If I report 1st spam then next I see: wait 60 seconds.This is wasting of my time if there is more than 1 spam

    edit:

    60seconds.jpg
    Last edited by sandy666; 02-05-2018 at 02:07 AM.

  13. #13
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Spam, spam, spam, spam...wonderful spam

    On this issue I concure with sandy666.
    When I'm at work at night and I have a few minutes to spare I tend to race to my laptop to see what's going on.
    A few nights ago I spotted 3 or 4 spam threads which I could have delt with in 10 seconds. Now it almost took me 5 minutes just to report them.
    Therefore Dominic's suggestion doesn't sound that silly at all.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    Something went wrong there, Rudi - there are no newly reported posts by you.

  15. #15
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Spam, spam, spam, spam...wonderful spam

    @post #12
    If I am too fast i see vbBulletin Message. Every time I need wait...

  16. #16
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    If there are several SPAM posts, just report one and say how many others you have seen in your report - we see them, too, so all the report post feature does is draw our attention to them. In fact for us, having multiple reported posts is a bit of a pain, as each of them has to be marked solved separately - there is no batch function.

  17. #17
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Spam, spam, spam, spam...wonderful spam


  18. #18
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Spam, spam, spam, spam...wonderful spam

    Click report post to right of add reputation button. If no button visible, it's already been reported.

  19. #19
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Spam, spam, spam, spam...wonderful spam

    Большое Спасибо!

  20. #20
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Spam, spam, spam, spam...wonderful spam

    Tá failte romhat.

  21. #21
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Spam, spam, spam, spam...wonderful spam

    I always wonder how people live so close and still they are so different, even in language.

  22. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    Not that surprising really when you consider the rate at which language is susceptible to change.

  23. #23
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Spam, spam, spam, spam...wonderful spam

    Lots of spam again recently. usually appears round 0800 Western European time

  24. #24
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Spam, spam, spam, spam...wonderful spam

    Recently introduced restrictions on posting hyperlinks may help a bit. I am coming round to the view that a sub-forum, visible only to a wider group (suggest Guru Mod and Admin) should be set up. Spam posts should be moveable to that sub-forum by anyone in that Group. The spam pattern xan be checked. Do names recur, or are they single-use. If the latter, maybe no need to ban 'em.

    Advantages. A larger group of us policing this would lead to the more rapid removal of spam from general view. If they're humans, the spammers may be put off by the rapid disappearance of their efforts.


    If they're machines, could a Captur be included in either new subscriptions or logins?

    Disadvantages????

  25. #25
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Spam, spam, spam, spam...wonderful spam

    Glenn that exact suggestion is currently being discussed, where all new members with be "quarantined" for their 1st post, in a sub-forum. These would then be audited by mod.admin and either banned or approved
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  26. #26
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Spam, spam, spam, spam...wonderful spam

    Good luck....

  27. #27
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Spam, spam, spam, spam...wonderful spam

    Has the possibility of having the first post from a new member approved by mod/admin before publishing already been discussed? ( especially if it contains any link whatsoever)
    As there seem to be mods/admin from different parts of the world on this forum, approval shouldn't delay answering possibilities for long
    Are spammers banned on username or IP?

  28. #28
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Spam, spam, spam, spam...wonderful spam

    Quote Originally Posted by Pepe Le Mokko View Post
    Has the possibility of having the first post from a new member approved by mod/admin before publishing already been discussed? ( especially if it contains any link whatsoever)
    As there seem to be mods/admin from different parts of the world on this forum, approval shouldn't delay answering possibilities for long
    Are spammers banned on username or IP?
    That is pretty much what I meant in post #25

  29. #29
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Spam, spam, spam, spam...wonderful spam

    Ford, I'm afraid this could cause a delay for OP's in getting answers since I assume that there are times that no admin or mod is present at the forum.
    Therefore I'd rather support Glenn's idea while there's always on or the other Guru present around the clock.
    Also the 60 sec. delay is a pain in reporting spam posts while I noticed 2 just a while ago that took me approx. 3 min. to report while it could be done in 20 sec.
    approval shouldn't delay answering possibilities for long
    I tend to disagree because when I report spam at night (it's now 9:20 AM here) it sometimes stays there more then several hours before removal.
    Last edited by bakerman2; 02-27-2018 at 04:17 AM.

  30. #30
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Spam, spam, spam, spam...wonderful spam

    There probably wont ever be a "right" answer, and atm, its just under discussion.

    Also, only mods/admin have the ability to ban/delete threads

  31. #31
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Spam, spam, spam, spam...wonderful spam

    Quote Originally Posted by Pepe Le Mokko View Post
    Are spammers banned on username or IP?
    Pepe, users are banned by username only.

    It has been discussed (multiple times) to ban by IP level, but ultimately, it was decided that this way would introduce too much "collateral damage", with many innocent users ending up locked out as a result.
    I dare say any spamming bot (or person, if that's the case, but I would doubt it) already has its originating IP address masked through a VPN or something similar?

    DominicB

  32. #32
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Spam, spam, spam, spam...wonderful spam

    Quote Originally Posted by AliGW View Post
    If there are several SPAM posts, just report one and say how many others you have seen in your report
    Trouble is, a lot of the spam is hit & run, with the miscreants making just one spam post per username, then creating another username to make another, similar, spam post, and so on.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  33. #33
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Spam, spam, spam, spam...wonderful spam

    You are missing my point, I think, Paul, so I probably didn't explain it well enough. What tends to happen is we get a run of one-off SPAM posts, probably posted by the same person or group of people. When this happens (say seven or eight within a couple of minutes), we only really need alerting to one of them - the rest are easy to spot if one has been reported and the others are referred to in that report. Remember, you see them, so why wouldn't we?

    The reason that so many reported posts is a minor problem is that, on top of dealing with the SPAM posts, we also have to mark each and every reported post as solved, as this can't be done as a bulk operation, so it more than doubles the time we have to spend dealing with the problem. Plus it takes you a long time to report them all!

    I hope this better explains my point.

  34. #34
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Spam, spam, spam, spam...wonderful spam

    If they are one-offs, why not simply move them to a sub- forum invisible to general users and then simply forget about them??

  35. #35
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Spam, spam, spam, spam...wonderful spam

    I think that plugins can be used, like AutoIt Anti-Spam or something similar. Also Project Honey Pot can be a good option.

  36. #36
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Spam, spam, spam, spam...wonderful spam

    Quote Originally Posted by Glenn Kennedy View Post
    If they are one-offs, why not simply move them to a sub- forum invisible to general users and then simply forget about them??
    Because that doesn't stop them coming back and posting more spam under the same username.

  37. #37
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Spam, spam, spam, spam...wonderful spam

    The key word in my comment was one-offs. If they are one-offs, they probably don't even record their passwords.... However, if the spam is moved rapidly (and I mean rapidly) moved to a sub-forum where the spammer (and the normal user) can no longer see/access them... where's the issue? No need to mark as solved, no need to ban the spammer, just ignore them. they'll get bored and pi$$ off (maybe).

  38. #38
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Spam, spam, spam, spam...wonderful spam

    Dont most spam pots post in the first forum they find?

    It could be worth creating a new forum group which is placed at the top of the forum list but named so users know not to bother with it.

    Chances are most of the spam will be posted in there and not cause an issue to the general users. Mods can then just work through that board when they get a chance rather than having to react to the posting.
    If someone has helped you then please add to their Reputation

  39. #39
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Spam, spam, spam, spam...wonderful spam

    Quote Originally Posted by Glenn Kennedy View Post
    The key word in my comment was one-offs. If they are one-offs
    You seem to be missing my point that you don't know they're on-offs unless they never post again...
    Besides which, what you're suggesting is actually more work than banning them from the outset.

  40. #40
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Spam, spam, spam, spam...wonderful spam

    Quote Originally Posted by pjwhitfield View Post
    Dont most spam pots post in the first forum they find?
    Some of those responsible for the recent spate go through multiple forums, making a spam post in each. Some do that under the one username; others seem to change username for each post.

  41. #41
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Spam, spam, spam, spam...wonderful spam

    There does seem to be a spate of them now and then. I logged in and banned 6 or 7 spam posts (different ID'), answered a few Q's, read this thread, and I updated the thread list, there were 4 more.

    To be honest, I dont even bother to check IP's or really even names now, I just click and ban

  42. #42
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Spam, spam, spam, spam...wonderful spam

    Lots of spamming going on. Spammers must love this site...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Spam spam spam spam--aren't there any automated preventive measures we can take?
    By 6StringJazzer in forum Suggestions for Improvement
    Replies: 34
    Last Post: 01-02-2018, 03:43 AM
  2. [SOLVED] Re: SPAM
    By Moron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2005, 09:06 AM
  3. [SOLVED] Re:SPAM
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1