ok, live on test - just go to a release and there's a "duplicate" link in the release edit links
2009-03-12 07121, 2009
aCiD2 goes to make dinner
2009-03-12 07141, 2009
navap wonders where to look on this page, multiple headings, and all different sizes, and columns all over the places :p http://test.musicbrainz.org/artist/c004177d-8ed3-40b6-b46a-2dbd32077a26
2009-03-12 07101, 2009
navap
The odd/even colouring might need a little tweaking. I think each section should be independant, "Video" and "Are U Ready" should have the same colour backgrounds.
2009-03-12 07147, 2009
navap
aCiD2: The duplicate lik doesn't work.
2009-03-12 07151, 2009
navap
link*
2009-03-12 07135, 2009
Munger
navap, Either musicbrainz.org is running horribly slow, or clicking 'View artist edits' on a VA release is a bad idea
2009-03-12 07156, 2009
navap
How many relleases do you think are credited to VA? :p
2009-03-12 07102, 2009
navap
Clicking on View Edits for VA, in theory would bring up a few hundread thousand edits I think.
2009-03-12 07116, 2009
Munger
That's why I asked how to go from a release to viewing ASIN edits for that release
2009-03-12 07156, 2009
navap
Didn't know you meant a VA release.
2009-03-12 07106, 2009
navap
In that care you are going to have some problems :p
Alternatively, you can view your open edits by going to your profile, and clicking "Open edits".
2009-03-12 07115, 2009
Munger
I managed to find it on my open edits, but I was wondering if there was a quicker way from the release in question. I was not entirely sure the edit was mine
2009-03-12 07102, 2009
navap
Currently there isn't, a rewrite of the edit system is..planned. But I wouldn't expect it next month or anything.
2009-03-12 07103, 2009
Munger
In fact, I was not even sure what kind of edit is was, just that there was an open edit on that ASIN
2009-03-12 07119, 2009
nikkeee
I wouldn't expect it in the next year, tbh :P
2009-03-12 07100, 2009
navap
Damn, way to dash all my hopes :p
2009-03-12 07146, 2009
nikkeee
there's tt to finish first and then work on switching to ngs
2009-03-12 07125, 2009
nikkeee
well, release groups, I think the plan was to add the whole ngs schema but not expose all of the interface or something
2009-03-12 07140, 2009
navap
Wasn't there some question about a rewrite being necessary as part of the move to NGS?
2009-03-12 07108, 2009
nikkeee
yeah, I don't think anyone is sure
2009-03-12 07120, 2009
navap
Well, I'll keep holding on to my hope then :)
2009-03-12 07140, 2009
nikkeee
it's more fun to not expect things and be pleasantly surprised when you get them early, if you ask me
2009-03-12 07146, 2009
navap
There are times when I think I want a better edit system more than release groups.
2009-03-12 07118, 2009
nikkeee
you're not the one paying a lot :P
2009-03-12 07129, 2009
navap
:(
2009-03-12 07144, 2009
navap
One day ;) muhahaha
2009-03-12 07105, 2009
luks
money doesn't seem to be that effective in this case though
but navap, when you say better edit system, do you have some concrete ideas?
2009-03-12 07153, 2009
navap
Not really, I just know that it can(/should) be better. A simple example would be trying to find a specific edit for VA when you don't know the editor of who has voted on it.
2009-03-12 07141, 2009
navap
Also, not being able to quickly and easily find tracklevel edits for a release.
2009-03-12 07104, 2009
navap
Oh and URLs in general, once the edit has been made, its like it's completely swallowed up by the mb edit machine. I expect at the least an add URL edit to show up when I view the URL Edits page.
2009-03-12 07100, 2009
navap
Come to think of it, I suppose I do have lots of examples of things I would like changed, I'm just not sure how they could be implemnted; my skills as a programmer are a bit weak ;)
2009-03-12 07130, 2009
navap
Munger: hm You're right, tracks 19-22 aren't listed on bsnpubs.
2009-03-12 07134, 2009
nikki
I think the biggest problem is simply that things are only attached to one entity
not necessarily wrong, if it's a various artists release, then theoretically it makes sense to appear under the various artists entry, even if that's completely useless in practice
2009-03-12 07148, 2009
nikki
if it were attached to multiple things, it wouldn't be a problem
2009-03-12 07144, 2009
symphonick joined the channel
2009-03-12 07152, 2009
navap
Is the database queried each and every time an edit history is looked up?
2009-03-12 07131, 2009
nikki
I guess so
2009-03-12 07154, 2009
luks
the database is queried on every single page :)
2009-03-12 07106, 2009
navap
So adding an edit to multiple entities would cause much more work for the database correct? Is it possible to cache the edit history, to make things faster?
2009-03-12 07127, 2009
luks
no, the edit history is not cacheable
2009-03-12 07141, 2009
luks
there is too much dynamic data
2009-03-12 07151, 2009
navap
hm
2009-03-12 07104, 2009
nikki
entries in moderation_closed don't get updated though, do they?
2009-03-12 07125, 2009
navap
Well they could be, if someone came along and added a comment?
2009-03-12 07148, 2009
nikki
no, those are stored elsewhere
2009-03-12 07155, 2009
nikki
moderation_note_closed
2009-03-12 07158, 2009
nikki
iirc
2009-03-12 07152, 2009
luks
caching the moderation table would not really help much anyway
2009-03-12 07121, 2009
luks
querying the database is fast if you have sanely stored data and indexes
2009-03-12 07132, 2009
nikki
so the data isn't sanely stored?
2009-03-12 07136, 2009
navap
lol
2009-03-12 07143, 2009
nikki looks at it and goes o_O
2009-03-12 07109, 2009
Munger
Can't search URL edits based upon the old URL itself?
2009-03-12 07110, 2009
luks
well, the track edits page does some crazy queries to find the edits
2009-03-12 07124, 2009
nikki
I split the moderation_closed file by year...
2009-03-12 07124, 2009
navap
What causes the long page load times when viewing edit history?
2009-03-12 07133, 2009
nikki
2009 is already bigger than the 2003 one
2009-03-12 07150, 2009
navap
heh wow
2009-03-12 07106, 2009
nikki
I think all the trm edits were deleted though, so that would have made it smaller
2009-03-12 07119, 2009
navap
Is the time caused by the database lookup? Or something else?
2009-03-12 07148, 2009
Munger
What is frustrating is that the release page shows that there is a pending edit, but just won't give me anything to click to view it
2009-03-12 07123, 2009
luks
navap: the time is caused by too expensive queries
2009-03-12 07139, 2009
luks
like querying the edit history by text matching
2009-03-12 07147, 2009
nikki
how do you decide which columns need indexes?
2009-03-12 07114, 2009
luks
indexes only help you if you store the data correctly :)
2009-03-12 07119, 2009
aCiD2
thanks navap, think I've fixed that now
2009-03-12 07138, 2009
navap
Cool, it works.
2009-03-12 07154, 2009
navap
Even creates the same number of REs.
2009-03-12 07155, 2009
nikki
assuming the data were stored correctly, how would you decide?
heh, the release edit page does e.g. "WHERE ... AND m.tab IN ('album', 'Album') AND ..."
2009-03-12 07131, 2009
navap
I would only use it to confirm 107 with that tracklist, I wouldn't take much stock in the linked ASIN.
2009-03-12 07113, 2009
Munger
I have seen 3 different track listing with that catalog number
2009-03-12 07119, 2009
catgroove
uh, where can you turn ov ratings on tes.mb?
2009-03-12 07112, 2009
catgroove
the preferences are so fractilised it's hard to find what im' looking for
2009-03-12 07116, 2009
navap
I think you've cleaned them up quite a bit, I've gone through and made some edits myself as well. I think the proper remove ASIN edits are in place..I would move on for now :p
2009-03-12 07135, 2009
catgroove
pagination is cool, but ther eare too many pages now
2009-03-12 07129, 2009
navap
What pagination are you refering to catgroove?
2009-03-12 07156, 2009
catgroove
preference page
2009-03-12 07104, 2009
navap
Oh oh right.
2009-03-12 07107, 2009
catgroove
ok pagination is a not the tihng but you nkow what i mean
2009-03-12 07109, 2009
Munger
navap, OK. I'll forget all about all the schristmas ones. Maybe I'll attack them again one day
2009-03-12 07117, 2009
catgroove
shitmas XD
2009-03-12 07129, 2009
navap
catgroove: I agree, a lot of them have just one or two preferences.
2009-03-12 07134, 2009
catgroove
yes
2009-03-12 07102, 2009
catgroove
they've just ben put on separate pages by headline ,not logically resorted
2009-03-12 07105, 2009
navap
Try to think up a name that coulp group a couple of them together, maybe we can convince brianfreud to change it ;)
2009-03-12 07115, 2009
navap
could*
2009-03-12 07123, 2009
catgroove
first how to turn off ratings
2009-03-12 07133, 2009
navap
Display Options.
2009-03-12 07105, 2009
catgroove
eh
2009-03-12 07119, 2009
navap
Isn't it there?
2009-03-12 07125, 2009
catgroove
see id' put that on javascript
2009-03-12 07141, 2009
catgroove
or something.. let me think
2009-03-12 07105, 2009
catgroove
eh. wtf
2009-03-12 07112, 2009
brianfreud
It's all dynamically generated - if you can figure a way to consolidate sections better, feel free :)
2009-03-12 07117, 2009
catgroove
Show up to how many edits per page? (max: 25)
2009-03-12 07117, 2009
navap
I think maybe the 'Artist' and 'Release' sections could be classified as "Display Options".
2009-03-12 07120, 2009
brianfreud
I think the JS page is not the place for ratings, though.
2009-03-12 07127, 2009
brianfreud
*s/page/tab
2009-03-12 07146, 2009
catgroove
This field does not take multiple values
2009-03-12 07150, 2009
catgroove
uh. what?
2009-03-12 07152, 2009
navap
No, ratings is a UI "thing", and belongs undes display options.
2009-03-12 07123, 2009
catgroove
yea, true, but currently display optinos is all. full of not display opteny
2009-03-12 07135, 2009
brianfreud turns navap's list into a test by torture... 2521 possible inputs :D
2009-03-12 07144, 2009
navap
:p
2009-03-12 07157, 2009
navap
How did it become such a high number?
2009-03-12 07135, 2009
brianfreud
search/replace each possible variation or #'s of parts
the thing I don't like about that plain one is the person on the left who looks like they've got an umbrella on their head... either that or they're turning into a mushroom
