20:07 PM
Bartman007
so how do I go about adding album art to a release that doesn't already have it?
2007-06-28 17913, 2007
20:07 PM
CatCat
add url
2007-06-28 17922, 2007
20:07 PM
CatCat
and paste i nthe amazon url
2007-06-28 17926, 2007
20:07 PM
CatCat
it will parse it for you
2007-06-28 17941, 2007
20:07 PM
CatCat
unless you´ve really pasted somethign weord
2007-06-28 17942, 2007
20:07 PM
Bartman007
oh, Relate to URL?
2007-06-28 17944, 2007
20:07 PM
CatCat
weird
2007-06-28 17948, 2007
20:07 PM
CatCat
yes
2007-06-28 17950, 2007
20:09 PM
ruaok
luks: ping?
2007-06-28 17953, 2007
20:09 PM
Bartman007
heh, running musicbrains in linux in a vm on the music on os x is working fairly decently :-)
2007-06-28 17920, 2007
20:10 PM
Bartman007
s/musicbrains/picardqt/
2007-06-28 17938, 2007
20:18 PM
luks
ruaok: pong
2007-06-28 17903, 2007
20:19 PM
ruaok
I just tried the queries you sent and there are more FK violations.
2007-06-28 17911, 2007
20:19 PM
luks
oh
2007-06-28 17912, 2007
20:19 PM
ruaok
I'm trying to construct the query to show those issues right now.
2007-06-28 17919, 2007
20:19 PM
ruaok forgets left join syntax
2007-06-28 17932, 2007
20:19 PM
luks
select * from release where label not in (select id from label) :)
2007-06-28 17948, 2007
20:19 PM
ruaok
heh.
2007-06-28 17949, 2007
20:19 PM
luks hates joins
2007-06-28 17906, 2007
20:20 PM
ruaok
you and me both, I can never remember then.
2007-06-28 17918, 2007
20:20 PM
ruaok will have to remember to use sub quries
2007-06-28 17926, 2007
20:20 PM
ruaok
240062 | 30649 | 222 | 1987-00-00 | 0 | 4131 | 823 660-2 | 042282366023 | 1
2007-06-28 17927, 2007
20:20 PM
ruaok
269048 | 31173 | 222 | 1990-00-00 | 0 | 4131 | 31453 1812-2 | | 1
2007-06-28 17929, 2007
20:20 PM
ruaok
276461 | 621539 | 221 | 2004-03-08 | 0 | 5649 | R 6632 | 724354812972 | 7
2007-06-28 17931, 2007
20:20 PM
ruaok
(4 rows)
2007-06-28 17949, 2007
20:20 PM
ruaok
looks like the last row is the issue
2007-06-28 17958, 2007
20:20 PM
luks
oh, one more
2007-06-28 17938, 2007
20:22 PM
Apollozeus has quit
2007-06-28 17956, 2007
20:22 PM
luks
update release set label=5647 where label=5649;
2007-06-28 17936, 2007
20:24 PM
ruaok
:-)
2007-06-28 17942, 2007
20:24 PM
ruaok
mbdb5=> begin;
2007-06-28 17943, 2007
20:24 PM
ruaok
mbdb5=> UPDATE release SET label=700 WHERE label=4131;
2007-06-28 17944, 2007
20:24 PM
ruaok
UPDATE 3
2007-06-28 17945, 2007
20:24 PM
ruaok
mbdb5=> ALTER TABLE release ADD CONSTRAINT release_fk_label FOREIGN KEY (label) REFERENCES label(id);
2007-06-28 17947, 2007
20:24 PM
ruaok
ALTER TABLE
2007-06-28 17949, 2007
20:24 PM
ruaok
mbdb5=> commit;
2007-06-28 17951, 2007
20:24 PM
ruaok
COMMIT
2007-06-28 17902, 2007
20:25 PM
ruaok
ok, I'll have it kick out a new dump tonight as well.
2007-06-28 17935, 2007
20:25 PM
phrontist joined the channel
2007-06-28 17945, 2007
20:25 PM
luks
thanks
2007-06-28 17957, 2007
20:26 PM
ruaok
done. thanks for the queries.
2007-06-28 17905, 2007
20:27 PM
ruaok
will you please go close the affected bugs?
2007-06-28 17933, 2007
20:28 PM
luks
ok, both are now closed
2007-06-28 17902, 2007
20:29 PM
ruaok
sweet.
2007-06-28 17948, 2007
20:30 PM
luks
i must say that it took me really a long time to figure out what's wrong here
2007-06-28 17900, 2007
20:31 PM
ruaok
what was it in the end?
2007-06-28 17914, 2007
20:31 PM
luks
a bug in MOD_EDIT_RELEASES
2007-06-28 17928, 2007
20:31 PM
luks
it tried to update the label column to a merged label id
2007-06-28 17931, 2007
20:31 PM
ruaok hopes he didn't cause it.
2007-06-28 17939, 2007
20:31 PM
ruaok
oh, ooops.
2007-06-28 17945, 2007
20:31 PM
luks
definitely not :)
2007-06-28 17957, 2007
20:31 PM
aCiD2 joined the channel
2007-06-28 17938, 2007
20:32 PM
luks
I was suspecting the label merging code from the first bug report, and I didn't even think that the bug can be elsewhere
2007-06-28 17924, 2007
20:33 PM
Yurim has quit
2007-06-28 17928, 2007
20:33 PM
ruaok loves second order bugs
2007-06-28 17943, 2007
20:33 PM
ruaok
I'm hoping to find more time to finish tagging DB stuff today.
2007-06-28 17928, 2007
20:34 PM
warp
tagging \o/
2007-06-28 17914, 2007
20:35 PM
ruaok
2007-06-28 17938, 2007
20:35 PM
warp
ruaok: no, i've been fairly afk the past week
2007-06-28 17944, 2007
20:35 PM
ruaok wonders if warp wants to help write a command line 'add tags to my tracks' script.
2007-06-28 17951, 2007
20:35 PM
ruaok
must be nice. :)
2007-06-28 17953, 2007
20:35 PM
warp
ruaok: sure!
2007-06-28 17938, 2007
20:36 PM
warp
ruaok: well... it irks that i don't get time/energy for coding.
2007-06-28 17904, 2007
20:37 PM
warp
ruaok: but, well,.. maybe it's worth it ;)
2007-06-28 17929, 2007
20:37 PM
ruaok
well, this won't be coding. or almost not. :)
2007-06-28 17930, 2007
20:37 PM
BrianG
i just tried to tag something and i got an error
2007-06-28 17930, 2007
20:37 PM
ruaok
2007-06-28 17944, 2007
20:37 PM
ruaok
BrianG: yes I broke it
2007-06-28 17953, 2007
20:37 PM
BrianG
ok, i thought maybe i did
2007-06-28 17907, 2007
20:38 PM
ruaok
warp: that URL tags an entity. its HTTP auth protected.
2007-06-28 17929, 2007
20:38 PM
ruaok
so, the only thing that needs to be done is to POST that URL after the HTTP auth.
2007-06-28 17934, 2007
20:38 PM
ruaok
pretty simple stuff.
2007-06-28 17943, 2007
20:38 PM
ruaok is looking forward to being able to tag from picard
2007-06-28 17952, 2007
20:38 PM
warp
ruaok: ok, sounds straightforward
2007-06-28 17901, 2007
20:39 PM
ruaok
but as BrianG mentioned, I broke the tagging.
2007-06-28 17906, 2007
20:39 PM
ruaok
I'll try and fix it today.
2007-06-28 17918, 2007
20:39 PM
ruaok
but you get the gist. simple shit.
2007-06-28 17920, 2007
20:39 PM
warp
ruaok: but.. well, i'm still stuck in afk mode for a while.
2007-06-28 17933, 2007
20:39 PM
ruaok
no rush. enjoy your afk!
2007-06-28 17948, 2007
20:39 PM
warp
ruaok: do you think you could mail me about this?
2007-06-28 17953, 2007
20:39 PM
ruaok
sure
2007-06-28 17900, 2007
20:40 PM
warp
great, thanks!
2007-06-28 17945, 2007
20:40 PM
ruaok
:-)
2007-06-28 17954, 2007
20:46 PM
Aankhen``
CatCat: Why did you change your ident?
2007-06-28 17913, 2007
20:48 PM
BrianG
CatCat reminds me of PipPip and ChipChip
2007-06-28 17934, 2007
20:49 PM
dalen joined the channel
2007-06-28 17906, 2007
20:50 PM
Aankhen``
Heh.
2007-06-28 17926, 2007
20:50 PM
dalen
I just changed so that status is assigned for each release event instead of the whole release
2007-06-28 17903, 2007
20:51 PM
dalen
so, you can probably expect to see that in the next server update
2007-06-28 17930, 2007
20:51 PM
ruaok
status?
2007-06-28 17957, 2007
20:51 PM
BrianFreud
bootleg, promo, p-r, official?
2007-06-28 17913, 2007
20:52 PM
dalen
exatly
2007-06-28 17918, 2007
20:52 PM
BrianFreud
nice
2007-06-28 17931, 2007
20:52 PM
ruaok
oic
2007-06-28 17947, 2007
20:52 PM
dalen
I've for example seen bootleg releases of otherwise official albums
2007-06-28 17958, 2007
20:53 PM
BrianFreud
yes, I can think of more than a few offhand
2007-06-28 17906, 2007
20:54 PM
dalen
is kind of difficult to handle that otherwise. duplicating the whole release seems a bit ridiculous
2007-06-28 17942, 2007
20:54 PM
BrianFreud
yes - actually, panda and I've been going back and forth over something like that the past few days
2007-06-28 17911, 2007
20:55 PM
BrianFreud
A Morricone release where the French and Italian have identical Italian tracklists, but titles in Italian or French
2007-06-28 17935, 2007
20:55 PM
BrianFreud
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
2007-06-28 17949, 2007
20:55 PM
dalen
yeah, but that's a bit different though
2007-06-28 17900, 2007
20:56 PM
dalen
kraftwerk has a similar release
2007-06-28 17922, 2007
20:56 PM
BrianFreud
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
2007-06-28 17929, 2007
20:56 PM
luks
I think there is a lot of promo/official releases like that
2007-06-28 17917, 2007
20:57 PM
dalen
BrianFreud: but then the french tracklist is lost
2007-06-28 17956, 2007
20:57 PM
BrianFreud
2007-06-28 17916, 2007
20:58 PM
dalen
actually I didn't move p-r to the release events, but moved it to the album attributes instead
2007-06-28 17906, 2007
20:59 PM
CatCat
dalen I just changed so that status is assigned for each release event instead of the whole release <-- awsome!
2007-06-28 17906, 2007
20:59 PM
BrianFreud
So it'd be either p-r or soundtrack?
2007-06-28 17927, 2007
20:59 PM
BrianFreud
not sure I like that idea...
2007-06-28 17952, 2007
20:59 PM
CatCat
wtf is pr
2007-06-28 17902, 2007
21:00 PM
BrianFreud
pseudo-release
2007-06-28 17932, 2007
21:00 PM
CatCat
ok
2007-06-28 17932, 2007
21:00 PM
dalen
BrianFreud: yeah, but a p-r should be the same type as the one it links to
2007-06-28 17917, 2007
21:01 PM
dalen
and there is some code to support multiple attributes, like "Live, Soundtrack, Pseudo-Release"
2007-06-28 17919, 2007
21:01 PM
BrianFreud
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
2007-06-28 17941, 2007
21:01 PM
dalen
should finish that code up instead
2007-06-28 17943, 2007
21:01 PM
BrianFreud
So it's not either or?
2007-06-28 17949, 2007
21:01 PM
hawke_ joined the channel
2007-06-28 17903, 2007
21:02 PM
BrianFreud
If we can have both, double awesome!!!
2007-06-28 17904, 2007
21:02 PM
luks
dalen: we will definitely need multiple types per album
2007-06-28 17915, 2007
21:02 PM
dalen
BrianFreud: right now it's either, but that can be changed
2007-06-28 17922, 2007
21:02 PM
CatCat
2007-06-28 17951, 2007
21:02 PM
BrianFreud
live / comp, p-r / soundtrack, comp / soundtrack etc
2007-06-28 17951, 2007
21:02 PM
dalen
luks: agreed
2007-06-28 17952, 2007
21:02 PM
hawke_
woo, I love walking into the middle of a conversation. :-D
2007-06-28 17922, 2007
21:03 PM
dalen
2007-06-28 17923, 2007
21:03 PM
nightgroove has quit
2007-06-28 17928, 2007
21:03 PM
catgruff joined the channel
2007-06-28 17929, 2007
21:03 PM
CatCat
hæ
2007-06-28 17932, 2007
21:03 PM
hawke_
danke
2007-06-28 17948, 2007
21:03 PM
CatCat
it seems my other machine was unhappy
2007-06-28 17952, 2007
21:03 PM
CatCat
but uh..
2007-06-28 17957, 2007
21:03 PM
CatCat
this one is fine
2007-06-28 17900, 2007
21:04 PM
CatCat
weird
2007-06-28 17906, 2007
21:04 PM
dalen
luks: I could try to fix that tomorrow
2007-06-28 17928, 2007
21:04 PM
dalen
or tommorrow + the weekend :)
2007-06-28 17928, 2007
21:04 PM
luks
cool
2007-06-28 17959, 2007
21:04 PM
catgruff
dalen: did you see the link I (catcat) posted?
2007-06-28 17911, 2007
21:05 PM
catgruff
it is a proposition to do what you aretalking about
2007-06-28 17914, 2007
21:05 PM
catgruff
catgruff is now known as nightgroove
2007-06-28 17959, 2007
21:05 PM
BrianFreud
with megathought already put into it :)
2007-06-28 17913, 2007
21:06 PM
hawke_
dalen: ah, tying the release type/status into the release event -- excellent thing to do.
2007-06-28 17927, 2007
21:07 PM
CatCat
aww thanks brainfrø
2007-06-28 17946, 2007
21:07 PM
BrianFreud
:) Just look at some of the bits I added the other day, ok mo? :D
2007-06-28 17948, 2007
21:07 PM
CatCat
ok onigiri time
2007-06-28 17954, 2007
21:07 PM
CatCat
ipes
2007-06-28 17901, 2007
21:08 PM
CatCat
editing that page? :*
2007-06-28 17906, 2007
21:08 PM
BrianFreud
only discussion
2007-06-28 17918, 2007
21:08 PM
CatCat
oh
