MediaMonkey forum

Hi!
Seems like I have a problem installing Tagging Inconsistencies since I have moved to Win7 (x64).
I have a "Product installation error" window after double-clicking the mmip file, and consequently no node is added to my library. Not being used to this new system yet, I hope I haven't missed something really obvious as I usually do these days (If I have, please accept my apologies in advance).
It has been one of my top 3 add-ons for almost four years now, I would be really sad if I couldn't use it any more...

Thank you for you help!

monday-friday wrote:I have a "Product installation error" window

See: http://www.mediamonkey.com/support/inde ... ticleid=59

Thank you a lot for your help. I am not used to this Win7 administrator "protection".
Everything works fine now, I am sorry for not finding the answer myself (but all other addons which I use installed correctly without running MM as administrator...so that is why I was confused!)

Similar installation problem.
Win 7 Pro 32
MM 4.02.1462


I run MM as administrator, then double click mmip to install. It says it has installed. However, there is no TI node under "Files to edit". I've done this several times (with restarts, etc), so I'm wondering whether I have several invisible installs somewhere. More to the point, I'm unable to use this great addon.

Are you looking under the 'Entire Library' node? Look at this:



If I look under 'Files to Edit' under the 'Music Only' node, TI isn't there but if I look under 'Files to Edit' under the 'Entire Library' node, it is. Don't know if that's the way it's supposed to work or not but that's the way mine is working.

@Vyper

Many thanks! You were absolutely right. Problem solved.

Cool beans.

Hi Bex, and all...

I have Tagging Inconsistencies installed. I read it could be used to identify (amongst almost everything else!) inconsistencies with (album|)artist prefixes,

The first thing I noticed upon installation and usage, is the DB inconsistencies. It seems to flag the same issues as the db audit report... I don't know what the issues are, why they are occuring, or how to fix them.

I've tried to maintain the library, and I've ran the cleanup script... but the issues still remain.

They are almost all concerning the beachboys, screen attached.


Any ideas?

THANKS!!

(db audit report info also included)
----Checking Fast Lookup (Join) Tables---
ArtistSongs(Artist) Check Counts OK
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] [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------------

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 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------------

Update:

After some analysis, I think I understand some of the audit errors flagged.

I tried using the following select statement from the audit report with Bex's SQL Viewer, but get errors when running.

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]

The errors found are

[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] [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]

When viewing these tracks, the Artist and Album Artist appear correct. Changing the Album artist does not fix. Removing and re-adding the files does not resolve.
Playing the songs in MM, the tracks are skipped, but the (recently changed and re-added) tracks all play fine in (for example) Winamp.

So, the listed artist for these songs in the ARTIST table is (incorrectly) The Beach Boys?
Why?! And how to fix?!

Any insights most welcome!

Since the conversion from MM3 to MM4, app 5000 tracks (out of our 30000 tracks library) show up in the LastPlayedDate<>LastPlayHistoryDate.
But the LastPlayedDate is exactly equal to the LastPlayHistoryDate.

Any ideas how to resolve this?

regards, Willy

If memory serves there is a change in the way MM4 is calculating dates, I do not think a solution was ever given, I just added a fake play to the tracks affected in my library.

Nyn

It's not a one-time-problem, sorry for that impression.
They keep popping up if I add playdates using AddRemovePlaystat for the songs I play on the mp3 player.
Maybe TaggingInconsistencies uses another date format than AddRemovePlaystat? Eg with/without the milliseconds?
Regards, Willy

Actually, it probably has to do with the fact that in MM4, the way the times/dates are stored for plays was changed. They're now saved as UTC times (or whatever) and then in a second column, the offset for your current time zone is saved. However, I don't think the dates/times in the Songs table (LastPlayed, DateModified, etc.) are saved like this. Thus, TI probably needs updating to account for this, instead of a simple column to column compare.

Mizery_Made wrote:Actually, it probably has to do with the fact that in MM4, the way the times/dates are stored for plays was changed. They're now saved as UTC times (or whatever) and then in a second column, the offset for your current time zone is saved. However, I don't think the dates/times in the Songs table (LastPlayed, DateModified, etc.) are saved like this. Thus, TI probably needs updating to account for this, instead of a simple column to column compare.

Bex had mentioned back in the beta phase that an update was needed but he didn't know when he would have the time to complete an update. I think there was an SQL offered that would address this issue, I would suggest you do a search in the beta forum. I am not sure if this would help, but I have this SQL saved in my SQL Viewer script but I do not remember if this is the SQL that would fix it.

I don't think I feel confident enough to do this.... a TI update to solve this would be greatly appreciated!
Regards, Willy