MusicLibrary2 - Version 5.2/5.3

[psycik]

No HtV was correct, it's actually the update time.

So for yours you would probably want:

• scan every - 1 day (I have mine on 5, my collection doesn't change that much
  
• Scan hour = 3 (= 3 am or whenever your machine starts up)
  

The update frequency you are talking about is the fast scan, which is not really relelvant for you as your machine is mostly asleep when it gets it's changes.

[psycik]

Problem: I just downloaded the latest from the wiki - hope it includes your patch - and now when I select any Artist or Album which contains a single quote character, the subordinate panes are empty (if All is selected it is OK). So Oasis (What's the Story) Morning Glory has no tracks displayed. It is all there and in the Database of course.

As for this one, did you always have a problem, or just one the recent version (5.4)??. I imagine this would probably be worse in 5.4 as I did away with some of the nice parameters in the db queries. THere was something funny about them if you were an MDB user.

I think I'll be putting them back it and doing something else for MDB - especially if I've broken yours, or are you MDB?

[melearp]

Yes, sorry I was reading the wrong line. Anyway, the question still stands, as I would like to be sure that the update occurs at a particular point (not time) in the job.

I suppose that I am a bit old fashioned in that many years ago I used to produce systems with substantial nightly processing. The best design for such systems is event based (things happen in sequence or in parallel and synchronise on events) rather than time based. It just seems messy to have one set of activities having to finish by a particular time and then wait until another time to restart. And I would have to put in reasonably large margins so that stuff didn't get entangled. Unless you have any other suggestions?

[melearp]

The quote problem is definately new. It didn't happen at all before. I am on SQLite. It is also quite consistent. I heve checked it out an several artist and album names.

[psycik]

Ok, I'll have to split my code further for the MDB users and go back to using parameters.

As for the other one I could potentially knock together a little command line app to run the update externally - hmm, isn't this how reven did things with MyMusic??

If you've got some programming experience with C# of Vb.Net you may be able to see what is exposed from ML2, but I'll have a look for you as well.

You just want it to scan all directories and update the DB?

[melearp]

I haven't done any c# or VB.Net. I use Java for serious stuff these days. But for this kind of processing I use a combination of plain old batch files plus JScript and/or VBScript with the cscript interpreter. The latter two can do most things that I need, including accessing exposed methods from other applications.

I would be very happy with the equivalent to hitting the Scan Now button in the config application. Even with a large collection this is fast and only goes to get tags for changed or new files. Removing entries for missing files would also be necessary - it's amazing how often I find it necessary to rename files (which counts as an add and a delete).

I am very grateful for the help.
And my wife likes ML2 as well.

[HtV]

Hi psycik,
I noticed quite a lot of ML2-logs in the log dir. Maybe add some automatic removing of the older ones? For the rest I'm completely happy
Re-installed the complete system last week. Something always goes wrong then doesn't it. I had everything prepared very good, clicked one ok too many in xp-install and got all my drive-letters mixed up.:eek: Took me a while too get that fixed. But as I said before I'm happy now and have time to bother other people
Cya Hans

[psycik]

Yeah i thought I had that happening, guess not - that code was from somewhere else, I guess I missed the "clean up after yourself" bit..

[melearp]

Did you get anywhere with the "quote" problem? I can't move to the latest release until that is fixed :-(

And since my last post I have picked up some c#. the syntax isn't very different from java - it's just all the libraries are different. If you are able to expose the ability to poke ML2 to do a rescan then I can do the CL utility to invoke it.

[melearp]

Just been doing a bit of tinkering. How come I never noticed this before (I must be dumb):

MusicLibrary2: DB Error retrieving titles : SQLite error near "s": syntax error
31/01/2007 15:26:03.073 VERBOSE [1] MusicLibrary2: Query: SELECT artist,title,filename,album,tracknumber,duration,datemodified,hasart,pathid,composer FROM musiclibrary WHERE excludedatabase=0 AND (pathID=2 ) AND ARTIST='Oasis' AND ALBUM='(What's The Story) Morning Glory' ORDER BY tracknumber


So the problem is not a failure of some string routine. It is as simple as the quote in the album name (or any other query string) conflictig with the syntax of sql. This must be reasonably easy to fix, but it might mean scanning the text and escaping any quotes.