Genre Finder 5.0 - Updated 05/08/2012

Kevinowpb · Post by **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!

trixmoto · Post by **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.

NEXTstep · Post by **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

Kevinowpb · Post by **Kevinowpb** » Fri Jan 18, 2008 9:06 pm

see below

Kevinowpb · Post by **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?

trixmoto · Post by **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.

ashenkin · Post by **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

trixmoto · Post by **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.

ashenkin · Post by **ashenkin** » Wed Jan 23, 2008 12:08 pm

Thanks again, trixmoto. Have you thought about allowing a file-based white/black list?

riffcat · Post by **riffcat** » Wed Jan 23, 2008 2:35 pm

50,000+ songs and track mode make my monkey3 /cry

trixmoto · Post by **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?

ashenkin · Post by **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

p8137400 · Post by **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

Azaniah · Post by **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

trixmoto · Post by **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.

Genre Finder 5.0 - Updated 05/08/2012

ERROR

?

Assigning genres based on previously tagged songs