10:57 AM
ChanServ has quit
2005-05-16 13643, 2005
10:57 AM
Shepard joined the channel
2005-05-16 13626, 2005
11:30 AM
Daedalus has quit
2005-05-16 13618, 2005
11:34 AM
DJKC
2005-05-16 13602, 2005
11:39 AM
Daedalus joined the channel
2005-05-16 13618, 2005
11:45 AM
rj_ joined the channel
2005-05-16 13647, 2005
11:50 AM
rj_
hi- i'm digging around in the MB database, trying to make a query that gives the mb album id if passed the artist name and album name. anyone know the best way to decide which album is the "correct" one, if there are multiple entries with the same name for a given artist?
2005-05-16 13623, 2005
11:51 AM
rj_
eg, the human league have 3 entries called Greatest Hits, with 3 differnt mb ids
2005-05-16 13620, 2005
11:53 AM
rj_
i think the number next to the TRM icon on the site is what i need to order by. haven't spotted it in the db yet tho, must be there somewhere
2005-05-16 13627, 2005
12:02 PM
ValHallA|SW`gone
ValHallA|SW`gone is now known as ValHallA|SW
2005-05-16 13608, 2005
12:05 PM
yalaforge is back (gone 02:12:22)
2005-05-16 13633, 2005
12:05 PM
DJKC
2005-05-16 13641, 2005
12:06 PM
yalaforge
rj_: still here?
2005-05-16 13655, 2005
12:07 PM
yalaforge
I think you mean the number of cdindexids
2005-05-16 13629, 2005
12:08 PM
yalaforge
you get it by joining album with albummeta. albummeta has a discid attribute, it's the one you seem to be looking for
2005-05-16 13655, 2005
12:10 PM
rj_
hi
2005-05-16 13601, 2005
12:11 PM
yalaforge
hi!
2005-05-16 13608, 2005
12:11 PM
rj_
ahha, thanks.. i'll just try it.
2005-05-16 13650, 2005
12:11 PM
rj_
hmm ok so albummeta doesnt contain any data for the album i'm trying
2005-05-16 13651, 2005
12:11 PM
yalaforge
you've got to join album.id with albummeta.id
2005-05-16 13655, 2005
12:11 PM
rj_
select * from musicbrainz.albummeta where id in (141684,43289,120113);
2005-05-16 13608, 2005
12:12 PM
rj_
those are 3 album ids for the human league - greatest hits
2005-05-16 13613, 2005
12:12 PM
yalaforge looks
2005-05-16 13645, 2005
12:12 PM
yalaforge
there should be exactly one albummeta row for each album row
2005-05-16 13603, 2005
12:13 PM
yalaforge
albummeta is updated by triggers IIRC
2005-05-16 13611, 2005
12:13 PM
rj_
hmm my albummeta table only has 6902 rows
2005-05-16 13620, 2005
12:13 PM
rj_
album has 260k
2005-05-16 13624, 2005
12:13 PM
rj_
guess that's the problem
2005-05-16 13636, 2005
12:13 PM
yalaforge
then your data is incomplete
2005-05-16 13650, 2005
12:13 PM
yalaforge
albummeta is part of our snapshots
2005-05-16 13606, 2005
12:14 PM
rj_
odd, i'm using the hourly feed. maybe it broke. i shall investigate
2005-05-16 13609, 2005
12:14 PM
rj_
thanks :)
2005-05-16 13629, 2005
12:14 PM
yalaforge
it's in the derived snapshot
2005-05-16 13650, 2005
12:14 PM
yalaforge
mhh. I wonder if albummeta is part of the replication packages. I'd think no
2005-05-16 13604, 2005
12:15 PM
yalaforge
the triggers should keep it up to date
2005-05-16 13616, 2005
12:15 PM
rj_
i see, that makes sense
2005-05-16 13632, 2005
12:15 PM
rj_
the rows i have are probably created by triggers when we grab more data then
2005-05-16 13640, 2005
12:15 PM
rj_
so i need to populate that table manually the first time
2005-05-16 13646, 2005
12:17 PM
yalaforge looks at mb_server/admin/sql/updates/20040220-1.sql
2005-05-16 13607, 2005
12:18 PM
yalaforge
perhaps you can use some of the code
2005-05-16 13655, 2005
12:18 PM
rj_
ahha
2005-05-16 13659, 2005
12:18 PM
rj_
thanks, that looks useful
2005-05-16 13603, 2005
12:19 PM
yalaforge
k
2005-05-16 13630, 2005
12:42 PM
yalaforge is away: I'm busy
2005-05-16 13626, 2005
13:29 PM
cikkolata
ehh... I'm in the top voters? I don't remember doing much voting!
2005-05-16 13638, 2005
13:31 PM
Knio-sleep
Knio-sleep is now known as Knio
2005-05-16 13644, 2005
13:34 PM
mo_natt
mo_natt is now known as mo
2005-05-16 13658, 2005
13:34 PM
mo
2005-05-16 13600, 2005
13:35 PM
mo
sweet
2005-05-16 13639, 2005
13:35 PM
mo
he used wikimedia to
2005-05-16 13641, 2005
13:35 PM
mo
good
2005-05-16 13632, 2005
13:36 PM
mo
I don't know if I liek what he did to the front page though :/
2005-05-16 13600, 2005
13:37 PM
mo is very mad at its mom.
2005-05-16 13649, 2005
13:37 PM
cikkolata
why?
2005-05-16 13618, 2005
13:38 PM
mo
no reason ;_;
2005-05-16 13630, 2005
13:38 PM
mo
well ther is but its kinda dumb and private
2005-05-16 13657, 2005
13:38 PM
mo
anywa. it turnes out that the dodgey korean/that pockey was te tastiest one
2005-05-16 13602, 2005
13:39 PM
mo
I have only one left
2005-05-16 13646, 2005
13:39 PM
cikkolata
oh no! :o
2005-05-16 13649, 2005
13:39 PM
cikkolata
you need more then!
2005-05-16 13621, 2005
13:40 PM
mo
hehee
2005-05-16 13643, 2005
13:40 PM
mo
is cikkolata going to keep me in pockey for the rest of my life? lol
2005-05-16 13603, 2005
13:41 PM
cikkolata laughs
2005-05-16 13606, 2005
13:41 PM
cikkolata
maaaybe!
2005-05-16 13621, 2005
13:41 PM
mo
:D
2005-05-16 13617, 2005
13:44 PM
WireD has quit
2005-05-16 13622, 2005
13:57 PM
mo is no longer mad at his mom.
2005-05-16 13634, 2005
13:57 PM
cikkolata
that's good!
2005-05-16 13637, 2005
13:57 PM
mo
:)
2005-05-16 13649, 2005
13:57 PM
cikkolata
want to be mad at long passport forms with me? :)
2005-05-16 13658, 2005
13:57 PM
mo
oh, I hate those
2005-05-16 13641, 2005
13:58 PM
cikkolata
I don't mind filling them in, it's just that I always seem to nearly finish and make a really bad mistake.
2005-05-16 13606, 2005
13:59 PM
mo
and youcant use pencil, you gotta use pen :p
2005-05-16 13603, 2005
14:00 PM
cikkolata
black biro too
2005-05-16 13618, 2005
14:01 PM
mo
biro?
2005-05-16 13623, 2005
14:01 PM
mo
uh.. english
2005-05-16 13629, 2005
14:01 PM
mo
kulepen
2005-05-16 13636, 2005
14:01 PM
mo
*kulepenn
2005-05-16 13645, 2005
14:01 PM
cikkolata
umm...
2005-05-16 13650, 2005
14:01 PM
cikkolata
ballpoint?
2005-05-16 13650, 2005
14:01 PM
somniloquy
somniloquy is now known as somnout
2005-05-16 13600, 2005
14:02 PM
mo
hmm.. I think maybe
2005-05-16 13603, 2005
14:02 PM
mo
not gel inc
2005-05-16 13616, 2005
14:02 PM
cikkolata
yeah
2005-05-16 13621, 2005
14:02 PM
cikkolata
the cheap sort everyone has :)
2005-05-16 13633, 2005
14:02 PM
mo
yea that
2005-05-16 13629, 2005
14:04 PM
cikkolata successfully completes a section without any mistakes!
2005-05-16 13642, 2005
14:04 PM
mo
yay!
2005-05-16 13654, 2005
14:04 PM
eMb joined the channel
2005-05-16 13655, 2005
14:04 PM
cikkolata
there are 10 sections :/
2005-05-16 13658, 2005
14:04 PM
mo
grrrrrrrrrrr TRongerboll is on the top voting top voters o nthe top!
2005-05-16 13620, 2005
14:05 PM
cikkolata
that makes a change!
2005-05-16 13631, 2005
14:05 PM
mo
it makes me really mad for unknown reasons
2005-05-16 13630, 2005
14:07 PM
mo
2005-05-16 13657, 2005
14:08 PM
eMb
Infidels all of them.
2005-05-16 13609, 2005
14:09 PM
cikkolata
ehh...
2005-05-16 13613, 2005
14:09 PM
cikkolata skips this section
2005-05-16 13601, 2005
14:10 PM
mo
please everone vote no o nthese mods
2005-05-16 13611, 2005
14:10 PM
mo
I'll issue a merge with unknown
2005-05-16 13612, 2005
14:11 PM
eMb
Why not merge with 'Various'?
2005-05-16 13620, 2005
14:11 PM
mo
2005-05-16 13636, 2005
14:11 PM
mo
vecause then peopel will add non varuis artists albums to varius artists
2005-05-16 13635, 2005
14:12 PM
mo
cikkolata what say you. arethose two albums the same?
2005-05-16 13644, 2005
14:12 PM
mo
is it the trscktimes bug?
2005-05-16 13625, 2005
14:13 PM
cikkolata looks
2005-05-16 13629, 2005
14:13 PM
eMb
mo: I'm thinking the two Apocalyptica albums are the same, yes. It's even one of the albums where they have no covers at all.
2005-05-16 13650, 2005
14:13 PM
eMb
mo: Okay
2005-05-16 13603, 2005
14:14 PM
mo
I'l merge thwm then
2005-05-16 13643, 2005
14:14 PM
Shepard
ehm
2005-05-16 13651, 2005
14:14 PM
Shepard
there was a reason why this was added
2005-05-16 13653, 2005
14:14 PM
Shepard
2005-05-16 13606, 2005
14:15 PM
Shepard
though i don't know what album is correct
2005-05-16 13616, 2005
14:15 PM
cikkolata
mo: well, I removed the data track from the one without a disc ID, so probably
2005-05-16 13640, 2005
14:15 PM
mo
and since this album has the correctlenght. with a cd-id and all. then the other will (when merged)
2005-05-16 13653, 2005
14:15 PM
mo
aha. so then yes I merge
2005-05-16 13620, 2005
14:17 PM
mo
2005-05-16 13600, 2005
14:18 PM
cikkolata
ooh
2005-05-16 13612, 2005
14:18 PM
cikkolata
the notes say that I only need to do sections 1 to 3 and 9
2005-05-16 13632, 2005
14:18 PM
mo
did I tell you that the place I accidentally bought a copy-protect CD from let me trade itin for soem thing else?
2005-05-16 13639, 2005
14:18 PM
cikkolata
oh?
2005-05-16 13640, 2005
14:18 PM
mo
shibby cikka!
2005-05-16 13602, 2005
14:19 PM
eMb
Heh, copy protected cds are a joke
2005-05-16 13603, 2005
14:19 PM
mo
yes. I was positivly surprised at their willingness to help me out
2005-05-16 13621, 2005
14:19 PM
mo
it was on sale to (usually stores *do NOT* trade sale itmes)
2005-05-16 13630, 2005
14:19 PM
eMb
wow, seems like a good store.
2005-05-16 13643, 2005
14:19 PM
cikkolata
ooh
2005-05-16 13647, 2005
14:19 PM
cikkolata
so now I'm done!
2005-05-16 13651, 2005
14:19 PM
mo
free record shop
2005-05-16 13656, 2005
14:19 PM
mo
yay cikka!
2005-05-16 13627, 2005
14:20 PM
cikkolata
well, I need to sign it
2005-05-16 13633, 2005
14:20 PM
mo
meep?
2005-05-16 13635, 2005
14:20 PM
cikkolata
but I'm practising my signature first!
2005-05-16 13639, 2005
14:20 PM
mo
lol
2005-05-16 13646, 2005
14:20 PM
eMb
cikkolata: What are you signing for?
2005-05-16 13649, 2005
14:20 PM
cikkolata
I don't want to have a dodgy signature for 10 years!
2005-05-16 13653, 2005
14:20 PM
cikkolata
passport
2005-05-16 13609, 2005
14:21 PM
mo
are you going somewhere?
2005-05-16 13614, 2005
14:21 PM
cikkolata
maaaybe!
2005-05-16 13617, 2005
14:21 PM
mo
:D
2005-05-16 13626, 2005
14:21 PM
cikkolata
but it ran out in february and I've been meaning to get a new one
2005-05-16 13636, 2005
14:21 PM
cikkolata eyes the signature in her old one...
2005-05-16 13643, 2005
14:21 PM
cikkolata
eh, it's not like my signature ever changes...
2005-05-16 13653, 2005
14:21 PM
mo
ohh.. so maaaybe means'no' :_:
2005-05-16 13609, 2005
14:22 PM
mo
alien spider smily
2005-05-16 13609, 2005
14:22 PM
cikkolata
maaaybe means maaaybe! :D
2005-05-16 13637, 2005
14:22 PM
mo
yay I removed a bougus artist
2005-05-16 13615, 2005
14:23 PM
eMb
My philosphy is; If it's not on the internet, it's bogus.
2005-05-16 13625, 2005
14:23 PM
eMb
Everything is on the internet.
2005-05-16 13649, 2005
14:23 PM
mo
yes. even bougus things :o)
2005-05-16 13620, 2005
14:24 PM
cikkolata
I like my passport...
