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 trixmoto.net.
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 trixmoto.net.
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: No registered users and 15 guests