Audiosoft,

When I read my eJukebox Homeview page, it says: "37415 Songs in your eJukebox database", but if I look into the DB file, there are 38677 "ID". So it seems that 1262 songs are missing in eJukebox! How can you explain a such difference?

Could you make so that eJukebox writes a log file during the database construction including a list of the files (full path) which has NOT been added to eJukebox? So we could try to figure out why these files are not added, and fixe the problem if possible..

Thanks.

I've had a similar/related problem. Just adding songs recently, maybe a few hundred at a time and EJ reports back that my db contains a thousand or so less than when I added the new ones?
I've not had chance to try and find out whether the songs have been removed from the db or not yet. I was approaching 49,000 tracks, thought I saw a post a while back reporting problems at this size?
I was over 49,000 and it dropped back to 47,000 something, anyone else seen this? Sorry, I can't look into it in more detail at the moment, away from home for a while.

Ah.. So I would be not the only one! Thanks for your report mbones.

I susppect the stats on the homeview can hide the duplicate files, but 1262 it's a lot! Weird.
I have some non-mp3 files, maybe they aren't in the homeview count??

Note that if I rebuild from scratch, I get the same result..

Pirk,

The homepage stat is accurate. It does not filter out duplicates or non-mp3s. It is the total number of songs you have in the database.

If you looked closely at the ID#'s in the database you would realize that the ID#'s are not always sequential. For example, when you rebuild a folder it deletes the old id#'s in the database (for the mp3s in the folder) and gives them new numbers (starting with the highest ID#) so that the ID#'s do not end up overlapping if there are more mp3s in the folder than before. i.e. I can see the ID#'s in my database go from #9293 right to #10283 and #10296 right to #10629 with no numbers in between. So you see the highest ID# in the database does not represent the number of songs you actually have. The database 'record count' is the number you should look at...not the ID#.

Fair enough. Still doesn't explain why after adding a few hundred songs, my homeview count goes down? Like I say, I'm not at home at minute but I'll check it out when I'm back.

Any reports of problems at 49,000+ files?

Ah.. OK, sorry Audiosoft.
Indeed, I haved not seen the record count at the bottom.. I'm not a database specialist! This meter correspond perfectly to the Homeview stats, +1: The internet radio link! So I will never found the 1262 missing songs.. only a few gaps!

Sorry again for the groundless suspicions.

Thanks for your explanations.

OK, just checked my db.m3u and that has 49,866 entries. That corresonds with the total amount of mp3 files I have but Ejuke still reports 47,344. The amount does increase correctly when I add new files now but it's still short.

It 'lost' these songs a few weeks back, not sure of the exact moment as I don't keep watch on the track numbers in the home view. It just dropped down by approx 2000 though.

I can't really determine if the songs are still there or not as trying to find the missing ones would be a bit of a chore!

I know what you're going to say - rebuild the DB. I'd like to avoid that as it takes days, literally. I've already gone to add new songs and let it scan the whole drive but it found nothing new. If you think that the songs are still there but the counter is wrong then I'll be happy to just leave it. Any suggestions?

mbones, did you ever use the 'rebuild folder' method or remove a folder from eJukebox using the editor?

I really don't think eJukebox can 'lose' songs. The count on the homepage is coded to the number in the actual database.

The db.m3u is not the database - it is just a log file the 'add new songs' feature uses to quickly determine if a file is a new when it does the search. Thus the db.m3u file may contain songs intentionally deleted from the actual database and duplicate file paths.

mbones, I agree that with a very large collection it's not easy to find any potential missing album! Perhaps that browsing carefully your album list.. but 2000 songs it's a lot! I think I would let my PC to rebuild when I'm away..

Yes the asn file is the DB, an Access DB..

Quote:

Originally posted by Pirk Yes the asn file is the DB, an Access DB..

forget that, found the password. Interesting looking in there, maybe can find which ones are missing

Bravo mbones! I hope that will help you. You will see if ever there is any mess in it! Mine seems perfectly clean.

I've taken the plunge and re-building. Reported 49980 files so it's gonna take some time.

After looking through the old db, I found some missing files but they didn't appear to be all together so it would take ages to locate them all.

Yeah, once the collection has grown so much you are driven to let eJukebox to operate on the whole. If you are demanding, the more important is to have all the tags perfectly up to date BEFORE the importation..