Can someone help me with a SQL to find all albums or tracks with say greater than 100 Album Arts associated? Might seem strange but I've been having a problem with MM crashing and support says:
"....we are saying that some of your tracks have 450 album arts associated with a single track, this is not a normal amount of art for just one track and seems to cause the issue. "

They then immediately closed my ticket and offered no further help after I installed the debug version and sent them the logs.

I don't know how that would be possible but I have 50,000 tracks and would like to identify the culprit(s).

Thanks

Can someone help me with a SQL to find all albums or tracks with say greater than 100 Album Arts associated? Might seem strange but I've been having a problem with MM crashing and support says:"....we are saying that some of your tracks have 450 album arts associated with a single track, this is not a normal amount of art for just one track and seems to cause the issue. "

They then immediately closed my ticket and offered no further help after I installed the debug version and sent them the logs.

I don't know how that would be possible but I have 50,000 tracks and would like to identify the culprit(s).

trixmoto wrote:With string manipulation it can actually be pretty tricky to work out which is required for a complex SQL statement, and it's far too much work ...

Not just switch on the first keyword, then?

trixmoto wrote:The fact is that the MM API provides two different methods, so it's simplest to have a button for each, and the user (who should know what they're doing)
can make the decision themselves - power to the user!

Well, the user who knows what he is doing is not going to know what the program is doing whilst the program continues to mislead him with the label "Execute DDL/DML Statement".

Simplest is to accurately label the button. That is what is most useful to a user who knows what he is doing.

[quote="trixmoto"]With string manipulation it can actually be pretty tricky to work out which is required for a complex SQL statement, and it's far too much work ...[/quote]

Not just switch on the first keyword, then?

[quote="trixmoto"]The fact is that the MM API provides two different methods, so it's simplest to have a button for each, and the user (who should know what they're doing) can make the decision themselves - power to the user![/quote]

Well, the user who knows what he is doing is not going to know what the program is doing whilst the program continues to mislead him with the label "Execute DDL/DML Statement".

Simplest is to accurately label the button. That is what is most useful to a user who knows what he is doing.

