Hi Piotr, Hi list,
On Mon, May 4, 2009 at 5:32 PM, Piotr Szulawski <[email protected]>wrote: > > Additional Item Attachment, bug #26436 (project librefm): > > File name: stat_removal.zip Size:2 KB As far as I can see looking on the site, this patch has not been applied yet, isn't it? Actually I was trying to import my last.fm statistics on libre.fm but I'd forgot to trim duplicate entries from the database, for this reason I looked for something able to reset my statistics and start with a clean db (and I remembered of this post). Just for info, that was the error I received: Traceback (most recent call last): > File "./import.py", line 30, in <module> > gobbler.add_track(GobbleTrack(artist, track, dt)) > File "/tmp/gobble.py", line 67, in add_track > self.submit() > File "/tmp/gobble.py", line 60, in submit > raise GobbleException("Server returned: %s" % (response,)) > gobble.GobbleException: Server returned: FAILED MDB2 Error: constraint > violation - _doQuery: [Error message: Could not execute statement] > [Last executed query: INSERT INTO Scrobbles (username, artist, album, > track, time, mbid, source, rating, length, stid) VALUES ('giopas', 'INXS', > NULL, 'Need You Tonight', 1217871341, NULL, NULL,'0',NULL,243420)] > [Native message: ERROR: duplicate key value violates unique constraint > "scrobbles_pkey"] > > Error has been reported to site administrators. > And that is how I trimmed the db, according to wiki instructions ( http://ideas.libre.fm/index.php/Using_lastscrape): $ awk '!x[$0]++' lastfm_dump.txt > lastfm_dump_no_duplicates.txt > $ cat lastfm_dump_no_duplicates.txt | wc -l; cat lastfm_dump.txt | sort -u > | wc -l > 20749 > 20749 > Concerning "where put the reset option", I think that "all stats reset" should be placed in the edit profile mask, whereas the "delete this song" from stats should be next to the song (in stats page). I'd also like to see the "modify song" option next to "delete this song", so that - at least at the beginning - everyone could help keeping cleaner libre.fm db. By the way, you are all doing an impressive work!! Thanks! enjoy, ;) giopas ps: Rhythmbox "Scrobble Free" (0.3) plugin works great...
_______________________________________________ Libre-fm mailing list [email protected] http://lists.autonomo.us/mailman/listinfo/libre-fm
