Database Errors?

Get answers about using the current release of MediaMonkey for Windows.

Moderator: Gurus

zephyr
Posts: 101
Joined: Fri Oct 07, 2011 2:56 pm

Database Errors?

Post by zephyr » Sat Mar 17, 2012 8:30 pm

Hi

After working extensively on ~ 2TB of MP3s and other audio formats... my DB is close to containing, as desired, full albums. Lots of swapping tags (extract fields is AMAZING steegy), and so much duplication identified with Magic Nodes and Tagging Inconistencies and Advanced Duplicate Find and Fix... surprised how they keep popping up! Every angle I use to spot some, I find some. A few hairy moments where MM hangs, or dies, or weirdly says I have ~ 6 copies of every track on 2000 albums... but restarting fixed that one (double clicking a file to play would embolden all duplicates, indicating it was pointing to the same file... but I didn't spot that).

Removed lots of dead links, and almost ready to do a big auto-organize from tags to finally confidently distinguish between ALBUMS... and everything else (based on file locations).

H O W E V E R

Trying to maintain (quick optimize) library and Running DB cleanup / audit seems to indicate big trouble under the hood.

Code: Select all

SELECT * 
    FROM (SELECT Artists.ID AS IDArtist, Artists.Artist AS Artist, Songs.ID AS IDSong, Songs.Artist AS SongsArtist,  Songs.SongTitle, Songs.Album 
    FROM Artists, ArtistsSongs, Songs 
    WHERE ArtistsSongs.PersonType=1 
    AND Artists.ID=ArtistsSongs.IDArtist 
    AND ArtistsSongs.IDSong=Songs.ID) 
    WHERE SongsArtist NOT LIKE '%'||REPLACE(REPLACE(Artist,'@','@@'),';',';;')||'%' 
[IDARTIST] [ARTIST] [IDSONG] [SONGSARTIST] [SONGTITLE] [ALBUM] 
[88593] [Louis Armstrong] [1825629] [Various Artists] [The Plan/Minty - Outside] [Back To Mine [Danny Tenaglia]] 
[88593] [Louis Armstrong] [1825639] [Various Artists] [I Love My Man (original version) - Bent] [Back To Mine [Faithless]] 
[88593] [Louis Armstrong] [1825640] [Various Artists] [Sunday 8pm - Faithless] [Back To Mine [Faithless]] 
[88593] [Louis Armstrong] [1825641] [Various Artists] [Child, The (album version) - Alex Gopher] [Back To Mine [Faithless]] 
[88593] [Louis Armstrong] [1825642] [Various Artists] [Throw - Paperclip People] [Back To Mine [Faithless]] 
[88593] [Louis Armstrong] [1825643] [Various Artists] [Hercules - Aaron Neville] [Back To Mine [Faithless]] 
[88593] [Louis Armstrong] [1825644] [Various Artists] [Fade Into You - Mazzy Star] [Back To Mine [Faithless]] 
[88593] [Louis Armstrong] [1825645] [Various Artists] [Billie Jean - Shinehead] [Back To Mine [Faithless]] 
[88593] [Louis Armstrong] [1825646] [Various Artists] [My Life - Dido] [Back To Mine [Faithless]]
...
---------------- 20 OF 16642 Errors Listed------------



ArtistsSongs(Composer) Check Values           **ERROR**
---------------------Details-----------------------------
SELECT * 
    FROM (SELECT Artists.ID AS IDArtist, Artists.Artist AS Artist, Songs.ID AS IDSong, Songs.Author AS Composer,  Songs.AlbumArtist, Songs.SongTitle, Songs.Album 
    FROM Artists, ArtistsSongs, Songs 
    WHERE ArtistsSongs.PersonType=3 
    AND Artists.ID=ArtistsSongs.IDArtist 
    AND ArtistsSongs.IDSong=Songs.ID) 
    WHERE Composer NOT LIKE '%'||REPLACE(REPLACE(Artist,'@','@@'),';',';;')||'%' 
[IDARTIST] [ARTIST] [IDSONG] [COMPOSER] [ALBUMARTIST] [SONGTITLE] [ALBUM] 
[88593] [Louis Armstrong] [1893112] [Various Artists] [Homebrew] [Once I Had A Friend (Kon's Quick Edit)] [Kon & Amir Present Off Track Volume One:...] 
[88593] [Louis Armstrong] [1895145] [Various Artists] [Various Artists] [San Francisco Is A Lonely Town] [Late Night Tales: Nouvelle Vague] 
[88593] [Louis Armstrong] [1897244] [Various Artists] [Various Artists] [Creed - What If] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897245] [Various Artists] [Various Artists] [Slipknot - Wait And Bleed] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897246] [Various Artists] [Various Artists] [Finger Eleven - Suffocate] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897247] [Various Artists] [Various Artists] [System Of A Down - Spiders] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897248] [Various Artists] [Various Artists] [American Pearl - Automatic] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897249] [Various Artists] [Various Artists] [Sevendust - Fall] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897250] [Various Artists] [Various Artists] [Godsmack - Time Bomb] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897251] [Various Artists] [Various Artists] [Coal Chamber - Tyler's Song] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897252] [Various Artists] [Various Artists] [Static-X - So Real] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897253] [Various Artists] [Various Artists] [Incubus - Crowded Elevator] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897254] [Various Artists] [Various Artists] [Dope - Debonaire] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897255] [Various Artists] [Various Artists] [Fuel - Sunburn] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897256] [Various Artists] [Various Artists] [Powerman 5000 - Get On, Get Off] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897257] [Various Artists] [Various Artists] [Full Devil Jacket - Wanna' Be Martyr] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897258] [Various Artists] [Various Artists] [Orgy - Dissention] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897259] [Various Artists] [Various Artists] [Staind - Crawl] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897260] [Various Artists] [Various Artists] [Ear2000 - Click Click] [Scream 3 [OST]] 
[88593] [Louis Armstrong] [1897261] [Various Artists] [Various Artists] [Creed - Is This The End] [Scream 3 [OST]] 
---------------- 20 OF 192 Errors Listed------------
 