Yeah, Bex and I talked about that a while ago (probably years ago ). With string manipulation it can actually be pretty tricky to work out which is required for a complex SQL statement, and it's far too much work to try and build a tokenizer and all that nonsense just for this. The fact is that the MM API provides two different methods, so it's simplest to have a button for each, and the user (who should know what they're doing) can make the decision themselves - power to the user!

Yeah, [b]Bex[/b] and I talked about that a while ago (probably years ago :-?). With string manipulation it can actually be pretty tricky to work out which is required for a complex SQL statement, and it's far too much work to try and build a tokenizer and all that nonsense just for this. The fact is that the MM API provides two different methods, so it's simplest to have a button for each, and the user (who should know what they're doing) can make the decision themselves - power to the user!

Ah, thx. Since i wasnt sure, i gave it a try:
License isnt valid for 4.0. And then it didnt upgrade anyway, neither did it know, where my MM.DB resides, nor my music collection. And it failed to adapt the localisation. So i reverted from a backup to the 3.0 state. Still sitting duck when it comes to my playlist problem. They have all been invalidated since i applied the suggestion from this forum to use UNC for network drives. (Which solved one big problem, but left me with a smaller one: hundreds of carefully maintained playlists basically gone if i do not find a way to programmatically adapt them with the new "location" of the files.
Yes, sucks to be me.

Ah, thx. Since i wasnt sure, i gave it a try:License isnt valid for 4.0. :-( And then it didnt upgrade anyway, neither did it know, where my MM.DB resides, nor my music collection. And it failed to adapt the localisation. So i reverted from a backup to the 3.0 state. Still sitting duck when it comes to my playlist problem. They have all been invalidated since i applied the suggestion from this forum to use UNC for network drives. (Which solved one big problem, but left me with a smaller one: hundreds of carefully maintained playlists basically gone if i do not find a way to programmatically adapt them with the new "location" of the files.Yes, sucks to be me. ;-)

Lost_in_space wrote:Although I am aware that MM4 is long avail, i stick with MM3, coz i have life-licence for it.
To circumvent the IUnicode-Problem, i want to install SQLViewer, as it looks like that should do it.
Unfortunately, after hours of trying... no luck. I tried from the Admin's Desktop, also from mine with "Run as adminitrator". Everywhere it complains (after several seconds) like "invalid install package" (Message is localized). I even unzipped the mmip file and upped the version numbers to try that. - Did not help.
Can it be related with me using Win7x64 ? And after finally having moved to UNC pathname to avoid losing my DB regularly, since the Audio files reside on a network...
ALL of my Playlists now have invalid entries (basically lost), except if i was allowed to fix that on my own.

What can i do? My Collection is huge (>30,000 files) No way going in by hand!

Any recommendations? Please...

Oh, btw: just for kicks i tried several other mmips from this website and the problem was the same in every case.
But by searching for solutions to this problem, i couldnt find anything, not a single report. That is why i am asking for help now (in 2013!)

Lifetime License gives you full gold function of ANY MM version. So go for 4! Now if you only bought a cheaper MM3 version license.. sucks to be you.

[quote="Lost_in_space"]Although I am aware that MM4 is long avail, i stick with MM3, coz i have life-licence for it.To circumvent the IUnicode-Problem, i want to install SQLViewer, as it looks like that should do it.Unfortunately, after hours of trying... no luck. I tried from the Admin's Desktop, also from mine with "Run as adminitrator". Everywhere it complains (after several seconds) like "invalid install package" (Message is localized). I even unzipped the mmip file and upped the version numbers to try that. - Did not help.Can it be related with me using Win7x64 ? And after finally having moved to UNC pathname to avoid losing my DB regularly, since the Audio files reside on a network...ALL of my Playlists now have invalid entries (basically lost), except if i was allowed to fix that on my own.

What can i do? My Collection is huge (>30,000 files) No way going in by hand!

Any recommendations? Please...

Oh, btw: just for kicks i tried several other mmips from this website and the problem was the same in every case.But by searching for solutions to this problem, i couldnt find anything, not a single report. That is why i am asking for help now (in 2013!)[/quote]

Lifetime License gives you full gold function of ANY MM version. So go for 4! Now if you only bought a cheaper MM3 version license.. sucks to be you. ;)

Oops, i forgot to mention: all the addons are actually visible from the extentions dialog. Only i couldnt find an interface to them. Maybe is was while trying to install that, that the error message got generated? And while looking at every Menu, Button, RMB ... Hot to GET THIS PARTY STARTED???

Oops, i forgot to mention: all the addons are actually visible from the extentions dialog. Only i couldnt find an interface to them. Maybe is was while trying to install that, that the error message got generated? And while looking at every Menu, Button, RMB ... Hot to GET THIS PARTY STARTED???

Although I am aware that MM4 is long avail, i stick with MM3, coz i have life-licence for it.
To circumvent the IUnicode-Problem, i want to install SQLViewer, as it looks like that should do it.
Unfortunately, after hours of trying... no luck. I tried from the Admin's Desktop, also from mine with "Run as adminitrator". Everywhere it complains (after several seconds) like "invalid install package" (Message is localized). I even unzipped the mmip file and upped the version numbers to try that. - Did not help.
Can it be related with me using Win7x64 ? And after finally having moved to UNC pathname to avoid losing my DB regularly, since the Audio files reside on a network...
ALL of my Playlists now have invalid entries (basically lost), except if i was allowed to fix that on my own.

What can i do? My Collection is huge (>30,000 files) No way going in by hand!

Any recommendations? Please...

Oh, btw: just for kicks i tried several other mmips from this website and the problem was the same in every case.
But by searching for solutions to this problem, i couldnt find anything, not a single report. That is why i am asking for help now (in 2013!)

Although I am aware that MM4 is long avail, i stick with MM3, coz i have life-licence for it.To circumvent the IUnicode-Problem, i want to install SQLViewer, as it looks like that should do it.Unfortunately, after hours of trying... no luck. I tried from the Admin's Desktop, also from mine with "Run as adminitrator". Everywhere it complains (after several seconds) like "invalid install package" (Message is localized). I even unzipped the mmip file and upped the version numbers to try that. - Did not help.Can it be related with me using Win7x64 ? And after finally having moved to UNC pathname to avoid losing my DB regularly, since the Audio files reside on a network...ALL of my Playlists now have invalid entries (basically lost), except if i was allowed to fix that on my own.

What can i do? My Collection is huge (>30,000 files) No way going in by hand!

Any recommendations? Please...

Oh, btw: just for kicks i tried several other mmips from this website and the problem was the same in every case.But by searching for solutions to this problem, i couldnt find anything, not a single report. That is why i am asking for help now (in 2013!)

my first installation of media monkey 4 was good because i didnt know that it can be installed in portable mode . so i installed it and made it portable myself as i always do and nothing went wrong

the problem appeared when i wanted to install it on my other pc and this time i noticed the portable check box and i installed it on my previous portable folder .
this is what happened to the music paths in my library

as you can see the start (shared) section of the path which was d:\media\audio\music has changed to [MUSIC] and i dont know how to fix it. i hoped that by writing a config line like this [music]=d:\media\audio\music\ would solve the problem but despite trying all the combinations i could guess , im still unable to fix this problem. please help

thanks in advance

hey

my first installation of media monkey 4 was good because i didnt know that it can be installed in portable mode . so i installed it and made it portable myself as i always do and nothing went wrong

the problem appeared when i wanted to install it on my other pc and this time i noticed the portable check box and i installed it on my previous portable folder .this is what happened to the music paths in my library [url=http://www.sorakheboz.org/ax/viewer.php?file=93521243514719747384.jpg][img]http://www.sorakheboz.org/ax/images/93521243514719747384_thumb.jpg[/img][/url]

as you can see the start (shared) section of the path which was d:\media\audio\music has changed to [MUSIC] and i dont know how to fix it. i hoped that by writing a config line like this [music]=d:\media\audio\music\ would solve the problem but despite trying all the combinations i could guess , im still unable to fix this problem. please help