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

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

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

Postby 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.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

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

Postby 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
chrisjj
 
Posts: 4926
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

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

Postby 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.
Send me BTC: 34VQPVsf9mCeR4nfhFvvBYZqQ7LkqNZ8Mn
Send me LTC: 3P1mzrfbyscdhbxRpXLgKz7tufGAU3SrEG
Send me DOGE: 9xPpYSqgF7P5yQiqvE1VqWb4UjxVCCLFJ6
Check out these great cryptocurrency faucets... BTC / LTC / DOGE
trixmoto
 
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Barton, UK

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

Postby 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
Izzyman12078
 
Posts: 1
Joined: Wed Apr 29, 2015 9:51 pm

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

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

Previous

Return to Need Help with Addons?

Who is online

Users browsing this forum: Alexa [Bot] and 11 guests