[MrsAngelD]

Just discover that I can use a MySQL Database so I set up the addon to plug my my MySQL database and rescan my folders.

But when I restart Kodi, I have a MyPicsDB error :

Code:

18:53:09 T:1060   ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
                                             - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
                                            Error Type: <type 'exceptions.IndexError'>
                                            Error Contents: list index out of range
                                            Traceback (most recent call last):
                                              File "C:\Kodi\16.1\portable_data\addons\plugin.image.mypicsdb\default.py", line 1940, in <module>
                                                m.set_properties()
                                              File "C:\Kodi\16.1\portable_data\addons\plugin.image.mypicsdb\default.py", line 1398, in set_properties
                                                Collections = MPDB.cur.request( """SELECT COUNT(*) FROM collections""" )[0]
                                            IndexError: list index out of range
                                            -->End of Python script error report<--

Don't know if it's due to my MySQL version (running on my ReadyNAS-RN102 NAS) but table Collection is spelled with a upcase C.

After editing default.py :

Code:

Collections = MPDB.cur.request( """SELECT COUNT(*) FROM Collections""" )[0]

Everything is OK.

I don't think it's just you, I had the same error and editing my file fixed it as well. My database is running on Ubuntu Linux 14.04.

Thanks for posting your fix btw