Album name suck in 'pending changes' mode

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Album name suck in 'pending changes' mode

Matt Perry
This album appears to be stuck in pending changes mode for several weeks:
http://musicbrainz.org/release/353a71f2-5da8-46d7-9e49-488481a2ed07.html

I tried editing it and editing it back to see if that could clear
things.  No recent entries in the mod history.  DB problem maybe?

--
Matt Perry | matt at primefactor dot com

_______________________________________________
Musicbrainz-experts mailing list
[hidden email]
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-experts
Reply | Threaded
Open this post in threaded view
|

Re: Album name suck in 'pending changes' mode

Steve Wyles
On Sun, 23 Jul 2006, Matt Perry wrote:

> This album appears to be stuck in pending changes mode for several weeks:
> http://musicbrainz.org/release/353a71f2-5da8-46d7-9e49-488481a2ed07.html
>
> I tried editing it and editing it back to see if that could clear
> things.  No recent entries in the mod history.  DB problem maybe?

It was because http://musicbrainz.org/show/edit/?editid=4482923 was
approved. When approving was first introduced there was a little bug,
which has since been fixed, but the symptoms of it still exist in some
places.

For each edit opened against an object, a modpending value is incremented,
as each one closes, the value is decremented. When there is nothing
pending it should be at zero and the yellow indicator won't show.

In this case the value is:

musicbrainz_db=# select name, gid, modpending from album where id=120523;
     name     |                 gid                  | modpending
-------------+--------------------------------------+------------
  The Beatles | 353a71f2-5da8-46d7-9e49-488481a2ed07 |         -1

it has dropped below zero!

A script needs writing and running to fix the modpending values, but it
isn't high priority.

I can't remember if a ticket has been raised for this or not. I know one
was raised at the time for the approve bug, but that might have been
closed.

Steve

_______________________________________________
Musicbrainz-experts mailing list
[hidden email]
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-experts