#musicbrainz-devel

my search is giving me 818

oh right, schema change ones

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

I managed to duplicate that self-voting thing

oh?

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

gaaah jira

good work.

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

k

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

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

nikki: because jira likes breaking the Web

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

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

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

nikki: I didn’t.

o_O

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

oh, so nothing obvious

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

Right

but presumably someone did this via the web site

not being intentionally malicious

Well, it was a bot…

oh yea

good point

Could easily be done programatically of course

ruaok: INSTALL pushed

thx

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

I'll have a play later

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

ok

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

yeah, dont bother with that stuff.

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

carton running now

the install, or exec?

install

server started.

/ -> 404

ah, lacking wikitrans file

added wikitrans file.

still 404.

need more info

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

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

ok, just trying locally

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

or

yea, that

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

no change.

that looks a bit odd

yea, it won't fix it

ruaok: is your DBdefs correct?

which part?

WIKITRANS_INDEX_FILE

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

wget $WIKITRANS_INDEX_URL

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

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

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

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

ok, so it's all good there

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

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

v

hmm, nothing odd

and what's in index.txt?

hello, again

i have another question with regards to rating data

on the virtual server image the *_rating_raw tables are empty

amp88: yes, that's private data

is this because of privacy

ok, thanks for confirming that

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

which i imagine is the problem

ah.

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

ok, I'll play more after lunch.

for sure.

navap and I need to tidy up docs and all that

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?

as in inserts to the cover_art_type table?

\d on that table and see if it has triggers

no, I don't see any triggers.

ocharles: nor do I see any in install.sql

warp: correct, there are no triggers

so it needs some

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)

can someone point me in the right direction, please?

the get averaged from all the raw ratings.

*they

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

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

they ought to be.

are the *)_rating tables empty?

-)

the *raw_rating tables are empty, yes

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

are the *_rating tables empty?

i don't see any _rating tables, only _rating_raw

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

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

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

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

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

select rating from artist_meta;

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

thanks :)

np

until we meet again o/

frewsxcv: responded to your mail.

I like the idea of you working on CC reviews.

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

ruaok: reading now

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

but i agree that some sort of rating mechanism is needed

i'll do some research

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

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

s/0/)/

yeah, get it in soon.

that way we can tell you what you should fix.

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