Bug 179371

Summary:	Current Track Info lists songs as Last Played: The Future
Product:	[Applications] amarok	Reporter:	Cayafas <cayafas>
Component:	Context View	Assignee:	Amarok Bugs <amarok-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal	CC:	gtoth, lfranchi, myriam, vianasw
Priority:	NOR
Version First Reported In:	2.0
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

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.