SQL-Viewer 2.4 [Script] 2009-10-25

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: SQL-Viewer 2.4 [Script] 2009-10-25

Post by trixmoto » Thu Aug 21, 2014 8:20 am

chrisjj wrote:Not just switch on the first keyword, then?
No.
chrisjj wrote:Simplest is to accurately label the buttons.
What is misleading about "Run Select Query" - you click this one when you want to run a SELECT query.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

chrisjj
Posts: 4933
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

Re: SQL-Viewer 2.4 [Script] 2009-10-25

Post by chrisjj » Thu Aug 21, 2014 8:31 am

trixmoto wrote:
chrisjj wrote:Not just switch on the first keyword, then?
No.
Yes is suggested by your

1) ... SELECT queries.
2) ... for UPDATE/INSERT/DELETE queries.
chrisjj wrote:Simplest is to accurately label the buttons.
Sorry. Now corrected to "Simplest is to accurately label the button."
Chris

trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: SQL-Viewer 2.4 [Script] 2009-10-25

Post by trixmoto » Thu Aug 21, 2014 9:02 am

I give up.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.

Izzyman12078
Posts: 1
Joined: Wed Apr 29, 2015 9:51 pm

Re: SQL-Viewer 2.4 [Script] 2009-10-25

Post by Izzyman12078 » Thu May 14, 2015 12:27 pm

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

Guest

Re: SQL-Viewer 2.4 [Script] 2009-10-25

Post by Guest » Fri May 15, 2015 2:36 am

Izzyman12078

The script 'Tagging Inconsistencies' is ready made for this. In the Album Art Nodes Settings of that script, there's an option for 'Many Album Art'.

http://www.mediamonkey.com/forum/viewtopic.php?p=73421

Post Reply