#metabrainz

/

      • alastairp
        but if you are only interested in the mood, you could just download the highlevel json archive (which is much smaller)
      • 2016-03-10 07018, 2016

      • alastairp
        because the mood information is encoded in these files
      • 2016-03-10 07052, 2016

      • harshul1610 has quit
      • 2016-03-10 07013, 2016

      • armalcolite has quit
      • 2016-03-10 07025, 2016

      • rahulr has quit
      • 2016-03-10 07049, 2016

      • for15pounds has quit
      • 2016-03-10 07016, 2016

      • D4RK-PH0ENiX has quit
      • 2016-03-10 07058, 2016

      • CJ_
        Freso, I was just giving alastairp a hard time. :)
      • 2016-03-10 07021, 2016

      • alastairp
        wait. why did everyone take that discussion so seriously?
      • 2016-03-10 07026, 2016

      • CJ_
        alastairp, I have no idea.
      • 2016-03-10 07023, 2016

      • D4RK-PH0ENiX joined the channel
      • 2016-03-10 07052, 2016

      • Skeebadoo joined the channel
      • 2016-03-10 07057, 2016

      • Skeebadoo
        haha oh wow
      • 2016-03-10 07009, 2016

      • Skeebadoo
        I wanted to check how many people actually filled out my city
      • 2016-03-10 07010, 2016

      • Skeebadoo
      • 2016-03-10 07019, 2016

      • Skeebadoo
        most of these are some ad spam bots
      • 2016-03-10 07020, 2016

      • Skeebadoo
      • 2016-03-10 07022, 2016

      • Skeebadoo
        some clinic
      • 2016-03-10 07050, 2016

      • Skeebadoo
      • 2016-03-10 07051, 2016

      • alastairp
        "For the first time, ISRC codes – supplied directly from record companies across the globe – will be publicly accessible and searchable.” — http://www.musicbusinessworldwide.com/soundexchan…
      • 2016-03-10 07052, 2016

      • Skeebadoo
        party arranging
      • 2016-03-10 07057, 2016

      • alastairp
        reosarevok: ^^
      • 2016-03-10 07058, 2016

      • Skeebadoo
      • 2016-03-10 07004, 2016

      • Skeebadoo
        jesus christ
      • 2016-03-10 07005, 2016

      • alastairp
        Skeebadoo: thanks. reosarevok can delete them
      • 2016-03-10 07008, 2016

      • Freso
        Skeebadoo: Please report spam accounts using the "Report editor" link.
      • 2016-03-10 07011, 2016

      • Freso can too
      • 2016-03-10 07014, 2016

      • reosarevok
        Sigh
      • 2016-03-10 07017, 2016

      • Skeebadoo
        yeah but there's so many!
      • 2016-03-10 07021, 2016

      • Skeebadoo
        it looks automated
      • 2016-03-10 07037, 2016

      • Freso
        chirlu: Had a proposal up not long ago.
      • 2016-03-10 07039, 2016

      • Freso checks mail
      • 2016-03-10 07049, 2016

      • Freso
        *chirlu had
      • 2016-03-10 07058, 2016

      • reosarevok
        I guess it was useful after all to show the nearby users :p
      • 2016-03-10 07012, 2016

      • Freso
      • 2016-03-10 07021, 2016

      • Freso
        Skeebadoo: ^ feel free to comment. :)
      • 2016-03-10 07045, 2016

      • Freso
        reosarevok: ^ perhaps post to Discourse about it?
      • 2016-03-10 07009, 2016

      • reosarevok
        "Any ideas what to do with spam?" or "Please report spam users!" or both?
      • 2016-03-10 07009, 2016

      • Skeebadoo
        I'll read up the ticket comments
      • 2016-03-10 07041, 2016

      • Skeebadoo
        And I'll report the ones from my city, but this looks like a flood, not anything to handle manually
      • 2016-03-10 07045, 2016

      • Freso
        reosarevok: Both. :)
      • 2016-03-10 07024, 2016

      • outsidecontext has quit
      • 2016-03-10 07025, 2016

      • chirlu
        I’ve been hesitant myself to use the report feature for profile-only spammers, but if you (account admins) like to be spammed (with reports), I can do that …
      • 2016-03-10 07006, 2016

      • chirlu
        Oh … search server restart, it seems.
      • 2016-03-10 07041, 2016

      • Freso
      • 2016-03-10 07043, 2016

      • Freso sighs
      • 2016-03-10 07008, 2016

      • Freso
        reosarevok: Do you have a template I can copy for writing to them and tell them that user profile != artist entry?
      • 2016-03-10 07018, 2016

      • reosarevok
        Not really
      • 2016-03-10 07057, 2016

      • Freso will look at old support@ answers
      • 2016-03-10 07008, 2016

      • Freso
        !!
      • 2016-03-10 07014, 2016

      • reosarevok
        chirlu: if you're going to specifically go around looking for spammers it might make sense to just give you the permission to remove them. But if you just stumble upon some, reporting seems fine
      • 2016-03-10 07018, 2016

      • Freso
        There *was* one spam profile "in" Copenhagen!
      • 2016-03-10 07037, 2016

      • chirlu
        Well, it’s very easy to stumble over dozens of them.
      • 2016-03-10 07040, 2016

      • Freso
      • 2016-03-10 07006, 2016

      • reosarevok
        Basically, if you see them it's reasonably likely others might, so they look bad, so we should remove them :p
      • 2016-03-10 07018, 2016

      • chirlu
        If I happen to see blatantspammer17, often there are blatantspammer01, blatantspammer02, … also nearby.
      • 2016-03-10 07021, 2016

      • Freso
        Huh.
      • 2016-03-10 07053, 2016

      • Skeebadoo
        It's easier to pick out the real accounts in Wrocław area
      • 2016-03-10 07056, 2016

      • Skeebadoo
        than spam ones :P
      • 2016-03-10 07016, 2016

      • Skeebadoo
        Basically every account w/o any edits and with a link and short bio is a spam account
      • 2016-03-10 07021, 2016

      • Freso
        I just went through all the Copenhagen users, and it seems only one was a spam profile.
      • 2016-03-10 07019, 2016

      • Hobbyboy has quit
      • 2016-03-10 07004, 2016

      • Sebastinas has quit
      • 2016-03-10 07017, 2016

      • Sebastinas joined the channel
      • 2016-03-10 07059, 2016

      • chirlu
        reosarevok: Here, 273 spammers for you – https://beta.musicbrainz.org/search?query=cialis&…
      • 2016-03-10 07043, 2016

      • chirlu
      • 2016-03-10 07048, 2016

      • Freso
        Heh.
      • 2016-03-10 07009, 2016

      • jaron joined the channel
      • 2016-03-10 07010, 2016

      • Jormangeud has quit
      • 2016-03-10 07010, 2016

      • Jormangeud joined the channel
      • 2016-03-10 07059, 2016

      • Hobbyboy joined the channel
      • 2016-03-10 07036, 2016

      • Freso
        reosarevok: Are you on a spammer deletion spree incl. the ones having been reported now?
      • 2016-03-10 07050, 2016

      • Freso
        Or should I do the reported ones if you're doing chirlu's searches? :)
      • 2016-03-10 07003, 2016

      • reosarevok
        Freso: I'm killing draconians in Dungeon Crawl #workinghard
      • 2016-03-10 07040, 2016

      • reosarevok
        For stuff where we have over a hundred easily findable spammers, we should probably write some botty thing
      • 2016-03-10 07051, 2016

      • reosarevok
        Or a script for the DB, anyway
      • 2016-03-10 07030, 2016

      • Skeebadoo
        I spammed you with ~40 spam account reports from Wrocław area
      • 2016-03-10 07049, 2016

      • Skeebadoo
        other big cities in Poland don't seem to be affected fortunately :P
      • 2016-03-10 07016, 2016

      • chirlu
      • 2016-03-10 07022, 2016

      • Freso
        Skeebadoo: Yep. Going through them now.
      • 2016-03-10 07040, 2016

      • Freso
        I really wish there was a way to see if people had used the accounts for AcoustID or CB review submissions.
      • 2016-03-10 07000, 2016

      • Freso
        Or anything else which needs an MB login.
      • 2016-03-10 07026, 2016

      • chirlu
        Well, we know it unless they have later revoked the access.
      • 2016-03-10 07041, 2016

      • chirlu
        Spammer with tips how to get rid of spam: https://beta.musicbrainz.org/user/tigerhail42
      • 2016-03-10 07005, 2016

      • Skeebadoo
        lol
      • 2016-03-10 07030, 2016

      • Freso
        chirlu: Well, it isn't exposed anywhere. :)
      • 2016-03-10 07002, 2016

      • ariscop has quit
      • 2016-03-10 07019, 2016

      • Freso
        Oops.
      • 2016-03-10 07021, 2016

      • chirlu
        Right, but that could be changed.
      • 2016-03-10 07022, 2016

      • Freso
        Yep.
      • 2016-03-10 07030, 2016

      • Freso
        Writing up a ticket right now. :)
      • 2016-03-10 07013, 2016

      • ariscop joined the channel
      • 2016-03-10 07033, 2016

      • reosarevok
        Would you automatically show links (or icons that link) to their profiles elsewhere that use oauth?
      • 2016-03-10 07048, 2016

      • Freso
      • 2016-03-10 07051, 2016

      • Freso
        reosarevok: ^
      • 2016-03-10 07044, 2016

      • reosarevok
        Hmm, ok
      • 2016-03-10 07006, 2016

      • reosarevok
        I'd probably also generate icons for other profiles that are shown to every user
      • 2016-03-10 07010, 2016

      • reosarevok
        Or at least logged in user
      • 2016-03-10 07012, 2016

      • reosarevok
        But dunno
      • 2016-03-10 07019, 2016

      • armalcolite joined the channel
      • 2016-03-10 07006, 2016

      • armalcolite_ joined the channel
      • 2016-03-10 07033, 2016

      • armalcolite_ has left the channel
      • 2016-03-10 07019, 2016

      • jesus2099 joined the channel
      • 2016-03-10 07050, 2016

      • Freso
        chirlu: Ah, sorry I missed that mention in your proposal. :)
      • 2016-03-10 07038, 2016

      • chirlu
        Well, it wasn’t very detailed.
      • 2016-03-10 07044, 2016

      • ariscop has quit
      • 2016-03-10 07029, 2016

      • Freso
        I do like the idea though.
      • 2016-03-10 07046, 2016

      • reosarevok
        Freso: did you remove all the Skeebadoo reports now or should I take over?
      • 2016-03-10 07040, 2016

      • ruaok returns from an outing to the bank
      • 2016-03-10 07029, 2016

      • jaron has quit
      • 2016-03-10 07059, 2016

      • jaron joined the channel
      • 2016-03-10 07004, 2016

      • Freso
        reosarevok: I did them all.
      • 2016-03-10 07017, 2016

      • reosarevok
        :)
      • 2016-03-10 07017, 2016

      • Freso
        Leaving now though, so feel free to take any further ones. :)
      • 2016-03-10 07031, 2016

      • Freso
        bitmap: http://tickets.musicbrainz.org/browse/MBS-8853 ← for the ISEs I've generated. ;)
      • 2016-03-10 07058, 2016

      • Freso
        (I did a quick search and didn't find it to have been previously reported.)
      • 2016-03-10 07011, 2016

      • Freso
        (I may well have been wrong though. Oh well.
      • 2016-03-10 07013, 2016

      • Freso
        Out.)
      • 2016-03-10 07015, 2016

      • armalcolite
        can i edit my draft proposal after submitting it to the https://community.metabrainz.org/c/metabrainz/gso… ?
      • 2016-03-10 07020, 2016

      • Freso
        armalcolite: Yes.
      • 2016-03-10 07030, 2016

      • Freso outz f'realz
      • 2016-03-10 07058, 2016

      • armalcolite
        ok
      • 2016-03-10 07059, 2016

      • rahulr joined the channel
      • 2016-03-10 07047, 2016

      • yeeeargh has quit
      • 2016-03-10 07039, 2016

      • gcilou
        alastairp: do you want the title of each table capitalized, or just keep how it is?
      • 2016-03-10 07020, 2016

      • ruaok
        alastairp: Jen from BigQuery responded and they are only currently setup for batch imports.
      • 2016-03-10 07035, 2016

      • ruaok
        she is, however, open for working out a streaming system, but it will take more "time".
      • 2016-03-10 07042, 2016

      • ruaok
        trying to get "time" quantified.
      • 2016-03-10 07024, 2016

      • CatQuest is glad we're finally removing the spam accounts
      • 2016-03-10 07046, 2016

      • chirlu
        Well, it’s a lot of work to identify and remove 800000 to 900000 spam accounts.
      • 2016-03-10 07021, 2016

      • jesus2099
        wow, that many… (°_° )
      • 2016-03-10 07002, 2016

      • chirlu
        Well, have a look at the number-of-editors timeline – the two steep slopes are >90% spammers.
      • 2016-03-10 07042, 2016

      • gcilou
      • 2016-03-10 07027, 2016

      • ruaok
        clearly our sign-up captcha is doing shit all. can we upgrade to the latest and greatest and see if that improves things?
      • 2016-03-10 07048, 2016

      • zas
        ruaok: couldn't we ask for revalidation of the account if a certain time of inactivity ?
      • 2016-03-10 07058, 2016

      • zas
      • 2016-03-10 07036, 2016

      • ruaok
        works for me.
      • 2016-03-10 07005, 2016

      • CatQuest
        that's no a dumb idea actually
      • 2016-03-10 07017, 2016

      • ruaok
        or even deleting accounts that have been in active for 1 year and have had no activity.
      • 2016-03-10 07044, 2016

      • CatQuest
        maybe more thna a year
      • 2016-03-10 07059, 2016

      • CatQuest would say something like 3-5 years
      • 2016-03-10 07009, 2016

      • CatQuest
        there are procastinators
      • 2016-03-10 07012, 2016

      • CatQuest
        i would know :D
      • 2016-03-10 07019, 2016

      • zas
        yes, this is what i was thinking, after 3 months of inactivity, ask for revalidation, and if not done, ask each 3 months until one year, then delete
      • 2016-03-10 07035, 2016

      • ruaok
        yeah
      • 2016-03-10 07037, 2016

      • CatQuest
        oh yea
      • 2016-03-10 07037, 2016

      • ruaok
        oh, so we've paid for the office space and we're going to sign the lease on monday. exciting!
      • 2016-03-10 07042, 2016

      • CatQuest
        oh yea with "no activity at all" that's not bad. would get rid of "name squatters" too
      • 2016-03-10 07005, 2016

      • zas
        ruaok: i will come for a visit at some point ;)
      • 2016-03-10 07019, 2016

      • CatQuest
        I want to see more pictures!