by wydchr » Wed Oct 02, 2019 3:49 am
Hi,
I'm having a problem with Tagging Inconsistencies version 4.0.128 with MM4 4.1.24.1883 on Windows 10, when I try to access the menu item <Albums with... (Album Art)> I get the following error:
Error #-2147418113 - SongsDB.SBdatabase
Error executing SQL "INSERT INTO TmpTagInconsCoversTra0 SELECT IDSong, IDAlbum, Album, AlbumArtist, SUBSTR(Year,1,4) Year,
SUBSTR(SUBSTR(CoverPath,0,LENGTH(CoverPath)-LENGTH(GETEXTENSION(CoverPath))),LENGTH(RTRIM(CoverPath,REPLACE(CoverPath,'\','')))+1)FileName,Songlength, COUNT() CovCnt,COUNT(CASE WHEN CoverStorage=1 THE" : SELECTs to the left and right of UNION do not have the same number of result columns (1,1)
File: "C:\Program Files (x86)\MediaMonkey\Scripts\Auto\TaggingInconsistencies.vbs, Line:2017, Column: 2
I can't remember if I have actually tried to use this item before so I can't say whether it has ever worked for me before or not. I have a song database of 50,000+ songs which is kept on a NAS device.
Checking the script doesn't offer any clues to me so any help from anyone that could point me the right direction to fix this (or tell me what I'm doing wrong?) would be greatly appreciated.
p.s. I had to type out the text of the error dialogue box as adding a link to an image of it in Dropbox didn't appear to work??
cheers,
David
Hi,
I'm having a problem with Tagging Inconsistencies version 4.0.128 with MM4 4.1.24.1883 on Windows 10, when I try to access the menu item <Albums with... (Album Art)> I get the following error:
Error #-2147418113 - SongsDB.SBdatabase
Error executing SQL "INSERT INTO TmpTagInconsCoversTra0 SELECT IDSong, IDAlbum, Album, AlbumArtist, SUBSTR(Year,1,4) Year,
SUBSTR(SUBSTR(CoverPath,0,LENGTH(CoverPath)-LENGTH(GETEXTENSION(CoverPath))),LENGTH(RTRIM(CoverPath,REPLACE(CoverPath,'\','')))+1)FileName,Songlength, COUNT() CovCnt,COUNT(CASE WHEN CoverStorage=1 THE" : SELECTs to the left and right of UNION do not have the same number of result columns (1,1)
File: "C:\Program Files (x86)\MediaMonkey\Scripts\Auto\TaggingInconsistencies.vbs, Line:2017, Column: 2
I can't remember if I have actually tried to use this item before so I can't say whether it has ever worked for me before or not. I have a song database of 50,000+ songs which is kept on a NAS device.
Checking the script doesn't offer any clues to me so any help from anyone that could point me the right direction to fix this (or tell me what I'm doing wrong?) would be greatly appreciated.
p.s. I had to type out the text of the error dialogue box as adding a link to an image of it in Dropbox didn't appear to work??
cheers,
David