#metabrainz

/

      • minimal has quit
      • 2025-01-27 02716, 2025

      • Strykar has quit
      • 2025-01-27 02719, 2025

      • Strykar joined the channel
      • 2025-01-27 02758, 2025

      • Strykar has quit
      • 2025-01-27 02756, 2025

      • Strykar joined the channel
      • 2025-01-27 02741, 2025

      • raven0us[m] has quit
      • 2025-01-27 02734, 2025

      • vardhan joined the channel
      • 2025-01-27 02736, 2025

      • vardhan_ joined the channel
      • 2025-01-27 02728, 2025

      • vardhan has quit
      • 2025-01-27 02752, 2025

      • vardhan joined the channel
      • 2025-01-27 02757, 2025

      • lucifer[m] has quit
      • 2025-01-27 02703, 2025

      • snobdiggy292 joined the channel
      • 2025-01-27 02744, 2025

      • vardhan has quit
      • 2025-01-27 02703, 2025

      • vardhan_ has quit
      • 2025-01-27 02701, 2025

      • BrainzGit
        [listenbrainz-server] 14granth23 opened pull request #3151 (03master…LB-1722--Part-B-Making-page-more-discoverable): LB-1722: Part B, making the link listens page more discoverable. https://github.com/metabrainz/listenbrainz-server…
      • 2025-01-27 02730, 2025

      • elkiensad[m] has quit
      • 2025-01-27 02737, 2025

      • snobdiggy292 has quit
      • 2025-01-27 02749, 2025

      • monkey[m]
        Jigen (IRC): As you mentioned, there is a mismatch between the way we calculate flairs activation in LB and the way we display the time remaining in the settings page (using the MeB nag-check [https://metabrainz.org/donations/nag-check?editor…]
      • 2025-01-27 02749, 2025

      • monkey[m]
        I'm opening a ticket for that
      • 2025-01-27 02755, 2025

      • monkey[m]
        LB-1729
      • 2025-01-27 02757, 2025

      • BrainzBot
        LB-1729: Flairs settings shows incorrect time remaining https://tickets.metabrainz.org/browse/LB-1729
      • 2025-01-27 02717, 2025

      • suvid[m] joined the channel
      • 2025-01-27 02718, 2025

      • suvid[m]
        <monkey[m]> "suvid: Yes, the way to update..." <- Hi monkey... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/gaUykRwowMXfsodFERELvVWu>)
      • 2025-01-27 02718, 2025

      • suvid[m]
        * Hi monkey... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/ksdSrCVWLMooQnSwAkNafOtD>)
      • 2025-01-27 02724, 2025

      • suvid[m]
        * Hi monkey... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/cieJsWQsjoJkkUVcQbpkSEYs>)
      • 2025-01-27 02743, 2025

      • monkey[m]
        No worries, let me explain
      • 2025-01-27 02724, 2025

      • suvid[m]
        * Hi monkey... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/dynfXKheAPfDThTsNRvXsbgN>)
      • 2025-01-27 02726, 2025

      • monkey[m]
        To run via docker, you're going to log in to the web container which contains the update file and the psql CLI.
      • 2025-01-27 02726, 2025

      • monkey[m]
        The commend for that is `./develop.sh run -it web bash`.
      • 2025-01-27 02726, 2025

      • monkey[m]
        To run the psql command inside the container: `psql -h lb_db -d listenbrainz -U listenbrainz -f admin/sql/updates/name-of-your-file`
      • 2025-01-27 02739, 2025

      • monkey[m]
        password will also be 'listenbrainz'
      • 2025-01-27 02714, 2025

      • monkey[m]
        -h is for host (in this case the name of the service, translated automatically by docker), -d is to say which database the command applies to, -U is username, and -f is to point to a file (instead of running a command directly for example)
      • 2025-01-27 02700, 2025

      • suvid[m]
        thanks it worked
      • 2025-01-27 02714, 2025

      • suvid[m]
        after running the update script it just displayed ALTER TYPE
      • 2025-01-27 02720, 2025

      • suvid[m]
        i'm assuming that it was succesful
      • 2025-01-27 02734, 2025

      • monkey[m]
        Yes
      • 2025-01-27 02740, 2025

      • suvid[m]
        but i still get 500 error :(
      • 2025-01-27 02750, 2025

      • suvid[m]
        fixed some things as they were giving error messages
      • 2025-01-27 02754, 2025

      • suvid[m]
        but now no error
      • 2025-01-27 02755, 2025

      • monkey[m]
        Then it might be another issue :)
      • 2025-01-27 02756, 2025

      • suvid[m]
        only 500
      • 2025-01-27 02727, 2025

      • suvid[m]
        cant figure out as there's literally no error message :(
      • 2025-01-27 02732, 2025

      • suvid[m]
        lemme commit my code till now to the pr
      • 2025-01-27 02744, 2025

      • BrainzGit
        [listenbrainz-server] 14MonkeyDo closed pull request #3138 (03master…fresh-releases-timeline): FreshReleases: show more intermediary dates https://github.com/metabrainz/listenbrainz-server…
      • 2025-01-27 02707, 2025

      • suvid[m]
        oh nvm i think i added type to a wrong table
      • 2025-01-27 02709, 2025

      • suvid[m]
        💀
      • 2025-01-27 02715, 2025

      • monkey[m]
        woops
      • 2025-01-27 02719, 2025

      • suvid[m]
        how do i remove a type
      • 2025-01-27 02730, 2025

      • suvid[m]
        ALTER TYPE hide_user_timeline_event_type_enum ADD VALUE 'thanks' AFTER 'personal_recording_recommendation';
      • 2025-01-27 02730, 2025

      • suvid[m]
        i did this by mistake
      • 2025-01-27 02739, 2025

      • suvid[m]
        had to do for user_timeline_event_type_enum
      • 2025-01-27 02726, 2025

      • monkey[m]
        Indeed
      • 2025-01-27 02744, 2025

      • suvid[m]
        lemme try drop type
      • 2025-01-27 02722, 2025

      • monkey[m]
        suvid: Don't drop the entire type, google how to remove an entry from an enum
      • 2025-01-27 02730, 2025

      • suvid[m]
        ohh ok
      • 2025-01-27 02720, 2025

      • suvid[m]
        there's no way to modify a single value from enum
      • 2025-01-27 02720, 2025

      • suvid[m]
        i'll have to rename enum, create new enum with the name as old enum, apply it to table and then delete the renamed enum 💀
      • 2025-01-27 02732, 2025

      • suvid[m]
        done with most of the part
      • 2025-01-27 02732, 2025

      • suvid[m]
        just dont know which tables i need to apply it to
      • 2025-01-27 02706, 2025

      • suvid[m] uploaded an image: (80KiB) < https://matrix.chatbrainz.org/_matrix/media/v3/download/matrix.org/ddwhTBOwVTatwwJsCtGywuDZ/image.png >
      • 2025-01-27 02715, 2025

      • suvid[m]
        according to chatgpt:
      • 2025-01-27 02718, 2025

      • suvid[m] uploaded an image: (47KiB) < https://matrix.chatbrainz.org/_matrix/media/v3/download/matrix.org/KkHcBdbikmcpgnbnzoMNZqra/image.png >
      • 2025-01-27 02730, 2025

      • suvid[m]
        which table to use for step 3? :(
      • 2025-01-27 02706, 2025

      • suvid[m]
        or should i leave it as it is?
      • 2025-01-27 02710, 2025

      • suvid[m]
        and not do anything
      • 2025-01-27 02725, 2025

      • suvid[m]
        cuz an extra enum type wont matter for now ig
      • 2025-01-27 02752, 2025

      • BrainzGit
        [listenbrainz-server] 14mayhem merged pull request #3144 (03master…LB-1710): LB-1710: Add global stats monitoring endpoint https://github.com/metabrainz/listenbrainz-server…
      • 2025-01-27 02742, 2025

      • mayhem[m] joined the channel
      • 2025-01-27 02742, 2025

      • mayhem[m]
        Bob Swift: shall we pick a meeting time this week to discuss docs? am meeting times for you should work I would guess.
      • 2025-01-27 02722, 2025

      • reosarevok[m] joined the channel
      • 2025-01-27 02722, 2025

      • reosarevok[m]
        bitmap: can you check https://github.com/metabrainz/musicbrainz-server/… and (once some changes are made) https://github.com/metabrainz/musicbrainz-server/… ? The latter I cannot review properly because that site blocks me for some reason
      • 2025-01-27 02722, 2025

      • reosarevok[m]
        But apparently it should work in the US 🤷
      • 2025-01-27 02750, 2025

      • mayhem[m]
        reosarevok: I noticed this last week as well:
      • 2025-01-27 02751, 2025

      • mayhem[m]
      • 2025-01-27 02755, 2025

      • mayhem[m]
        I just reported that user.
      • 2025-01-27 02707, 2025

      • mayhem[m]
        what should we do?
      • 2025-01-27 02727, 2025

      • reosarevok[m]
        I'm missing the context for the "as well"
      • 2025-01-27 02742, 2025

      • reosarevok[m]
        But if someone seems to be gaming the system, we were supposed to ban them IIRC?
      • 2025-01-27 02748, 2025

      • reosarevok[m]
        Let me find the doc
      • 2025-01-27 02711, 2025

      • mayhem[m]
      • 2025-01-27 02719, 2025

      • mayhem[m]
        the top tracks are skewed by this spammer.
      • 2025-01-27 02728, 2025

      • mayhem[m]
        yes, please ban.
      • 2025-01-27 02705, 2025

      • mayhem[m]
        monkey: luciferansh : stats.fm looks interesting -- even if to steal ideas for more stats. :)
      • 2025-01-27 02703, 2025

      • monkey[m]
        Yes I believe aerozol has been referencing it for a couploe of years, some great stats viz
      • 2025-01-27 02714, 2025

      • reosarevok[m]
        mayhem, lucifer: there is no "banned" in LB, right?
      • 2025-01-27 02725, 2025

      • reosarevok[m]
        It's just "delete the profile" or nothing? Or is there something in between?
      • 2025-01-27 02728, 2025

      • mayhem[m]
        supposedly they have 2M paying users. which I kinda doubt, but ok.
      • 2025-01-27 02733, 2025

      • lucifer[m] joined the channel
      • 2025-01-27 02733, 2025

      • lucifer[m]
        nope
      • 2025-01-27 02734, 2025

      • mayhem[m]
        reosarevok[m]: there isn't.
      • 2025-01-27 02742, 2025

      • mayhem[m]
        and in this case, its garbage data.
      • 2025-01-27 02748, 2025

      • mayhem[m]
        so, toss it
      • 2025-01-27 02720, 2025

      • mayhem[m]
        let me know when those two accounts are purged and I'll follow up on the forum
      • 2025-01-27 02741, 2025

      • reosarevok[m]
        Well, at some point they did listen to real music, but yeah
      • 2025-01-27 02719, 2025

      • reosarevok[m]
        Anyway, this works for these users in particular, but you'll want better mechanisms in general
      • 2025-01-27 02750, 2025

      • mayhem[m]
        reosarevok[m]: for pausing someone's account and then be able to unpause it when they show remorse?
      • 2025-01-27 02757, 2025

      • reosarevok[m]
        A way to temporarily stop new listens for example, so that less dodgy users that are still doing something wrong are forced to actually react to our comments
      • 2025-01-27 02713, 2025

      • mayhem[m]
        yeah, makes sense.
      • 2025-01-27 02719, 2025

      • mayhem[m]
        let me make a ticket
      • 2025-01-27 02707, 2025

      • reosarevok[m]
        And ideally we'd have a way to just hide and not use potential spammer records, or at least save a copy just in case
      • 2025-01-27 02721, 2025

      • reosarevok[m]
        Because if we mess up and we just deleted someone's five years of listens, that'd suck
      • 2025-01-27 02749, 2025

      • reosarevok[m]
        Deleted these two in LB, and blocked them in MB
      • 2025-01-27 02756, 2025

      • reosarevok[m]
        I should probably notify the user
      • 2025-01-27 02741, 2025

      • mayhem[m]
      • 2025-01-27 02741, 2025

      • BrainzBot
        LB-1730: Allow admins to "pause" a user's account
      • 2025-01-27 02734, 2025

      • monkey[m]
        Orbital Cannon Activated
      • 2025-01-27 02710, 2025

      • reosarevok[m]
        Looking at reported users, there's several reported (correctly) as sockpuppets but with fairly low usage and which might be legitimate errors. I can contact the users for now, but it would be good to yeah, pause them while we wait for an answer :)
      • 2025-01-27 02730, 2025

      • reosarevok[m]
        And at least one is a case where the user has actually deleted one of the MB accounts, so probably an error
      • 2025-01-27 02755, 2025

      • reosarevok[m]
        But LB does not do anything with that, so both are still sending listens, probably without their knowledge
      • 2025-01-27 02721, 2025

      • reosarevok[m]
        lucifer: please let's make it so deleting a user deletes it automatically in LB too, this is problematic :)
      • 2025-01-27 02701, 2025

      • reosarevok[m]
        I guess we want real deletion there, not just Deleted Editor #Whatever
      • 2025-01-27 02708, 2025

      • reosarevok[m]
        But that's for the LB team to decide
      • 2025-01-27 02747, 2025

      • reosarevok[m]
        Also, a button to mark a report as dealt with would be nice
      • 2025-01-27 02722, 2025

      • qesat60 has quit
      • 2025-01-27 02729, 2025

      • reosarevok[m]
        At some point it seems I edited the report text to indicate it, which is not ideal... but also, trying to load that edit report page now seems to just freeze my browser, so 😅
      • 2025-01-27 02716, 2025

      • lucifer[m]
        reosarevok: yes makes sense, my intent is/was to add it once we have migrated users to MeB Oauth.
      • 2025-01-27 02735, 2025

      • reosarevok[m]
        Sure, seems fine to me :) Just needs to have a clear idea of how it should work
      • 2025-01-27 02735, 2025

      • snobdiggy292 joined the channel
      • 2025-01-27 02742, 2025

      • snobdiggy292 has quit
      • 2025-01-27 02727, 2025

      • BrainzGit
        [musicbrainz-server] 14ernst-roux-dice opened pull request #3456 (03master…tar-no-same-owner): add --no-same-owner option to tar https://github.com/metabrainz/musicbrainz-server/…
      • 2025-01-27 02700, 2025

      • snobdiggy292 joined the channel
      • 2025-01-27 02717, 2025

      • reosarevok[m]
        yvanzo, bitmap: drafted a blog post - making dinner now though, will get back to the release after that
      • 2025-01-27 02744, 2025

      • ansh[m] joined the channel
      • 2025-01-27 02744, 2025

      • ansh[m]
        mayhem: Can I use test.LB for some time?
      • 2025-01-27 02708, 2025

      • mayhem[m]
        yep
      • 2025-01-27 02739, 2025

      • BobSwift[m] joined the channel
      • 2025-01-27 02740, 2025

      • BobSwift[m]
        <mayhem[m]> "Bob Swift: shall we pick a..." <- Sounds good. Just let me know when and I'll make myself available. No other hearings, meetings or other firm commitments (so far) on my schedule for this week (although I do need to find some time to review the material for preliminary motions that one of the lawyers has submitted for one of the upcoming hearings that I'm chairing). Is there anything else you'd like me to prepare
      • 2025-01-27 02740, 2025

      • BobSwift[m]
        before we meet? Received some good comments on my initial questions at https://github.com/rdswift/musicbrainz-docs/wiki/…
      • 2025-01-27 02727, 2025

      • mayhem[m]
        should we include wileyfoxyx on this meeting?
      • 2025-01-27 02715, 2025

      • mayhem[m]
        as far as preparing, not sure -- I guess the goal of the meeting is to work out a general plan, clear questions and the like?
      • 2025-01-27 02704, 2025

      • snobdiggy292 has quit
      • 2025-01-27 02728, 2025

      • wileyfoxyx[m] joined the channel
      • 2025-01-27 02729, 2025

      • wileyfoxyx[m]
        mayhem: since I got the notification, I wouldn't mind joining in
      • 2025-01-27 02736, 2025

      • mayhem[m]
        what timezone are you in?
      • 2025-01-27 02708, 2025

      • BrainzGit
        [listenbrainz-server] 14anshg1214 opened pull request #3152 (03master…genre-explorer): LB-1509: Genre Explorer https://github.com/metabrainz/listenbrainz-server…
      • 2025-01-27 02733, 2025

      • mthax has quit
      • 2025-01-27 02733, 2025

      • mthax joined the channel
      • 2025-01-27 02743, 2025

      • mayhem[m]
        ansh: can you leave that branch running on test? i wanna see!
      • 2025-01-27 02749, 2025

      • wileyfoxyx[m]
        mayhem: GMT+3
      • 2025-01-27 02753, 2025

      • ansh[m]
        mayhem[m]: I've already replaced the image and deployed my branch. I'll revert it back to your branch
      • 2025-01-27 02713, 2025

      • mayhem[m]
        ansh[m]: I want to see *your* branch!
      • 2025-01-27 02736, 2025

      • ansh[m]
        ohhk
      • 2025-01-27 02746, 2025

      • monkey[m]
        mayhem: It's playlist covers, not genre explorer :)
      • 2025-01-27 02751, 2025

      • monkey[m]
        Although the playlist covers are cool
      • 2025-01-27 02709, 2025

      • monkey[m] uploaded an image: (964KiB) < https://matrix.chatbrainz.org/_matrix/media/v3/download/chatbrainz.org/JJbUDJcIhSdaTgWhgeTRJLYu/image.png >
      • 2025-01-27 02712, 2025

      • mayhem[m]
        can we put the genre explorer up somewhere?
      • 2025-01-27 02723, 2025

      • ansh[m]
        That's still wip
      • 2025-01-27 02732, 2025

      • mayhem[m]
        ansh[m]: got it.
      • 2025-01-27 02735, 2025

      • mayhem[m]
        another day thenm
      • 2025-01-27 02747, 2025

      • mayhem[m]
        Bob Swift: wileyfoxyx https://www.timeanddate.com/worldclock/meetingtim… how about tomorrow at UTC-16:00?