Yes, apparently it were edits 29086558, 29086559, 29086576, 29086577, 29086579, 29086580.
2014-09-01 24412, 2014
Gentlecat joined the channel
2014-09-01 24428, 2014
chirlu`
The artist probably didn’t have the URL and remixer relationships it now has, they would have kept it.
2014-09-01 24400, 2014
chirlu`
CallerNo6: edit_artist is what normally tells us which edits pertain to an artist.
2014-09-01 24438, 2014
chirlu`
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.
2014-09-01 24443, 2014
HibiscusKazeneko joined the channel
2014-09-01 24441, 2014
chirlu`
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.
2014-09-01 24423, 2014
chirlu`
But you can’t easily search for an ID in there either.
2014-09-01 24402, 2014
chirlu`
That’s what’s causing all these “failed prerequisite” edits after merges, and merged entities being displayed as “[removed]” in old edits, etc.
2014-09-01 24432, 2014
CallerNo6
ah. got it. that makes perfect sense.
2014-09-01 24431, 2014
reosarevok joined the channel
2014-09-01 24450, 2014
HibiscusKazeneko joined the channel
2014-09-01 24431, 2014
jesus2099 joined the channel
2014-09-01 24415, 2014
jesus2099
Lotheric: could you give me such an URL (for truncated iTunes something)
span.n-v is missing on track AC but it’s another ticket, right ? :)
2014-09-01 24418, 2014
chirlu`
Right, it’s the same as MBS-7844.
2014-09-01 24448, 2014
ruaok joined the channel
2014-09-01 24436, 2014
HibiscusKazeneko joined the channel
2014-09-01 24452, 2014
CallerNo6 joined the channel
2014-09-01 24404, 2014
ZaphodBeeblebrox
dang missed hibiscus by ][ much
2014-09-01 24406, 2014
ZaphodBeeblebrox
aw well
2014-09-01 24422, 2014
simukis_ joined the channel
2014-09-01 24414, 2014
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 :)
2014-09-01 24445, 2014
reosarevok_ joined the channel
2014-09-01 24427, 2014
madmouser1 joined the channel
2014-09-01 24426, 2014
HibiscusKazeneko joined the channel
2014-09-01 24406, 2014
chirlu`
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 :)
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>
2014-09-01 24454, 2014
jesus2099
and replace all occurences of 18em by 32em ?
2014-09-01 24402, 2014
jesus2099
bitmap: ↗
2014-09-01 24412, 2014
jesus2099
(don’t pverwrite </td> it’s just my copy/paste mistake though)
2014-09-01 24418, 2014
HibiscusKazeneko joined the channel
2014-09-01 24428, 2014
KRS-Cuan
jesus2099: Is that script still broken?
2014-09-01 24400, 2014
jesus2099
yes, at least the one i tried a few days ago
2014-09-01 24448, 2014
jesus2099
→ // @version 2014-04-07~1
2014-09-01 24404, 2014
jesus2099
KRS-Cuan: ↗
2014-09-01 24434, 2014
jesus2099
my patch is not a fix, it’s just a layout fix i always add to each release
2014-09-01 24459, 2014
ricezygomatic joined the channel
2014-09-01 24451, 2014
simukis_ joined the channel
2014-09-01 24443, 2014
djpretzel
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_Database/… but not the actual columns, etc.
2014-09-01 24404, 2014
HibiscusKazeneko joined the channel
2014-09-01 24424, 2014
Freso
djpretzel: I'm pretty sure all the db schemas are defined in the MBS source code.
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'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.
2014-09-01 24455, 2014
Freso
Anyway, #musicbrainz-devel is more like to know the answers.
2014-09-01 24401, 2014
djpretzel
right, gotcha. many thanks. I guess it also only includes the data that actually changes, which makes sense
2014-09-01 24449, 2014
ruaok joined the channel
2014-09-01 24451, 2014
HibiscusKazeneko joined the channel
2014-09-01 24433, 2014
jesus2099 joined the channel
2014-09-01 24414, 2014
jesus2099
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…
