Pirk
Posting Freak
Posts: 3976
Registered: 3-11-2003
Location: France
Member Is Offline
|
 posted on 10-22-2006 at 03:10 PM
|
|
|
1262 songs are missing in eJukebox? (Not really)
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.
 Pirk |
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-22-2006 at 05:05 PM
|
|
|
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.
|
|
|
Pirk
Posting Freak
Posts: 3976
Registered: 3-11-2003
Location: France
Member Is Offline
|
|
posted on 10-22-2006 at 07:03 PM
|
|
|
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 |
|
|
Audiosoft
|
|
posted on 10-22-2006 at 10:06 PM
|
|
|
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#.
Audiosoft |
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-23-2006 at 09:09 AM
|
|
|
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?
|
|
|
Pirk
Posting Freak
Posts: 3976
Registered: 3-11-2003
Location: France
Member Is Offline
|
|
posted on 10-23-2006 at 11:33 AM
|
|
|
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.
Pirk |
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-30-2006 at 09:16 AM
|
|
|
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?
|
|
|
Audiosoft
|
|
posted on 10-30-2006 at 10:01 AM
|
|
|
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.
Audiosoft |
|
|
Pirk
Posting Freak
Posts: 3976
Registered: 3-11-2003
Location: France
Member Is Offline
|
|
posted on 10-30-2006 at 10:02 AM
|
|
|
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..
Pirk |
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-30-2006 at 11:40 AM
|
|
|
| Quote: | Originally posted by Audiosoft
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. |
Thanks for the suggestions chaps. I may have to rebuild by the look of it. One other question tho, is there any way to view the contents of the .asn
file? I presume that is the actual DB? Anyway to open it, or a copy of it in say Access or excel?
|
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-30-2006 at 11:41 AM
|
|
|
| Quote: | Originally posted by Audiosoft
mbones, did you ever use the 'rebuild folder' method or remove a folder from eJukebox using the editor?
. |
I've never used the ejuke editor, all mine are tagged before I import them.
|
|
|
Pirk
Posting Freak
Posts: 3976
Registered: 3-11-2003
Location: France
Member Is Offline
|
|
posted on 10-30-2006 at 12:21 PM
|
|
|
Yes the asn file is the DB, an Access DB.. 
Pirk |
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-30-2006 at 01:25 PM
|
|
|
| Quote: | Originally posted by Pirk
Yes the asn file is the DB, an Access DB.. |
Anyone tell me what the password for the db is?
|
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-30-2006 at 01:29 PM
|
|
|
|
forget that, found the password. Interesting looking in there, maybe can find which ones are missing
|
|
|
Pirk
Posting Freak
Posts: 3976
Registered: 3-11-2003
Location: France
Member Is Offline
|
|
posted on 10-30-2006 at 02:01 PM
|
|
|
Bravo mbones! I hope that will help you. You will see if ever there is any mess in it! Mine seems perfectly clean.
Pirk |
|
|
mbones
Junior Member
Posts: 39
Registered: 2-8-2006
Member Is Offline
|
|
posted on 10-30-2006 at 02:38 PM
|
|
|
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.
|
|
|
Pirk
Posting Freak
Posts: 3976
Registered: 3-11-2003
Location: France
Member Is Offline
|
|
posted on 10-30-2006 at 03:06 PM
|
|
|
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..
Pirk |
|
|
