[jenl]

MSAA references the incorrect DB version for latest Gotham.

I'm running

Code:

    xbmc --version
        XBMC Media Center 13.0-ALPHA11 Git:20131223-3aaba19

on linux/64.

I use a shared mysql database,

Code:

    cat advancedsettings.xml
        <!-- http://wiki.xbmc.org/?title=advancedsettings.xml -->
        <advancedsettings>
        ...
         <videodatabase>
          <type>mysql</type>
          <host>10.1.1.101</host>
          <port>3306</port>
          <user>xbmc</user>
          <pass>secretpassword</pass>
          <name>xbmc_video</name>
         </videodatabase>
        ...

According to @http://wiki.xbmc.org/index.php?title=XBMC_databases/Version_table, the correct database version to use is:

Code:

    XBMC version    Date             Video DB    Music DB    
    13 Alpha 10     November 2013    77 ↑        37

Verifying

Code:

mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | test               |
    | xbmc_music37       |
    | xbmc_video77       |
    +--------------------+
    5 rows in set (0.00 sec)

When I exec MSAA, @debuglogs,

Code:

...
10:36:35 T:140491869910784   DEBUG: [Movie Set Artwork Automator] - Parsing advancedsettings.xml
10:36:35 T:140491869910784   DEBUG: [Movie Set Artwork Automator] - XBMC build version: 13.0-ALPHA11 Git:20131223-3aaba19
10:36:35 T:140491869910784   DEBUG: [Movie Set Artwork Automator] - Using Gotham DB version: xbmc_video76
10:36:35 T:140491869910784   DEBUG: [Movie Set Artwork Automator] - Using MySQL connector: {'name': u'xbmc_video76', 'host': u'10.1.1.101', 'user': u'xbmc', 'pass': u'secret', 'type': u'mysql', 'port': u'3306'}
10:36:35 T:140491869910784  NOTICE: Unexpected error:
10:36:35 T:140491869910784  NOTICE: (<class 'lib.mysql.connector.errors.ProgrammingError'>, ProgrammingError(), <traceback object at 0x7fc6d00b9680>)
...

Note the incorrect DB version used.

Code:

grep "DATABASE_VERSION_GOTHAM.*=" .xbmc/addons/script.moviesetart.frodo/lib/database.py
    DATABASE_VERSION_GOTHAM = "76"

changing

Code:

-    DATABASE_VERSION_GOTHAM = "76"
+    DATABASE_VERSION_GOTHAM = "77"

now, correctly

Code:

...
10:42:37 T:140492004128512   DEBUG: [Movie Set Artwork Automator] - Parsing advancedsettings.xml
10:42:37 T:140492004128512   DEBUG: [Movie Set Artwork Automator] - XBMC build version: 13.0-ALPHA11 Git:20131223-3aaba19
10:42:37 T:140492004128512   DEBUG: [Movie Set Artwork Automator] - Using Gotham DB version: xbmc_video77
10:42:37 T:140492004128512   DEBUG: [Movie Set Artwork Automator] - Using MySQL connector: {'name': u'xbmc_video77', 'host': u'10.1.1.101', 'user': u'xbmc', 'pass': u'secret', 'type': u'mysql', 'port': u'3306'}
10:42:37 T:140492004128512  NOTICE: [Movie Set Artwork Automator] - Updating artwork for Movie Sets
10:42:37 T:140492004128512   DEBUG: DialogProgress::StartModal called
...

and MSAA works as expected