#musicbrainz-devel

/

      • nikki
        my search is giving me 818

        • 2012-03-26 08610, 2012

      • nikki
        oh right, schema change ones

        • 2012-03-26 08626, 2012

      • ocharles
        no, i just read the number from the "stuff to schedule" filter

        • 2012-03-26 08601, 2012

      • hawke_1
        I managed to duplicate that self-voting thing

        • 2012-03-26 08614, 2012

      • nikki
        oh?

        • 2012-03-26 08620, 2012

      • hawke_1
        apparently there’s no validation done that the voting user is not the creator of the edit

        • 2012-03-26 08623, 2012

      • nikki
        gaaah jira

        • 2012-03-26 08625, 2012

      • hawke_1
        http://musicbrainz.org/edit/16944694

        • 2012-03-26 08649, 2012

      • ruaok
        good work.

        • 2012-03-26 08602, 2012

      • ruaok
        please make a note on the bug and then we should do it in 3 mo

        • 2012-03-26 08605, 2012

      • hawke_1
        k

        • 2012-03-26 08608, 2012

      • nikki
        why can't it be normal and associate my searches with the tab and not just my account

        • 2012-03-26 08612, 2012

      • ocharles
        hawke_1: maybe don't test on contentious merges either :P

        • 2012-03-26 08625, 2012

      • ocharles
        nikki: because jira likes breaking the Web

        • 2012-03-26 08652, 2012

      • hawke_1
        In the meantime, I use this for good — to make all my controversial edits pass! muwahahahaha

        • 2012-03-26 08607, 2012

      • hawke_1
        ocharles: I switched it back to abstain. ;-)

        • 2012-03-26 08616, 2012

      • nikki
        hawke_1: but how did you get the voting things to appear?

        • 2012-03-26 08622, 2012

      • hawke_1
        nikki: I didn’t.

        • 2012-03-26 08631, 2012

      • nikki
        o_O

        • 2012-03-26 08633, 2012

      • hawke_1
        wget --load-cookies cookies.txt --post-data 'url=http://musicbrainz.org/edit/16944694&enter-vote.vote.0.edit_id=16944694&enter-vote.vote.0.vote=1&submit=Enter vote' http://musicbrainz.org/edit/enter_votes

        • 2012-03-26 08654, 2012

      • nikki
        oh, so nothing obvious

        • 2012-03-26 08655, 2012

      • hawke_1
        (after using wget to save the session cookies to a file, from a login screen

        • 2012-03-26 08659, 2012

      • hawke_1
        Right

        • 2012-03-26 08612, 2012

      • ocharles
        but presumably someone did this via the web site

        • 2012-03-26 08617, 2012

      • ocharles
        not being intentionally malicious

        • 2012-03-26 08622, 2012

      • hawke_1
        Well, it was a bot…

        • 2012-03-26 08626, 2012

      • ocharles
        oh yea

        • 2012-03-26 08627, 2012

      • ocharles
        good point

        • 2012-03-26 08632, 2012

      • hawke_1
        Could easily be done programatically of course

        • 2012-03-26 08633, 2012

      • ocharles
        ruaok: INSTALL pushed

        • 2012-03-26 08637, 2012

      • ruaok
        thx

        • 2012-03-26 08641, 2012

      • ocharles
        see if you can get that far and make sure i haven't missed anything

        • 2012-03-26 08641, 2012

      • ruaok
        I'll have a play later

        • 2012-03-26 08651, 2012

      • ocharles
        oh, I was hoping you could look now so we could get this done

        • 2012-03-26 08601, 2012

      • ruaok
        ok

        • 2012-03-26 08605, 2012

      • ocharles
        i only went as far as just the carton-y stuff, no nginx/daemon tools yet

        • 2012-03-26 08642, 2012

      • ruaok
        yeah, dont bother with that stuff.

        • 2012-03-26 08653, 2012

      • ruaok
        since I am the only one who is ever goign to set this up.

        • 2012-03-26 08606, 2012

      • lfranchi joined the channel

        • 2012-03-26 08659, 2012

      • ruaok
        carton running now

        • 2012-03-26 08640, 2012

      • ocharles
        the install, or exec?

        • 2012-03-26 08613, 2012

      • ruaok
        install

        • 2012-03-26 08626, 2012

      • ruaok
        server started.

        • 2012-03-26 08648, 2012

      • ruaok
        / -> 404

        • 2012-03-26 08657, 2012

      • ruaok
        ah, lacking wikitrans file

        • 2012-03-26 08625, 2012

      • ruaok
        added wikitrans file.

        • 2012-03-26 08627, 2012

      • ruaok
        still 404.

        • 2012-03-26 08641, 2012

      • ocharles
        need more info

        • 2012-03-26 08653, 2012

      • ocharles
        "/ -> 404" does not exactly explain much :}

        • 2012-03-26 08604, 2012

      • ruaok
        http://paste.pocoo.org/show/571708/

        • 2012-03-26 08628, 2012

      • ruaok
        sadly, that doesn't say much more than "/ -> 404" :)

        • 2012-03-26 08644, 2012

      • ocharles
        ok, just trying locally

        • 2012-03-26 08617, 2012

      • ocharles
        also, you need to do -Ilib -Imusicbrainz-server/lib (i have it in the wrong order)

        • 2012-03-26 08613, 2012

      • ruaok
        or

        • 2012-03-26 08631, 2012

      • ocharles
        yea, that

        • 2012-03-26 08636, 2012

      • ocharles
        "$c->detach('/error_404') if $c->req->path eq 'doc/Home';"

        • 2012-03-26 08638, 2012

      • ruaok
        no change.

        • 2012-03-26 08641, 2012

      • ocharles
        that looks a bit odd

        • 2012-03-26 08643, 2012

      • ocharles
        yea, it won't fix it

        • 2012-03-26 08647, 2012

      • ocharles
        ruaok: is your DBdefs correct?

        • 2012-03-26 08608, 2012

      • ruaok
        which part?

        • 2012-03-26 08615, 2012

      • ocharles
        WIKITRANS_INDEX_FILE

        • 2012-03-26 08601, 2012

      • ocharles
        i don't have a index.txt, but I dunno where to get that from

        • 2012-03-26 08627, 2012

      • ruaok
        wget $WIKITRANS_INDEX_URL

        • 2012-03-26 08637, 2012

      • ruaok
        sub MB_SERVER_ROOT { "/home/metabrainz/metabrainz-server/" }

        • 2012-03-26 08650, 2012

      • ruaok
        sub WIKITRANS_INDEX_FILE { MB_SERVER_ROOT() . "/root/static/wikidocs/index.txt" }

        • 2012-03-26 08659, 2012

      • ruaok
        metabrainz [at pino]:~/metabrainz-server$ ls /home/metabrainz/metabrainz-server/root/static/wikidocs/index.txt

        • 2012-03-26 08609, 2012

      • ruaok
        /home/metabrainz/metabrainz-server/root/static/wikidocs/index.txt

        • 2012-03-26 08626, 2012

      • ocharles
        ok, so it's all good there

        • 2012-03-26 08649, 2012

      • ocharles
        paste me an entire log from startup to the end of the request

        • 2012-03-26 08608, 2012

      • ocharles
        though i don't think it'll help, good to see everything

        • 2012-03-26 08639, 2012

      • ruaok
        v

        • 2012-03-26 08640, 2012

      • ruaok
        http://paste.pocoo.org/show/571717/

        • 2012-03-26 08657, 2012

      • ocharles
        hmm, nothing odd

        • 2012-03-26 08601, 2012

      • ocharles
        and what's in index.txt?

        • 2012-03-26 08647, 2012

      • amp88 joined the channel

        • 2012-03-26 08658, 2012

      • amp88
        hello, again

        • 2012-03-26 08613, 2012

      • amp88
        i have another question with regards to rating data

        • 2012-03-26 08618, 2012

      • ruaok
        http://paste.pocoo.org/show/571730/

        • 2012-03-26 08629, 2012

      • amp88
        on the virtual server image the *_rating_raw tables are empty

        • 2012-03-26 08636, 2012

      • ocharles
        amp88: yes, that's private data

        • 2012-03-26 08639, 2012

      • amp88
        is this because of privacy

        • 2012-03-26 08600, 2012

      • amp88
        ok, thanks for confirming that

        • 2012-03-26 08630, 2012

      • ocharles
        ruaok: all the doc pages are MetaBrainz: stuff, and they aren't in http://musicbrainz.org/static/wikidocs/index.txt

        • 2012-03-26 08634, 2012

      • ocharles
        which i imagine is the problem

        • 2012-03-26 08646, 2012

      • ruaok
        ah.

        • 2012-03-26 08651, 2012

      • ocharles
        anyway, i'd double check the rest of the site, make sure donations work, etc

        • 2012-03-26 08652, 2012

      • ruaok
        ok, I'll play more after lunch.

        • 2012-03-26 08600, 2012

      • ruaok
        for sure.

        • 2012-03-26 08608, 2012

      • ruaok
        navap and I need to tidy up docs and all that

        • 2012-03-26 08620, 2012

      • kepstin-laptop joined the channel

        • 2012-03-26 08654, 2012

      • warp
        ocharles: hrm. the indexer I'm running locally isn't picking up a change to the cover art types of an image. any idea what could be wrong?

        • 2012-03-26 08650, 2012

      • ocharles
        as in inserts to the cover_art_type table?

        • 2012-03-26 08600, 2012

      • ocharles
        \d on that table and see if it has triggers

        • 2012-03-26 08651, 2012

      • warp
        no, I don't see any triggers.

        • 2012-03-26 08655, 2012

      • warp
        ocharles: nor do I see any in install.sql

        • 2012-03-26 08606, 2012

      • bitmap joined the channel

        • 2012-03-26 08620, 2012

      • ocharles
        warp: correct, there are no triggers

        • 2012-03-26 08622, 2012

      • ocharles
        so it needs some

        • 2012-03-26 08642, 2012

      • outsidecontext joined the channel

        • 2012-03-26 08637, 2012

      • amp88
        i've had a look around but i can't work out where the average ratings come from (e.g. for albums in artist overview)

        • 2012-03-26 08644, 2012

      • amp88
        can someone point me in the right direction, please?

        • 2012-03-26 08659, 2012

      • ruaok
        the get averaged from all the raw ratings.

        • 2012-03-26 08603, 2012

      • ruaok
        *they

        • 2012-03-26 08628, 2012

      • amp88
        yes, but are the averaged ratings available on the virtual server image?

        • 2012-03-26 08648, 2012

      • amp88
        (since the *raw_rating data is withheld for privacy reasons)

        • 2012-03-26 08648, 2012

      • ruaok
        they ought to be.

        • 2012-03-26 08605, 2012

      • ruaok
        are the *)_rating tables empty?

        • 2012-03-26 08608, 2012

      • ruaok
        -)

        • 2012-03-26 08620, 2012

      • amp88
        the *raw_rating tables are empty, yes

        • 2012-03-26 08635, 2012

      • amp88
        but when i browse the local server version i still see average ratings

        • 2012-03-26 08636, 2012

      • ruaok
        are the *_rating tables empty?

        • 2012-03-26 08604, 2012

      • amp88
        i don't see any _rating tables, only _rating_raw

        • 2012-03-26 08650, 2012

      • amp88
        SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%rating' -> no results

        • 2012-03-26 08606, 2012

      • amp88
        SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%rating_raw' -> 5 results, all empty

        • 2012-03-26 08629, 2012

      • amp88
        but the averaged rating information MUST be stored or calculated from somewhere, because the average ratings are still displayed on my local copy

        • 2012-03-26 08645, 2012

      • amp88
        i.e. when i browse to http://<internal ip>:3000 and look at artist overview

        • 2012-03-26 08628, 2012

      • amp88
        i've spent a little while trying to track down how the pages are generated (following the nginx output in the server window), but i can't make any progress

        • 2012-03-26 08641, 2012

      • ruaok
        select rating from artist_meta;

        • 2012-03-26 08647, 2012

      • amp88
        ah, that looks like exactly what i was looking for!

        • 2012-03-26 08648, 2012

      • amp88
        thanks :)

        • 2012-03-26 08653, 2012

      • ruaok
        np

        • 2012-03-26 08607, 2012

      • kepstin-laptop joined the channel

        • 2012-03-26 08643, 2012

      • amp88
        until we meet again o/

        • 2012-03-26 08646, 2012

      • amp88 has left the channel

        • 2012-03-26 08649, 2012

      • reosarevok joined the channel

        • 2012-03-26 08644, 2012

      • kurtjx joined the channel

        • 2012-03-26 08609, 2012

      • kepstin-laptop joined the channel

        • 2012-03-26 08617, 2012

      • ruaok
        frewsxcv: responded to your mail.

        • 2012-03-26 08629, 2012

      • ruaok
        I like the idea of you working on CC reviews.

        • 2012-03-26 08654, 2012

      • ruaok
        oh? it should also be able to to artist bios.

        • 2012-03-26 08613, 2012

      • ruaok
        navap: do you have a transclusion table for the meb site?

        • 2012-03-26 08642, 2012

      • frewsxcv
        ruaok: reading now

        • 2012-03-26 08648, 2012

      • pelotron joined the channel

        • 2012-03-26 08620, 2012

      • frewsxcv
        yeah, i'd be worried the voting of reviews could be abused to show disagreement about a particular viewpoint

        • 2012-03-26 08643, 2012

      • frewsxcv
        but i agree that some sort of rating mechanism is needed

        • 2012-03-26 08600, 2012

      • frewsxcv
        i'll do some research

        • 2012-03-26 08630, 2012

      • ruaok
        sounds good. but that is a great thing to realize at the outset. :)

        • 2012-03-26 08651, 2012

      • frewsxcv
        yeah, i should put my application through (they opened today0

        • 2012-03-26 08657, 2012

      • frewsxcv
        s/0/)/

        • 2012-03-26 08623, 2012

      • Leftmost joined the channel

        • 2012-03-26 08657, 2012

      • ruaok
        yeah, get it in soon.

        • 2012-03-26 08604, 2012

      • ruaok
        that way we can tell you what you should fix.

        • 2012-03-26 08620, 2012

      • ianmcorvidae
        I should file mine officially too; maybe I'll wait until ocharles reads & responds, though

        • 2012-03-26 08650, 2012

      • reosarevok joined the channel