#musicbrainz

uhh

how do I find out why an artist had been deleted?

I know what the MBID is: 66160e42-f416-41c2-8c7c-3157d7a563d1

VxJasonxV: someone probably deleted instead of merged

modbot did it, which means the artist was empty

but I looked through my recent edit notices, and don't see any mention of the artist being changed

VxJasonxV: Any release/recording/work of the artist that might be findable (at the new place it may have been moved to)?

would edits involving that artist still be findable by querying a local db?

Only by looking into the edits.

That's what I was trying to puzzle out. The 'edit' table would still have edits for deleted entities?

oh, edit_<entity> table maybe

Yes, edit has the data, but edit_artist has not.

But if you know only the deleted artist, you have to look into the edit data for each edit, to check where the artist is mentioned.

chirlu`: cool, thanks

This is one of the edits: https://beta.musicbrainz.org/edit/29086576

Yes, apparently it were edits 29086558, 29086559, 29086576, 29086577, 29086579, 29086580.

The artist probably didn’t have the URL and remixer relationships it now has, they would have kept it.

CallerNo6: edit_artist is what normally tells us which edits pertain to an artist.

But edit_artist.artist is a foreign key referencing the artist table, so when the artist is gone, the rows in edit_artist can’t remain.

On the other hand, edit.data is just a blob of text to the database, it doesn’t know that the text mentions IDs, so it doesn’t care about referential integrity there.

But you can’t easily search for an ID in there either.

That’s what’s causing all these “failed prerequisite” edits after merges, and merged entities being displayed as “[removed]” in old edits, etc.

ah. got it. that makes perfect sense.

Lotheric: could you give me such an URL (for truncated iTunes something)

jesus2099, preview for you: http://chirlu.mbsandbox.org/edit/21275586 (name-variation and tooltips)

whohoo ! great ! :)

span.n-v is missing on track AC but it’s another ticket, right ? :)

Right, it’s the same as MBS-7844.

dang missed hibiscus by ][ much

aw well

HibiscusKazeneko: <08:33> * ZaphodBeeblebrox has to go in 30 min. but if she comes on tell her I saw her tono thing and that she can pm me (I'll see it) or say it here (I'll also see it) and explain exactly the thing :)

warp (and others maybe): opinions? http://musicbrainz.org/edit/29073985

what’s a tono thing ?

is it “safe for work” ?

hi all. is it possible to have more than 1 release with exactly same name ?

Sure

oops.. just now i have realised i have cretaed more than 1 release w/different artists. please excuse.

reosarevok: thank you for ur quic reply. you beat me before i finished typing my message

ur no quic enoug yet !

 ;)

jesus2099: your mass merge script seems broken in beta. "Uncaught TypeError: Cannot read property '1' of null"

You might want to take a look since that probably means it'll break everywhere tonight :(

VxJasonxV: I didn't see any reason for those remix releases to be credited to the remixer.

But feel free to re-create an artist entry for him/her and link it to the songs with a remix AR.

Oh, looks like you already did. :)

merci reosarevok  :)

mmm, how does one add an area, it seems the db is missing http://en.wikipedia.org/wiki/Clifton_Park,_New_...

bitmap: if you’re here ?

when you update set-recordings-comments could you set <textarea id="rc-edit-note" style="width: 32em;" rows="5"></textarea> instead of <input type="text" id="rc-edit-note" style="width: 18em;"></td>

and replace all occurences of 18em by 32em ?

bitmap: ↗

(don’t pverwrite </td> it’s just my copy/paste mistake though)

jesus2099: Is that script still broken?

yes, at least the one i tried a few days ago

→ // @version 2014-04-07~1

KRS-Cuan: ↗

my patch is not a fix, it’s just a layout fix i always add to each release

is the schema for the edit tables (edit & edit_note) available anywhere other than the massive dump of edit history? They're both mentioned on http://wiki.musicbrainz.org/MusicBrainz_Databas... but not the actual columns, etc.

djpretzel: I'm pretty sure all the db schemas are defined in the MBS source code.

https://bitbucket.org/metabrainz/musicbrainz-se... - happy digging ;)

gotcha, was already browsing github

thanks

so all of the actual data in any given edit is just persisted to a single "data" field... anyone know if that's serialized, or XML, or what? I'm just curious how that would be parsed, if the edit is applied

I think it's JSON.

E.g., https://beta.musicbrainz.org/edit/28952195/data

I'm not sure whether this JSON representation is actually the raw output of what's in the db, or a serialised representation of the raw data in the db though.

Anyway, #musicbrainz-devel is more like to know the answers.

right, gotcha. many thanks. I guess it also only includes the data that actually changes, which makes sense

reoafk: the mass merge is fixed for the upcoming beta crash on <bdi> tags… i don’t know if it’s the only upcoming crash, i don’t have (time for) any recordings to merge atm…

:)

Thanks!

you’re welcome to report any further crahs ;)

Hexcells Infinite is out!