[Milhouse]

When first running this, it prompts "Overwrite existing movie set artwork?" - I think you should word this to make it clear the add-on will only be overwriting the "sets" artwork already scanned into the database and will not be overwriting the artwork on the movie source (ie. NAS etc.)

I'm running this on a Raspberry Pi (512MB) using OpenELEC, a remote MySQL database (scraped with Universal Scraper), and I get the following exception:

Code:

17:06:35 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - ############################################################
17:06:35 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - #    Movie Set Artwork Automator (Frodo)                   #
17:06:35 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - #    script.moviesetart                                    #
17:06:35 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - #    Trent Fitzgibbon                                      #
17:06:36 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - #    0.1.2                                                 #
17:06:36 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - #                                                          #
17:06:36 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - #    Thanks to Frost (passion-xbmc.org) for example        #
17:06:36 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - #    code used in this addon                               #
17:06:36 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - ############################################################
17:06:36 T:2950960224   DEBUG: [Movie Set Artwork Automator (Frodo)] - Search common folders: 1
17:06:36 T:2950960224   DEBUG: [Movie Set Artwork Automator (Frodo)] - Enable artwork folder: 0
17:06:36 T:2950960224   DEBUG: [Movie Set Artwork Automator (Frodo)] - Artwork folder:
17:06:36 T:2950960224   DEBUG: [Movie Set Artwork Automator (Frodo)] - Include sub folders: 0
17:06:36 T:3043512320   DEBUG: ------ Window Deinit () ------
17:06:36 T:3043512320   DEBUG: ------ Window Init () ------
17:06:36 T:2950960224   DEBUG: [Movie Set Artwork Automator (Frodo)] - Thumb filename: folder.jpg
17:06:36 T:2950960224   DEBUG: [Movie Set Artwork Automator (Frodo)] - Fanart filename: fanart.jpg
17:06:36 T:3043512320   DEBUG: ------ Window Deinit () ------
17:06:36 T:3043512320   DEBUG: ------ Window Init () ------
17:06:37 T:2950960224   DEBUG: LocalizeStrings: no strings.po file exist at /storage/.xbmc/addons/script.moviesetart.frodo/resources/language/English, fallback to strings.xml
17:06:37 T:3043512320   DEBUG: ------ Window Init (DialogYesNo.xml) ------
17:06:38 T:3043512320   DEBUG: LIRC: Update - NEW at 734181:69 0 KEY_LEFT devinput (KEY_LEFT)
17:06:38 T:3043512320   DEBUG: OnKey: 169 (a9) pressed, action is Left
17:06:38 T:3043512320   DEBUG: LIRC: Update - NEW at 734391:69 0 KEY_LEFT_UP devinput (KEY_LEFT_UP)
17:07:03 T:2858677344   DEBUG: Thread Jobworker 2858677344 terminating (autodelete)
17:07:04 T:2883585120   DEBUG: Thread Jobworker 2883585120 terminating (autodelete)
17:07:11 T:3043512320   DEBUG: LIRC: Update - NEW at 767371:160 0 KEY_OK devinput (KEY_OK)
17:07:11 T:3043512320   DEBUG: OnKey: 11 (0b) pressed, action is Select
17:07:11 T:3043512320   DEBUG: LIRC: Update - NEW at 767428:160 0 KEY_OK_UP devinput (KEY_OK_UP)
17:07:11 T:3043512320   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
17:07:11 T:2950960224  NOTICE: [Movie Set Artwork Automator (Frodo)] - Updating artwork for Movie Sets
17:07:11 T:2950960224   DEBUG: DialogProgress::StartModal called
17:07:11 T:2950960224   DEBUG: ------ Window Init (DialogProgress.xml) ------
17:07:11 T:2950960224    INFO: Loading skin file: DialogProgress.xml, load type: KEEP_IN_MEMORY
17:07:11 T:2950960224  NOTICE: Unexpected error:
17:07:11 T:2950960224  NOTICE: <class 'sqlite3.OperationalError'>
17:07:11 T:2950960224   ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
                                             - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
                                            Error Type: <class 'sqlite3.OperationalError'>
                                            Error Contents: no such table: sets
                                            Traceback (most recent call last):
                                              File "/storage/.xbmc/addons/script.moviesetart.frodo/default.py", line 245, in <module>
                                                updated_count = update_movie_sets(overwrite)
                                              File "/storage/.xbmc/addons/script.moviesetart.frodo/default.py", line 78, in update_movie_sets
                                                movie_sets = DB.getMovieSets()
                                              File "/storage/.xbmc/addons/script.moviesetart.frodo/lib/database.py", line 37, in getMovieSets
                                                cur.execute("SELECT * FROM sets")
                                            OperationalError: no such table: sets
                                            -->End of Python script error report<--
17:07:11 T:3043512320   DEBUG: ------ Window Init (DialogKaiToast.xml) ------
17:07:11 T:2950960224    INFO: Python script stopped

I can assure you that MyVideos75.sets does exist (two columns, idSet and strSet). I'm logging the queries being executed against the MySQL database and I don't see a connection being established by the addon, nor obviously a database being selected, so I'm not sure against what database this query is being executed but it doesn't look like it is MySQL.

Edit: Ah, I see the add-on has created an empty (ie. zero-byte) MyVideos75.db on local storage, completely disregarding the database settings in advancedsettings.xml. I guess this add-on isn't setup to support MySQL.