I am just starting to use Amarok and would like to verify that it correctly built it's database. At first, I had some problems with character code sets etc but have resolved those. Is there a simple method to count albums? Through other means, I've counted and confirmed that I have 3818 albums. Unfortunately the context tab of Amarok says that I only have 3739. So where are the missing albums?

One problem, (probably a bug) is that the database only creates an album for unique entries. Therefore the database only has one entry for "12 Songs" even though I have two albums by two artists with the same title (Randy Newman and Niel Diamond). That was the first one that I found but obviously this is also true for albums titled "Greatest Hits".

Should the database create multiple entries with the same information if there are multiple albums with the same name? This seems the most logical to me because there really are two different albums that deserve different album IDs in the table, they just happen to have the same name. (It might complicate "remove dead entries" type operations...) I've also read that people have had trouble with album art for albums of the same title. No doubt this is the same issue.

Or is the issue in how the context tab counts albums? The count matches the number of entries in the album table so I assume that's what it uses. If it is desireable to "reuse" the same album entries in the table then the context report needs some other way to calculate total albums.

Is there anyway to get a true album count out of amarok (or the database) so that I can compare it to my known number in order to verify the collection is correctly built?

    * Amarok version = 1.4.9.1
    * Distro = Kubuntu 8.04 (KDE 3.5.9)
    * What type of music you're trying to play = mp3
    * What engine you use! - I can't emphasise this enough! = xine
    * using mySQL database

Thanks,
Greg