ArtistsSongs(Conductor) Check Counts          OK
ArtistsSongs(Conductor) Check Values          OK
ArtistSongs(Lyricist) Check Counts            OK
ArtistsSongs(Lyricist) Check Values           OK
GenresSongs(Genre) Check Count                OK
GenresSongs(Genre) Check Values               OK
ArtistsAlbums(Album) Check Count              OK
ArtistsAlbums(Album) Check EQUAL Values       **ERROR**
---------------------Details-----------------------------
SELECT * 
    FROM (SELECT Artists.ID AS IDArtist, Artists.Artist AS Name, Albums.ID As IDAlbum, Albums.Artist AS AlbumArtist 
    FROM Artists, ArtistsAlbums, Albums 
    WHERE ArtistsAlbums.IDArtist=Artists.ID 
    AND ArtistsAlbums.IDAlbum=Albums.ID) 
    WHERE AlbumArtist <> Name 
    AND AlbumArtist NOT LIKE '%;%' 
[IDARTIST] [NAME] [IDALBUM] [ALBUMARTIST] 
[91579] [Beenie Man] [95427] [Beck] 
[97611] [Prince] [100032] [The Beach Boys] 
[91579] [Beenie Man] [100036] [Beck] 
[91579] [Beenie Man] [104843] [Beck] 
[91579] [Beenie Man] [104844] [Beck] 
[97222] [Rancid] [104910] [Billie Holiday] 
[91502] [Pulp] [114814] [The Beatles] 
[91502] [Pulp] [114819] [The Beatles] 
[91502] [Pulp] [114820] [The Beatles] 
[91502] [Pulp] [114824] [The Beatles] 
[91502] [Pulp] [114834] [The Beatles] 
[91502] [Pulp] [114849] [The Beatles] 
[88593] [Louis Armstrong] [148623] [Various Artists] 
[88593] [Louis Armstrong] [148625] [Various Artists] 
[88593] [Louis Armstrong] [148742] [Various Artists] 
[88593] [Louis Armstrong] [149253] [Various Artists] 
[88593] [Louis Armstrong] [149456] [Various Artists] 
[97611] [Prince] [149576] [The Beach Boys] 
[97611] [Prince] [149577] [The Beach Boys] 
[97611] [Prince] [149578] [The Beach Boys] 
---------------- 20 OF 1691 Errors Listed------------
 
ArtistsAlbums(Album) Check LIKE Values        **ERROR**
---------------------Details-----------------------------
SELECT * 
    FROM (SELECT Artists.ID AS IDArtist, Artists.Artist AS Name, Albums.ID As IDAlbum, Albums.Artist AS AlbumArtist 
    FROM Artists, ArtistsAlbums, Albums 
    WHERE ArtistsAlbums.IDArtist=Artists.ID 
    AND ArtistsAlbums.IDAlbum=Albums.ID) 
    WHERE AlbumArtist NOT LIKE '%'||REPLACE(REPLACE(Name,'@','@@'),';',';;')||'%' 
[IDARTIST] [NAME] [IDALBUM] [ALBUMARTIST] 
[91579] [Beenie Man] [95427] [Beck] 
[97611] [Prince] [100032] [The Beach Boys] 
[91579] [Beenie Man] [100036] [Beck] 
[91579] [Beenie Man] [104843] [Beck] 
[91579] [Beenie Man] [104844] [Beck] 
[97222] [Rancid] [104910] [Billie Holiday] 
[91502] [Pulp] [114814] [The Beatles] 
[91502] [Pulp] [114819] [The Beatles] 
[91502] [Pulp] [114820] [The Beatles] 
[91502] [Pulp] [114824] [The Beatles] 
[91502] [Pulp] [114834] [The Beatles] 
[91502] [Pulp] [114849] [The Beatles] 
[88593] [Louis Armstrong] [148623] [Various Artists] 
[88593] [Louis Armstrong] [148625] [Various Artists] 
[88593] [Louis Armstrong] [148742] [Various Artists] 
[88593] [Louis Armstrong] [149253] [Various Artists] 
[88593] [Louis Armstrong] [149456] [Various Artists] 
[97611] [Prince] [149576] [The Beach Boys] 
[97611] [Prince] [149577] [The Beach Boys] 
[97611] [Prince] [149578] [The Beach Boys] 
---------------- 20 OF 1692 Errors Listed------------

 
What causes this? I use MixMeister BPM to do lots of BPM identificcation in the background, but that's almost the only thing I think I should need to sync tags for (one thing I haven't done).

At a glance, the DB doesn't seem happy with all the tag changes I'm making (so many tracks essentially being changed from "1 track albums" to songs on a compilation - that's the main thing I've done here. Lots of comps!)

I'm just after info, and advice, if possible. Can anyone help? I don't yet fully understand databases, i.e. how it all links up, how to use the SQL viewer to fix these... in the past I've grabbed a few and resaved the same tags, to hopefully "update" thedatabase... but now I have "thousands of DB errors".

Many thanks in advance for any info
Grateful noob

zephyr
Posts: 101
Joined: Fri Oct 07, 2011 2:56 pm

Re: Database Errors?

Post by zephyr » Sat Mar 17, 2012 8:41 pm

Ah. Perhaps... the magicnode show "albums with multi folders" based on album name? I got that with the unknown albums, but thought albums are distinguished by (album)artist AND name... perhaps not with this node...
Grateful noob

Post Reply