#musicbrainz

so how do I go about adding album art to a release that doesn't already have it?

add url

and paste i nthe amazon url

it will parse it for you

unless you´ve really pasted somethign weord

oh, Relate to URL?

weird

yes

luks: ping?

heh, running musicbrains in linux in a vm on the music on os x is working fairly decently :-)

s/musicbrains/picardqt/

ruaok: pong

I just tried the queries you sent and there are more FK violations.

oh

I'm trying to construct the query to show those issues right now.

select * from release where label not in (select id from label) :)

heh.

you and me both, I can never remember then.

240062 | 30649 | 222 | 1987-00-00 | 0 | 4131 | 823 660-2 | 042282366023 | 1

269048 | 31173 | 222 | 1990-00-00 | 0 | 4131 | 31453 1812-2 | | 1

276461 | 621539 | 221 | 2004-03-08 | 0 | 5649 | R 6632 | 724354812972 | 7

(4 rows)

looks like the last row is the issue

oh, one more

update release set label=5647 where label=5649;

:-)

mbdb5=> begin;

mbdb5=> UPDATE release SET label=700 WHERE label=4131;

UPDATE 3

mbdb5=> ALTER TABLE release ADD CONSTRAINT release_fk_label FOREIGN KEY (label) REFERENCES label(id);

ALTER TABLE

mbdb5=> commit;

COMMIT

ok, I'll have it kick out a new dump tonight as well.

thanks

done. thanks for the queries.

will you please go close the affected bugs?

ok, both are now closed

sweet.

i must say that it took me really a long time to figure out what's wrong here

what was it in the end?

a bug in MOD_EDIT_RELEASES

it tried to update the label column to a merged label id

oh, ooops.

definitely not :)

I was suspecting the label merging code from the first bug report, and I didn't even think that the bug can be elsewhere

I'm hoping to find more time to finish tagging DB stuff today.

tagging \o/

have you tried the new tagging on mb.homeip.net ?

ruaok: no, i've been fairly afk the past week

must be nice. :)

ruaok: sure!

ruaok: well... it irks that i don't get time/energy for coding.

ruaok: but, well,.. maybe it's worth it ;)

well, this won't be coding. or almost not. :)

i just tried to tag something and i got an error

BrianG: yes I broke it

ok, i thought maybe i did

warp: that URL tags an entity. its HTTP auth protected.

so, the only thing that needs to be done is to POST that URL after the HTTP auth.

pretty simple stuff.

ruaok: ok, sounds straightforward

but as BrianG mentioned, I broke the tagging.

I'll try and fix it today.

but you get the gist. simple shit.

ruaok: but.. well, i'm still stuck in afk mode for a while.

no rush. enjoy your afk!

sure

great, thanks!

:-)

CatCat: Why did you change your ident?

CatCat reminds me of PipPip and ChipChip

Heh.

I just changed so that status is assigned for each release event instead of the whole release

so, you can probably expect to see that in the next server update

status?

bootleg, promo, p-r, official?

exatly

nice

oic

I've for example seen bootleg releases of otherwise official albums

yes, I can think of more than a few offhand

is kind of difficult to handle that otherwise. duplicating the whole release seems a bit ridiculous

yes - actually, panda and I've been going back and forth over something like that the past few days

A Morricone release where the French and Italian have identical Italian tracklists, but titles in Italian or French

not quite a p-r, but also not quite the same - right now, we've been debating if it ought to be one or two releases

yeah, but that's a bit different though

kraftwerk has a similar release

Well, if we can add the French as a p-r event to the Italian, with a note about the release title in the annotation, that seems the cleanest

I think there is a lot of promo/official releases like that

BrianFreud: but then the french tracklist is lost

If anyone wants to chime in, or take a look, http://musicbrainz.org/show/edit/?editid=7104787

actually I didn't move p-r to the release events, but moved it to the album attributes instead

dalenI just changed so that status is assigned for each release event instead of the whole release <-- awsome!

So it'd be either p-r or soundtrack?

not sure I like that idea...

wtf is pr

pseudo-release

ok

BrianFreud: yeah, but a p-r should be the same type as the one it links to

and there is some code to support multiple attributes, like "Live, Soundtrack, Pseudo-Release"

But now you;d have all the Godzilla soundtracks in Japanese in one part of the list, as soundtracks, but the English versions elsewhere, without being ID'd as soundtracks

should finish that code up instead

So it's not either or?

If we can have both, double awesome!!!

dalen: we will definitely need multiple types per album

BrianFreud: right now it's either, but that can be changed

dalen, have you seen http://wiki.musicbrainz.org/ReleaseTypeRestruct...

live / comp, p-r / soundtrack, comp / soundtrack etc

luks: agreed

woo, I love walking into the middle of a conversation. :-D

hawke_: see http://bugs.musicbrainz.org/ticket/2996 to get an idea

hæ

danke

it seems my other machine was unhappy

but uh..

this one is fine

weird

luks: I could try to fix that tomorrow

or tommorrow + the weekend :)

cool

dalen: did you see the link I (catcat) posted?

it is a proposition to do what you aretalking about

catgruff is now known as nightgroove

with megathought already put into it :)

dalen: ah, tying the release type/status into the release event -- excellent thing to do.

aww thanks brainfrø

:) Just look at some of the bits I added the other day, ok mo? :D

ok onigiri time

ipes

editing that page? :*

only discussion

oh