Page 17 of 17

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

Posted: Thu Aug 21, 2014 8:20 am
by trixmoto
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.

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

Posted: Thu Aug 21, 2014 8:31 am
by chrisjj
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."

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

Posted: Thu Aug 21, 2014 9:02 am
by trixmoto
I give up.

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

Posted: Thu May 14, 2015 12:27 pm
by Izzyman12078
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

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

Posted: Fri May 15, 2015 2:36 am
by Guest
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