Bug 194200 - amarok doesn't remove deleted files from database
Summary: amarok doesn't remove deleted files from database
Status: RESOLVED DUPLICATE of bug 191058
Alias: None
Product: amarok
Classification: Applications
Component: general (show other bugs)
Version: 2.0.90
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-05-26 20:37 UTC by Tanja Schulte
Modified: 2009-05-31 10:43 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Tanja Schulte 2009-05-26 20:37:31 UTC
Version:           2.0.90 (using KDE 4.2.85)
OS:                Linux
Installed from:    Ubuntu Packages

I deleted one of my mp3 files from disk but it still appears in amarok's collection count though it is not visible in the collection. I even can drag that file into the playlist when I drag the whole collection, it is then shown with no length and 0 B size. It doesn't help to recreate the database via amarok's settings.
Comment 1 Myriam Schweingruber 2009-05-26 21:33:50 UTC
Just rescanning the database doesn't recreate it, you need to erase it from ~/.kde/share/apps/amarok/, then rescan the collection. This could help.
Comment 2 Myriam Schweingruber 2009-05-26 21:35:41 UTC
Changing to feedback awaited.
Comment 3 Peter Paulsen 2009-05-28 22:52:46 UTC
Have the same problem. Database is not able to clear itself from deleted entries. Which files in ~/.kde/share/apps/amarok need to be erased?
Comment 4 Peter Paulsen 2009-05-29 12:19:17 UTC
I first tried to copy the deleted file again to the collection database and to rescan the database through amarok's settings (not the rescan entry in the extras menu). That revived the dead entry. Then I deleted the file via the context menu of the collection browser (before I deleted it via dolphin). After a restart of amarok again that ghost entry - and some other entries garbled (missing album information and so on). And a second file seemed to be deleted I haven't chosen to, but a quick look into the collection folder via dolphin still shows the file.

Then I renamed the folder mysqle and restarted amarok and let it rebuild the database which it does automatically.
So yes, obviously only a complete erasure of the whole database solves this.
But I have to repeat that every time after something has changed in the collection which results in losing all other collection information like e.g. the rating.

Shouldn't amarok (be able to) do this on its own - updating its database when files are deleted? The workaround to delete the whole database everytime something changes isn't very economic.
Comment 5 Mikko C. 2009-05-31 10:43:34 UTC

*** This bug has been marked as a duplicate of bug 191058 ***