Database Tools

[nynaevelan]

Owyn and company:

I need some help with an error which I am getting in MM4. First, in order to get the scripts to work in mm4 I had to change the name of the filters table in the scripts but after that everything is working as it should. Now this is my error:

Code: Select all

Database Statistics
Table                              Seq   Count   MaxID
------------------------------ ------- ------- -------
Albums                           11587    5764   11587
Artists                           5995    2974    5995
ArtistsAlbums                    11552    5758   11552
ArtistsSongs                    242081   20199  242081
Covers                          189657   19999  189657
DEISyncLog                      686748  686748  686748
DeviceCollectionConfig            5169     793    5169
DeviceTracks                    163247    3642  163247
Devices                             62      13      62
Folders                            111      46      95 ***ERROR***
FoldersHier                        434     203     373
Genres                              65      20      58
GenresSongs                     226339   19491  226339
ListsSongs                     1851642  211781 1851642
MediaConnections                   682     682     682
MediaServerFilters                  30      27      30
MediaServerPlaylists               223     193     223
PathProcessing                   19305       0         
Played                          378302  185257  378302
PlaylistSongs                    62116   15857   62116
Playlists                         3213     430    3213
Songs                            37973   19491   37973
SynchCollection                      4       0         
SynchPlaylist                      935     134     935
Views                               73      61      73

Anyone have any ideas how to fix something like this??

Nyn

[MusicBringer]

Nyn, sorry I do not have the answer for you.
In fact I too am getting an error when using the clean up script with MM4.
Is there any chance you could tell me how to fix it so it works with MM4 - I'm not a coder so it's gotta be simple - alternatively might you sent me an updated version please.



Thanks,

[nynaevelan]

Change the DeviceFilters to DeviceTracks, you can do it with a find and replace in notepad to change it, just make sure when you save it it still has it's vbs extension and not txt.

[MusicBringer]

Nyn, yeah I dun it
Then ran the script and it worked. Hooray.
Thanks so much for helping me.

[Ooh err missus, it's me Five Hundredth post]

[martialartsguy]

Any chance of getting this updated for MM4? I've got the audit db tool to work with changes suggested by nyn, but no idea where the DB_Clean goes after installing the mmip.

[zephyr]

Hi, I'm getting a few errors that aren't being fixed by running the clean script. Any ideas what the causes (and hopefully solutions) are?

Many thanks!

Code: Select all

ArtistsSongs(Artist) Check Values             **ERROR**
---------------------Details-----------------------------
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]
[145178] [The Beach Boys] [1469850] [Audio Bullys] [Snake] [Ego War]
[145178] [The Beach Boys] [1469851] [Audio Bullys] [100 Million] [Ego War]
[145178] [The Beach Boys] [1469852] [Audio Bullys] [Way Too Long] [Ego War]
[145178] [The Beach Boys] [1469853] [Audio Bullys] [Turned Away] [Ego War]
[145178] [The Beach Boys] [1469854] [Audio Bullys] [Real Life] [Ego War]
[145178] [The Beach Boys] [1469855] [Audio Bullys] [We Don't Care] [Ego War]
[145178] [The Beach Boys] [1469856] [Audio Bullys] [Face In A Cloud] [Ego War]
[145178] [The Beach Boys] [1469857] [Audio Bullys] [The Tyson Shuffle] [Ego War]
[145178] [The Beach Boys] [1469858] [Audio Bullys] [The Things] [Ego War]
[145178] [The Beach Boys] [1469859] [Audio Bullys] [Veteran] [Ego War]
[145178] [The Beach Boys] [1469860] [Audio Bullys] [The Snow] [Ego War]
[145178] [The Beach Boys] [1469861] [Audio Bullys] [I Go To Your House] [Ego War]
[145178] [The Beach Boys] [1469862] [Audio Bullys] [Hit The Ceiling] [Ego War]
[145178] [The Beach Boys] [1469863] [Audio Bullys] [Ego War] [Ego War]
[152378] [Isolée] [1542179] [Isole´e] [Pictureloved] [We Are Monster]
[152378] [Isolée] [1542180] [Isole´e] [Schrapnell] [We Are Monster]
[152378] [Isolée] [1542181] [Isole´e] [Enrico] [We Are Monster]
[152378] [Isolée] [1542182] [Isole´e] [Madchen Mit Hase] [We Are Monster]
[152378] [Isolée] [1542183] [Isole´e] [My Hi-Matic] [We Are Monster]
[152378] [Isolée] [1542184] [Isole´e] [Do Re Mi] [We Are Monster]
---------------- 20 OF 24 Errors Listed------------

ArtistsSongs(Composer) Check Counts           OK
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]
[184768] [Asa de A´guia] [1889120] [Asa de Águia] [Axe] [Abalou] [Axé Bahia 2004]
---------------- 1 OF 1 Errors Listed------------

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]
[145178] [The Beach Boys] [149353] [Audio Bullys]
[145178] [The Beach Boys] [149445] [Audio Bullys]
---------------- 2 OF 2 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]
[145178] [The Beach Boys] [149353] [Audio Bullys]
[145178] [The Beach Boys] [149445] [Audio Bullys]
[152378] [Isolée] [158372] [Isole´e]
---------------- 3 OF 3 Errors Listed------------
 
Songs->Albums: Check Values                   **ERROR**
---------------------Details-----------------------------
SELECT Songs.ID AS IDSong, Songs.Album AS SongAlbum, Songs.IDAlbum AS IDAlbum, Albums.Album AS Album
    FROM Songs, Albums
    WHERE Songs.IDAlbum = Albums.ID
    AND TRIM(Songs.Album)<>Albums.Album
[IDSONG] [SONGALBUM] [IDALBUM] [ALBUM]
[1871678] [Beyond the Wall] [186947] [Beyond the Wall]
[1871683] [Beyond the Wall] [186947] [Beyond the Wall]
[1871684] [Beyond the Wall] [186947] [Beyond the Wall]
[1871685] [Beyond the Wall] [186947] [Beyond the Wall]
[1871686] [Beyond the Wall] [186947] [Beyond the Wall]
---------------- 5 OF 5 Errors Listed------------