[Milhouse]

Great work with the MySQL support, however while it is connecting and querying the db correctly, the add-on isn't working as expected.

It appeared to work through all the sets correctly, then displayed "0 artwork updated".

In the log, it seems to be accessing the filesystem incorrectly, always trying to find the "folder.jpg" and "fanart.jpg" in the parent of the set folder.

For example, I have three set folders as follows:

Code:

nfs://192.168.0.3/mnt/share/media/Video/Movies HD/Alien Anthology
nfs://192.168.0.3/mnt/share/media/Video/Comedy/Bill Bailey
nfs://192.168.0.3/mnt/share/media/Video/Movies/Foreign Language/Stieg Larsson Millennium Trilogy

yet the add-on is searching for folder.jpg and fanart.jpg in "Movies HD", "Comedy" and "Foreign Language", not the set folders "Alien Anthology", "Bill Bailey" and "Stieg Larsson Millennium Trilogy".

Log here: http://pastebin.ca/2309575

One question with the "common folder" technique, would the add-on need to process the individual movies if it can find a suitable folder.jpg and fanart.jpg in the set folder (as defined by the sets table)? ie. check the set folder for folder.jpg and fanart.jpg before checking any movies, and if the image(s) exist then use them and move on to the next set. Or maybe the add-on needs a third setting, "Use set tag only" and don't infer set membership from the filesystem (common parent), rely only on the metadata (database).