man, you know what would have helped my find that faster? an edit search ;)
coopsh
that's why I'm confused
nikki
that just means the edit was automatically applied instead of being voted on
coopsh
ah, ok
it also means that we'll have a mixup the next couple of years?
nikki
a mixup?
kepstin
coopsh: we'll probably have mixed punctuation styles forever.
yay, my artist credit parsing and displaying should now work on all possible artist credits, and display them in the same way as the musicbrainz site itself.
man, where's an edit search when you want to see all of the artist credit edits that you've done recently ;)
coopsh
does musicbrainz warn if one edits/adds data and uses a 0x27 apostrophe (')?
nikki
no
kepstin
coopsh: nope
coopsh
wouldn't that be a good idea? ;)
ianmcorvidae
potentially once the devs don't have lots of real bugs to fix :P
hrglgrmpf joined the channel
zexpe joined the channel
bitmap
I don't see the point of a warning if we don't require it, it'll just annoy people who don't have the patience to enter them
nikki
if you convert u+2019 to u+0027 it'd make sense, but I imagine it'd piss people off if it did it anytime you edit something with u+0027
coopsh
what if people _add_ something w/ u+0027?
nikki
right now we let people use u+0027 but people who care about those characters are allowed to change them
bitmap
that's what I figured you meant
reosarevok
We could have an userscript that screams at you when it finds one
For the people who do care
ianmcorvidae
potentially if we provide a nice way of entering the unicode ones then we can be more strict about not entering u0027
zexpe
Is there an easy way to create new works for every recording in a release? Just like the composer relationship could be applied to all tracks of a release under Mason? And just like we can apply a performance relationship to all recordings in a release now? I can't see how to do this for a 20 track release in less than 60 time-consuming edits right now...
coopsh
maybe a 'auto-convert-to-u+2019' button ;)
bitmap should make a userscript that makes them bold and red with <blink> tags
reosarevok
zexpe: it is in development
bitmap
apparently only opera supports that tag now though :P
reosarevok
How surprising
Something that *works* in Opera… and it's an annoyance
bitmap
hehe
kepstin
you can still enable it in firefox, if you use about:config
hmm. apparently I need to make a separate version of my artist credit rendering template that's usable in places where plain text is required; It's not nice if page titles contain <a> elements :)
zexpe
reosarevok: as in soon? is there an MBS # for this? and are there any tricks such that it can be currently done in less than 3 edits per track?
kepstin wonders if it would make sense to have another step in the release editor to relate any new recordings that are being created to works.
kepstin
coopsh: nope.
wages joined the channel
zexpe
zexpe: replying to myself: the new "relate to works" option in test.musicbrainz.org does indeed cut 60 manual edits down to 1 that creates 20 auto-edits for new works and 40 new relationships to be approved. Can't wait to see this roll out live...
you should make that apply to the entire internet.
:)
bitmap
haha
kepstin looks at the output of his webapp.
kepstin
hmm. I guess I should do the release group parser next.
this app's usefulness will be legendary: it does a webservice query on musicbrainz.org, then renders a page that's as close as possible to what the original musicbrainz page looked like ;)
and here I thought I was trying to make an ISRC submission helper.
DarkerAudit joined the channel
EM3RY joined the channel
coopsh joined the channel
symphonick has left the channel
buremba joined the channel
buremba
hello everyone
i have a question about musicbrainz database
is there anyone?
coopsh
just ask ;)
Clint
be careful using ascii apostrophes though
coopsh
:D
buremba
i created a database and created tables with createtable.sql, and imported musicbrainz database
DarkAudit joined the channel
but there are some errors and some tables are empty
ERROR: new row for relation "url" violates check constraint "url_edits_pending_check" CONTEXT: COPY url, line 180147: "909043 33f5699f-ac58-4136-a51a-18c90c6b709f http://en.wikipedia.org/wiki/The_End_of_Days \N 0 -1 201..."
and relation table is empty
here is the line's content: 20318842f8dabd-bf2b-486d-aa57-4ebea9e011fe3474391777585585971\N222120282000919\N\N0-1\N
all errors are like this: ERROR: new row for relation "xxx" violates check constraint "xxx_edits_pending_check"
i asked my first question for not being in this situation :)
_Dave_ joined the channel
__bartholomule joined the channel
there is no one who answered my question. :/
coopsh
is there a way to add a track with tracknumber 0?
v6lur
buremba: well, it *is* saturday... maybe someone who knows something about that stuff notices it in an hour or few and answers; if not, ask again sometime :)
coopsh: why?
(pregap track?)
coopsh
yes, a hidden track
buremba
coopsh: i didn't change anything in db
kepstin
coopsh: we don't currently have support for pregap tracks. What you can do right now is add it as a standalone recording, and add a link to that recording in the release's annotation.
buremba
kepstin: you mean the database has errors, so you must change these lines, right?
kepstin
buremba: I don't know anything about your issue, I'm talking about something unrelated.
buremba
kepstin: ok, now should I fix errors by myself or wait someone who know db?