Bug 179371 - Current Track Info lists songs as Last Played: The Future
Summary: Current Track Info lists songs as Last Played: The Future
Status: RESOLVED FIXED
Alias: None
Product: amarok
Classification: Applications
Component: Context View (show other bugs)
Version: 2.0
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-02 13:51 UTC by Cayafas
Modified: 2009-12-09 11:29 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Cayafas 2009-01-02 13:51:09 UTC
Version:           2.0 (using KDE 4.1.3)
OS:                Linux
Installed from:    Ubuntu Packages

The Current Track Info lists songs as Last Played: The Future, causing the same songs to be on top of the Last Played: list forever.

This happens specifically when I (and can be reproduced if you) load a song or a folder of songs that are not in my collection yet, and play them, then add them to the collection afterwards. The songs that have been played in this way will be considered to have been played in 'The Future'. This problem occurs consistently, even after removing the database and reinstalling Amarok.
Comment 1 Georges 2009-03-19 23:23:13 UTC
I can confirm this bug.

Running on debian-amd64:
Version 2.1-SVN (Debian 2.0.60+svn935422-2)
Using KDE 4.2.1 (KDE 4.2.1)

I suppose there is a wrong entry in the DB which doesn't get updated because of its future date or something...
Comment 2 Georges 2009-03-19 23:54:27 UTC
Just to let you know, this is really easily fixed.
Start a mysql server as described on:
http://amarok.kde.org/wiki/Development/MySQL_Embedded

Next, connect to it, either with some frontend (e.g. mysql-query-browser) or via the mysql commandline tool.
In the amarok.statistics table, look for numbers >=2000000000 in the accessdate column, and remove those entries.

-> Problem fixed ! :-)
Comment 3 Myriam Schweingruber 2009-04-24 13:39:04 UTC
Have some of the devs looked into this bug? I change it to 'new' as it was still listed as 'unconfirmed'. Looks like an easy fix...
Comment 4 Mikko C. 2009-05-17 12:04:41 UTC
In Amarok trunk, statistics for tracks not in the collection are not shown in the current track applet anymore. So I guess this bug can be closed now?
Comment 5 Leo Franchi 2009-05-17 12:07:59 UTC
yeah, closing as the tracks that e.g. are not in the collection don't have a StatisticsCapability so the stats aren't shown.

please re-open if it still happens when the stats info is shown.