Genre Finder 5.0 - Updated 05/08/2012

Download and get help for different MediaMonkey Addons.

Moderators: Peke, Gurus

ERROR

Postby Kevinowpb » Fri Jan 18, 2008 2:06 pm

What's this all about?

Error: Starting a translation while some query is open.

Running queries are:
SELECT songs. *
FROM songs
WHERE songs.ID=479

(C:\Sources\MediaMonkeyRelease\MP3Datab\SQLiteDB.pas, line 188)

I get this alot when trying to run Duplicate Reports script and the Genre Finder script....

HELP!

Thanks!
Kevinowpb
 
Posts: 119
Joined: Sat Dec 22, 2007 10:18 am
Location: West Palm Beach

Postby trixmoto » Fri Jan 18, 2008 2:45 pm

My "Duplicate Report" script has not been updated for MM3 so I wouldn't advice using it just yet. I've not received those errors before with this script, but I know what causes them so I'll make sure they are resolved in the next version.
Check out my scripts at trixmoto.net and subscribe to my RSS feed for updates.
Also check out my Uniface blog.
Get a free Dropbox account! :o

Image
trixmoto
 
Posts: 9711
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK

?

Postby NEXTstep » Fri Jan 18, 2008 8:26 pm

bob61 wrote:Input: Artist=Crazy Train, Song=Butterfly

I tried this:
Genre | White | *%Rock=Rock
Also tried:
Genre | White | *,%Rock=Rock

I received the error messages:
"There was a problem querying the database: Error executing SQL "SELECT FROM Song" : near "FROM" : syntax error (1.1)
and Error #2147418113
File: "C:\Program Files\MediaMonkey3\Scripts\Auto\GenreFinder.vbs, Line:1545, Column: 16

I then ran with no selection:
Returns "Rock" as Genre

I ran with Whitelist = "*"
Also returns "Rock" as Genre

So not sure what's going wrong with the using of % wildcard and =.


Do you mean Crazy Town? possibly... there is no artist I know of named Crazy Train... but there is a band called Crazy Town with a song called Butterfly
NEXTstep
 

Postby Kevinowpb » Fri Jan 18, 2008 9:06 pm

see below
Last edited by Kevinowpb on Fri Jan 18, 2008 9:08 pm, edited 1 time in total.
Kevinowpb
 
Posts: 119
Joined: Sat Dec 22, 2007 10:18 am
Location: West Palm Beach

Postby Kevinowpb » Fri Jan 18, 2008 9:07 pm

trixmoto wrote:My "Duplicate Report" script has not been updated for MM3 so I wouldn't advice using it just yet. I've not received those errors before with this script, but I know what causes them so I'll make sure they are resolved in the next version.




Im using the GenreFinder when I am getting these errors...
I used the Duplicate finder up until you told me it wasnt ready for MM3 yet... so... thats irrelevent at this point.. what's causing it in GenreFinder?
Kevinowpb
 
Posts: 119
Joined: Sat Dec 22, 2007 10:18 am
Location: West Palm Beach

Postby trixmoto » Sat Jan 19, 2008 10:39 am

As discussed via email, please send me a logfile as this should help me work out at least where in the script this is occurring.
Check out my scripts at trixmoto.net and subscribe to my RSS feed for updates.
Also check out my Uniface blog.
Get a free Dropbox account! :o

Image
trixmoto
 
Posts: 9711
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK

Postby ashenkin » Wed Jan 23, 2008 11:58 am

Hello Folks,

First, Trixmoto, thanks a ton for all your work.

I have a couple questions. First, while I think I'm starting to understand the whitelist, what is the blacklist used for? (i.e., what's the difference between a blacklist of "+bebop" and whitelist of "-bebop")?

I'm wondering about workflows for how people update the genres of their entire library (something I need to do). I have 8000+ songs to tag. Do people tag everthing with lastfm, then make some massive whitelist with lots of translations and then re-tag?

This last point makes me wonder: is there any limit to the field length in the whitelist?

Thanks again.

allie
ashenkin
 
Posts: 118
Joined: Sun Oct 30, 2005 12:03 pm

Postby trixmoto » Wed Jan 23, 2008 12:00 pm

There is a limit in the whitelist, which is why I created the auto whitelist originally. No idea what it is though, quite large!

A whitelist will only allow the values in the list. However, a blacklist will accept any value unless it is in the list.
Check out my scripts at trixmoto.net and subscribe to my RSS feed for updates.
Also check out my Uniface blog.
Get a free Dropbox account! :o

Image
trixmoto
 
Posts: 9711
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK

Postby ashenkin » Wed Jan 23, 2008 12:08 pm

Thanks again, trixmoto. Have you thought about allowing a file-based white/black list?
ashenkin
 
Posts: 118
Joined: Sun Oct 30, 2005 12:03 pm

Postby riffcat » Wed Jan 23, 2008 2:35 pm

50,000+ songs and track mode make my monkey3 /cry
riffcat
 
Posts: 13
Joined: Fri Dec 07, 2007 8:23 pm

Postby trixmoto » Wed Jan 23, 2008 3:35 pm

@riffcat - well it probably will if you try to do them all at once!! Try doing them in more reasonable batches.

@ashenkin - I can honestly say I haven't. Is there really any need for this?
Check out my scripts at trixmoto.net and subscribe to my RSS feed for updates.
Also check out my Uniface blog.
Get a free Dropbox account! :o

Image
trixmoto
 
Posts: 9711
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK

Postby ashenkin » Fri Jan 25, 2008 9:10 am

trixmoto,

Thx for the reply. Not sure if there's a need for it - I was just thinking that if one is reorganizing possibly hundreds of genres from last.fm, it might be useful to be able to do it from a file. But I haven't gone through the motions yet, so i speak from inexperience.

Also, if anyone is willing to share their black/white lists, I'd love to see them.

thanks,
allie
ashenkin
 
Posts: 118
Joined: Sun Oct 30, 2005 12:03 pm

Assigning genres based on previously tagged songs

Postby p8137400 » Wed Jan 30, 2008 6:15 pm

hi there,
great script but just one query for a possible feature: often I get new songs in my database which I need to tag but for which I have already tagged the genre for other songs by the same artist. Would it be possible in any way to tag these songs based on my other existing genre tags?
Maybe something for a next version?

cheers
p8137400
 
Posts: 2
Joined: Wed Jan 30, 2008 8:44 am

Postby Azaniah » Thu Jan 31, 2008 6:26 am

I am not sure if I am doing something daft (which is quite likely) but in the setup I can only see Track mode (not album or artist).

Also, whenever I run GF for more than 1 track (and I am only doing an album at a time whilst I get used to this), the confirmation prompt appears correctly, you accept and then I have "GenreFinder: Saving Selected changes" stuck in the status bar appearing to be 60% or so complete.

Running 2.6 on MM3, vista 64bit.

Any suggestions?

By the way, thanks once again for another great script :D
Azaniah
 
Posts: 28
Joined: Thu Jun 01, 2006 6:57 am

Postby trixmoto » Thu Jan 31, 2008 12:11 pm

@p8137400 - this is planned for the next version, if I can get it working correctly! :)

@Azaniah - album and artist modes are not currently available in MM3 - they're gonna take a little more work to get working correctly with multiple artists, etc.
Check out my scripts at trixmoto.net and subscribe to my RSS feed for updates.
Also check out my Uniface blog.
Get a free Dropbox account! :o

Image
trixmoto
 
Posts: 9711
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK

PreviousNext

Return to Need Help with Addons?

Who is online

Users browsing this forum: cphorvat, Google [Bot] and 10 guests