#musicbrainz

/

      • ruaok
        The fact that bazooka is 4th level down, is worrying me.

        • 2005-04-01 09124, 2005

      • ruaok
        I *like* that its there, but its a little promiment.

        • 2005-04-01 09100, 2005

      • bmaury
        this is a great problem. i wish i had more time. i'm banging away on my final project. due may 10th.

        • 2005-04-01 09127, 2005

      • bmaury
        i'll send out some emails and see if anyone can help. i have a couple of people in mind.

        • 2005-04-01 09155, 2005

      • ruaok
        awesome -- I appreciate it.

        • 2005-04-01 09104, 2005

      • ruaok
        that stuff is a little low tech for my skills. :-)

        • 2005-04-01 09155, 2005

      • ruaok
        if you give me a your email, I'll forward you a mail that states the problem in a bit more detail

        • 2005-04-01 09143, 2005

      • bmaury
        brookem [at sims.berkeley.edu]

        • 2005-04-01 09139, 2005

      • ruaok
        setn

        • 2005-04-01 09140, 2005

      • ruaok
        er

        • 2005-04-01 09142, 2005

      • ruaok
        sent

        • 2005-04-01 09120, 2005

      • lind has quit

        • 2005-04-01 09118, 2005

      • bmaury
        got it, and sent it out to two musicians (a sax player in the berkeley jazz band and a professional cellist) who are in my program (which deals with just this kind of organizational problem). i'm sure if they had more time, they'd help out. but we are all dealing with our theses. hopefully they will come back with some suggestions or contacts.

        • 2005-04-01 09143, 2005

      • ruaok
        awesome -- thanks mucho.

        • 2005-04-01 09151, 2005

      • ruaok
        and I look forward to reading more about your project.

        • 2005-04-01 09102, 2005

      • bmaury
        thanks, ruoak. hopefully i'll be able to pitch in to mb in a couple of months.

        • 2005-04-01 09111, 2005

      • bmaury
        er ruaok.

        • 2005-04-01 09116, 2005

      • ruaok 'd love that

        • 2005-04-01 09132, 2005

      • ruaok
        I get up to Berkeley pretty often too.

        • 2005-04-01 09116, 2005

      • bmaury
        cool. i'm in sf. shoot me an email if you are in the area.

        • 2005-04-01 09117, 2005

      • ruaok
        I have good friends that live at Claremont & Prince...

        • 2005-04-01 09135, 2005

      • ruaok
        will do.

        • 2005-04-01 09108, 2005

      • bmaury
        one more question for you: if i want to bypass the perl scripts, and just write a quick shell program to create and populate the tables, would i be able to figure out the proper order of the sql scripts in the mb_server/admin/sql directory, and then just load the data using \copy?

        • 2005-04-01 09116, 2005

      • bmaury
        or should i just try it?

        • 2005-04-01 09155, 2005

      • ruaok
        the perl scripts are *robust* and *fast*.

        • 2005-04-01 09103, 2005

      • ruaok
        I can't recommend them highly enough.

        • 2005-04-01 09110, 2005

      • bmaury
        yeah, they work great on my machine.

        • 2005-04-01 09127, 2005

      • bmaury
        but i don't have root at school, and i'm missing some modules...

        • 2005-04-01 09142, 2005

      • ruaok
        which modules?

        • 2005-04-01 09128, 2005

      • bmaury
        one sec...

        • 2005-04-01 09141, 2005

      • ruaok
        you don't need all of them for just importing the data.

        • 2005-04-01 09149, 2005

      • ruaok
        most of the them relate to the use of the web site.

        • 2005-04-01 09107, 2005

      • ruaok
        DBI and DBD::Pg are the most crucial ones.

        • 2005-04-01 09134, 2005

      • ruaok
        to be safe, import the data into a clean/disposable DB that you're importing to.

        • 2005-04-01 09153, 2005

      • bmaury
        yeah, i commented out all the stuff i thought i didn't need in MusicBrainz.pm, but i'm still missing String::Similarity

        • 2005-04-01 09110, 2005

      • ruaok
        you don't need that for DB import.

        • 2005-04-01 09119, 2005

      • djce has quit

        • 2005-04-01 09135, 2005

      • bmaury
        ahh. okay. i figured i didn't.

        • 2005-04-01 09138, 2005

      • cikkolata blinks

        • 2005-04-01 09103, 2005

      • cikkolata
        I don't remember needing to install anything (already had dbi) when I imported the data

        • 2005-04-01 09110, 2005

      • cikkolata
        trying to get apache to start... hah!

        • 2005-04-01 09119, 2005

      • bmaury
        he he.

        • 2005-04-01 09137, 2005

      • bmaury
        all i need is the data. we have our own app server.

        • 2005-04-01 09136, 2005

      • yalaforge joined the channel

        • 2005-04-01 09146, 2005

      • cikkolata
        hi!

        • 2005-04-01 09152, 2005

      • yalaforge
        hey! still up?

        • 2005-04-01 09155, 2005

      • cikkolata
        yep

        • 2005-04-01 09106, 2005

      • ruaok
        moin moin!

        • 2005-04-01 09110, 2005

      • yalaforge
        morgen!

        • 2005-04-01 09131, 2005

      • yalaforge noticed another db import going on via the chatlogs :-)

        • 2005-04-01 09124, 2005

      • cikkolata finds it amusing that yalaforge seems to sit reading the chatlogs rather than sit in here reading it normally

        • 2005-04-01 09143, 2005

      • ruaok
        yalaforge: http://groups.sims.berkeley.edu/orpheus/

        • 2005-04-01 09150, 2005

      • ruaok
        bmaury's project

        • 2005-04-01 09155, 2005

      • yalaforge looks

        • 2005-04-01 09122, 2005

      • yalaforge
        cikkolata: *my* computer is off, at least sometimes :-)

        • 2005-04-01 09152, 2005

      • yalaforge
        and I always check the chatlogs before turning it off, just to make sure you're not talking bad about me behind my back :-P

        • 2005-04-01 09125, 2005

      • cikkolata
        I remember when I was saying bye and you left too soon, so you came back

        • 2005-04-01 09136, 2005

      • cikkolata
        I wondered what was going on then :P

        • 2005-04-01 09139, 2005

      • yalaforge
        :-)

        • 2005-04-01 09142, 2005

      • moZZZZ
        hi

        • 2005-04-01 09148, 2005

      • yalaforge
        hey mo

        • 2005-04-01 09150, 2005

      • moZZZZ
        moZZZZ is now known as mo_

        • 2005-04-01 09155, 2005

      • mo_
        :D

        • 2005-04-01 09101, 2005

      • mo_
        good morning

        • 2005-04-01 09106, 2005

      • ruaok
        must be morning in europe. :-)

        • 2005-04-01 09116, 2005

      • mo_
        about 09:35 here

        • 2005-04-01 09120, 2005

      • yalaforge
        ruaok: I played on the test server a bit. do we have someone to create cute icons?

        • 2005-04-01 09128, 2005

      • ruaok
        donredman. :-)

        • 2005-04-01 09138, 2005

      • yalaforge
        I mean displaying 'Type: person' isn't cool

        • 2005-04-01 09140, 2005

      • ruaok
        whatchahaveinmind?

        • 2005-04-01 09145, 2005

      • cikkolata
        hi mo!

        • 2005-04-01 09149, 2005

      • ruaok
        ah yes. we did talk about that.

        • 2005-04-01 09154, 2005

      • cikkolata
        I was thinking icons too

        • 2005-04-01 09155, 2005

      • yalaforge
        great

        • 2005-04-01 09109, 2005

      • ruaok
        he did some other icons.

        • 2005-04-01 09117, 2005

      • ruaok
        he never liked the star icon, which I liked.

        • 2005-04-01 09127, 2005

      • yalaforge is another one who has more and more feature requests ;-)

        • 2005-04-01 09137, 2005

      • ruaok
        I think we should use the mic and maybe one that has cute people on it.

        • 2005-04-01 09150, 2005

      • cikkolata
        star icon?

        • 2005-04-01 09103, 2005

      • yalaforge
        actually, I don't care which one, just to differentiate between person and group

        • 2005-04-01 09115, 2005

      • bmaury
        That dang String::Similarity module gets referenced in mb_server/cgi-bin/MusicBrainz/Server/Database.pm.

        • 2005-04-01 09126, 2005

      • ruaok
        arg.

        • 2005-04-01 09140, 2005

      • ruaok
        so, is your limitation not having root?

        • 2005-04-01 09145, 2005

      • yalaforge
        not in my copy

        • 2005-04-01 09147, 2005

      • mo_
        hi cikkolata

        • 2005-04-01 09155, 2005

      • yalaforge
        (I'm working on a slightly older branch)

        • 2005-04-01 09131, 2005

      • bmaury
        yeah, pretty much. that and not really having a clean db for install.

        • 2005-04-01 09132, 2005

      • ruaok
        if you're not root you can install a local copy of it into your dir and then adjust the include path as appropriate

        • 2005-04-01 09153, 2005

      • yalaforge
        String::Similarity needs to be patched, btw

        • 2005-04-01 09154, 2005

      • mo_
        oh, ruaok, did I tell you I played around on the test server?

        • 2005-04-01 09102, 2005

      • mo_
        I found a bug

        • 2005-04-01 09104, 2005

      • ruaok
        no. do tell.

        • 2005-04-01 09106, 2005

      • ruaok
        crap. :-(

        • 2005-04-01 09112, 2005

      • ruaok
        why else would you want to talk to me. :-)

        • 2005-04-01 09123, 2005

      • yalaforge
        poor ruaok :-(

        • 2005-04-01 09128, 2005

      • ruaok
        just kidding.

        • 2005-04-01 09128, 2005

      • mo_
        when trying to change track artist on a VA release to anartist with rthe same name it doesn't work

        • 2005-04-01 09139, 2005

      • ruaok
        that's SO not my bug.

        • 2005-04-01 09140, 2005

      • mo_
        hey man you'r cool

        • 2005-04-01 09154, 2005

      • mo_
        I'd talk to you anytime ;)

        • 2005-04-01 09155, 2005

      • ruaok
        wait. maybe it is.

        • 2005-04-01 09114, 2005

      • yalaforge
        bmaury: which branch do you use for import?

        • 2005-04-01 09124, 2005

      • ruaok
        yeah that sounds like a possible bug.

        • 2005-04-01 09131, 2005

      • ruaok
        can you please enter it into SF?

        • 2005-04-01 09149, 2005

      • mo_
        source forge?

        • 2005-04-01 09151, 2005

      • yalaforge
        RELEASE_20050213-BRANCH doesn't have String::Similarity in Database.pm

        • 2005-04-01 09105, 2005

      • ruaok
        mo_: ya.

        • 2005-04-01 09113, 2005

      • ruaok
        but wait. maybe I can diagnose it right away.

        • 2005-04-01 09116, 2005

      • yalaforge
        and that's the branch that should be used because it's in sync with the database snapshots you're probably using

        • 2005-04-01 09118, 2005

      • ruaok
        what page is that problem on?

        • 2005-04-01 09136, 2005

      • mo_
        ok I'll just copy the text I used here ok?

        • 2005-04-01 09138, 2005

      • bmaury
        beautiful. i'll check it out. i was using whatever i found on the mb.org site.

        • 2005-04-01 09145, 2005

      • mo_ is new at sourceforge

        • 2005-04-01 09105, 2005

      • ruaok
        yalaforge: *that* part of MB always kinda bugs me. Its *the* most sensical way of doing things, but its a pain to keep in mind and explain

        • 2005-04-01 09128, 2005

      • ruaok
        mo_: lets start with just the page url where the error occurs.

        • 2005-04-01 09140, 2005

      • ruaok
        then, paste whatever error you get.

        • 2005-04-01 09142, 2005

      • mo_
        its hang on

        • 2005-04-01 09144, 2005

      • yalaforge
        I think djce added a few checks to make sure nobody imports the db with the wrong mb_server

        • 2005-04-01 09153, 2005

      • yalaforge
        ok, got to go

        • 2005-04-01 09100, 2005

      • yalaforge is away: work

        • 2005-04-01 09100, 2005

      • ruaok
        tschuess!

        • 2005-04-01 09128, 2005

      • yalaforge has quit

        • 2005-04-01 09129, 2005

      • cikkolata
        how do you pronounce that?

        • 2005-04-01 09148, 2005

      • mo_
        ok it works normal until you are at http://test.musicbrainz.org/changetrackartist.htm…

        • 2005-04-01 09156, 2005

      • mo_
        the serach page for the new artist

        • 2005-04-01 09111, 2005

      • mo_
        click submit and.. nothing happens

        • 2005-04-01 09122, 2005

      • mo_
        no yellow overlighting

        • 2005-04-01 09129, 2005

      • mo_
        *highlighting

        • 2005-04-01 09139, 2005

      • mo_
        no error

        • 2005-04-01 09142, 2005

      • mo_
        test

        • 2005-04-01 09146, 2005

      • mo_
        *text

        • 2005-04-01 09124, 2005

      • cikkolata just tried it

        • 2005-04-01 09151, 2005

      • cikkolata
        it doesn't change it for me either

        • 2005-04-01 09106, 2005

      • ruaok
        its not specifc to an album is it?

        • 2005-04-01 09106, 2005

      • cikkolata
        I wonder if we need the comment thing in the VA display thing?

        • 2005-04-01 09117, 2005

      • cikkolata
        I was trying it with W

        • 2005-04-01 09120, 2005

      • ruaok
        thing thing thin?

        • 2005-04-01 09103, 2005

      • ruaok
        what search value to you give?

        • 2005-04-01 09116, 2005

      • cikkolata
        me?

        • 2005-04-01 09120, 2005

      • ruaok
        mo

        • 2005-04-01 09126, 2005

      • mo_
        hey

        • 2005-04-01 09137, 2005

      • mo_
        what I did?

        • 2005-04-01 09150, 2005

      • ruaok
        what did you enter for the search query?

        • 2005-04-01 09153, 2005

      • mo_
        I don't think its album spesific, no

        • 2005-04-01 09115, 2005

      • mo_
        I just let it.. do byu it self, it searches for the 'testament' by iot sekf..

        • 2005-04-01 09122, 2005

      • mo_
        wait as ec.. lets try

        • 2005-04-01 09156, 2005

      • cikkolata
        neither of the VA W albums worked...

        • 2005-04-01 09103, 2005

      • mo_
        I entered 'testament' same deal

        • 2005-04-01 09126, 2005

      • ruaok
        it must be getting late, I don't get it.

        • 2005-04-01 09139, 2005

      • ruaok
        perhaps I need to walk through it from the beginning