#metabrainz

[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-serv...

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?edit...]).

I'm opening a ticket for that

LB-1729

LB-1729: Flairs settings shows incorrect time remaining https://tickets.metabrainz.org/browse/LB-1729

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

* Hi monkey... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/...>)

* Hi monkey... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/...>)

No worries, let me explain

* Hi monkey... (full message at <https://matrix.chatbrainz.org/_matrix/media/v3/...>)

To run via docker, you're going to log in to the web container which contains the update file and the psql CLI.

The commend for that is `./develop.sh run -it web bash`.

To run the psql command inside the container: `psql -h lb_db -d listenbrainz -U listenbrainz -f admin/sql/updates/name-of-your-file`

password will also be 'listenbrainz'

-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)

thanks it worked

after running the update script it just displayed ALTER TYPE

i'm assuming that it was succesful

Yes

but i still get 500 error :(

fixed some things as they were giving error messages

but now no error

Then it might be another issue :)

only 500

cant figure out as there's literally no error message :(

lemme commit my code till now to the pr

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

oh nvm i think i added type to a wrong table

💀

woops

how do i remove a type

ALTER TYPE hide_user_timeline_event_type_enum ADD VALUE 'thanks' AFTER 'personal_recording_recommendation';

i did this by mistake

had to do for user_timeline_event_type_enum

Indeed

lemme try drop type

suvid: Don't drop the entire type, google how to remove an entry from an enum

ohh ok

there's no way to modify a single value from enum

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 💀

done with most of the part

just dont know which tables i need to apply it to

according to chatgpt:

which table to use for step 3? :(

or should i leave it as it is?

and not do anything

cuz an extra enum type wont matter for now ig

[listenbrainz-server] 14mayhem merged pull request #3144 (03master…LB-1710): LB-1710: Add global stats monitoring endpoint https://github.com/metabrainz/listenbrainz-serv...

Bob Swift: shall we pick a meeting time this week to discuss docs? am meeting times for you should work I would guess.

bitmap: can you check https://github.com/metabrainz/musicbrainz-serve... and (once some changes are made) https://github.com/metabrainz/musicbrainz-serve... ? The latter I cannot review properly because that site blocks me for some reason

But apparently it should work in the US 🤷

reosarevok: I noticed this last week as well:

I just reported that user.

what should we do?

I'm missing the context for the "as well"

But if someone seems to be gaming the system, we were supposed to ban them IIRC?

Let me find the doc

context: https://community.metabrainz.org/t/ai-slush-fil...

the top tracks are skewed by this spammer.

yes, please ban.

monkey: luciferansh : stats.fm looks interesting -- even if to steal ideas for more stats. :)

Yes I believe aerozol has been referencing it for a couploe of years, some great stats viz

mayhem, lucifer: there is no "banned" in LB, right?

It's just "delete the profile" or nothing? Or is there something in between?

supposedly they have 2M paying users. which I kinda doubt, but ok.

nope

reosarevok[m]: there isn't.

and in this case, its garbage data.

so, toss it

let me know when those two accounts are purged and I'll follow up on the forum

Well, at some point they did listen to real music, but yeah

Anyway, this works for these users in particular, but you'll want better mechanisms in general

reosarevok[m]: for pausing someone's account and then be able to unpause it when they show remorse?

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

yeah, makes sense.

let me make a ticket

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

Because if we mess up and we just deleted someone's five years of listens, that'd suck

Deleted these two in LB, and blocked them in MB

I should probably notify the user

LB-1730: Allow admins to "pause" a user's account

Orbital Cannon Activated

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 :)

And at least one is a case where the user has actually deleted one of the MB accounts, so probably an error

But LB does not do anything with that, so both are still sending listens, probably without their knowledge

lucifer: please let's make it so deleting a user deletes it automatically in LB too, this is problematic :)

I guess we want real deletion there, not just Deleted Editor #Whatever

But that's for the LB team to decide

Also, a button to mark a report as dealt with would be nice

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 😅

reosarevok: yes makes sense, my intent is/was to add it once we have migrated users to MeB Oauth.

Sure, seems fine to me :) Just needs to have a clear idea of how it should work

[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-serve...

yvanzo, bitmap: drafted a blog post - making dinner now though, will get back to the release after that

mayhem: Can I use test.LB for some time?

yep

<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

should we include wileyfoxyx on this meeting?

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?

mayhem: since I got the notification, I wouldn't mind joining in

what timezone are you in?

[listenbrainz-server] 14anshg1214 opened pull request #3152 (03master…genre-explorer): LB-1509: Genre Explorer https://github.com/metabrainz/listenbrainz-serv...

ansh: can you leave that branch running on test? i wanna see!

mayhem: GMT+3

mayhem[m]: I've already replaced the image and deployed my branch. I'll revert it back to your branch

ansh[m]: I want to see *your* branch!

ohhk

mayhem: It's playlist covers, not genre explorer :)

Although the playlist covers are cool

can we put the genre explorer up somewhere?

That's still wip

ansh[m]: got it.

another day thenm

Bob Swift: wileyfoxyx https://www.timeanddate.com/worldclock/meetingt... how about tomorrow at UTC-16:00?