OperationalError: no such table: view

[gnubibi 3]

Hello,

 

My Emby plugins is not working with kodi. It happened like that, emby plugin crashed, and nothing is working anymore.

 

FreeBSD 10.3

kodi-16.0 (compiled)

 

Options        :
    AIRPLAY        : off
    AIRTUNES       : off
    AVAHI          : on
    CEC            : on
    DOCS           : off
    LIBBLURAY      : off
    LIRC           : off
    MYSQL          : off
    NFS            : on
    NONFREE        : off
    PULSEAUDIO     : off
    RTMP           : on
    SFTP           : on
    SMB            : on
    VAAPI          : on
    VDPAU          : on
    WEBSERVER      : on
 

 

Emby-server 3.0.5911 (from package)

 

Error log (kodi)

10:02:14 T:34699552768  NOTICE: EMBY LibrarySync -> Database version: 2.2.10
10:02:14 T:34699552768  NOTICE: EMBY LibrarySync -> SyncDatabase (started)
10:02:14 T:34699552768  NOTICE: Using Image Cache Thread Count: 0 -> 1
10:02:14 T:34839967744  NOTICE: EMBY DownloadUtils -> SessionId: 0f3c76c377e4d8200b276e85ce40f753
10:02:15 T:34839966720  NOTICE: EMBY UserClient -> Current user: bibi
10:02:15 T:34839966720  NOTICE: EMBY UserClient -> Current userId: 525dfaf60e4648b69ea9f44f999f1e7a
10:02:15 T:34699552768  NOTICE: EMBY LibrarySync -> Sorted views: [u'Movies', u'Series Anim\xe9es', u'SeriesTV']
10:02:15 T:34699552768  NOTICE: EMBY VideoNodes -> Clearing nodes properties.
10:02:35 T:34831407104  NOTICE: Skin Helper Service --> Shutdown requested !
10:02:35 T:34831407104  NOTICE: Skin Helper Service --> BackgroundsUpdater - stop called
10:02:35 T:34831407104  NOTICE: Skin Helper Service --> ListItemMonitor - stop called
10:02:35 T:34831407104  NOTICE: Skin Helper Service --> WebService - stop called
10:02:38 T:34831407104  NOTICE: Skin Helper Service --> skin helper service version 1.0.89 stopped
10:02:40 T:34716484608   ERROR: CPythonInvoker(5, /home/bibi/.kodi/addons/script.skin.helper.service/service.py): script didn't stop in 5 seconds - let's kill it
10:03:02 T:34699552768   ERROR: Exception in thread Thread-10:
                                            Traceback (most recent call last):
                                              File "/usr/local/lib/python2.7/threading.py", line 801, in __bootstrap_inner
                                                self.run()
                                              File "/home/bibi/.kodi/addons/plugin.video.emby/resources/lib/librarysync.py", line 949, in run
                                                self.run_internal()
                                              File "/home/bibi/.kodi/addons/plugin.video.emby/resources/lib/librarysync.py", line 1024, in run_internal
                                                librarySync = self.startSync()
                                              File "/home/bibi/.kodi/addons/plugin.video.emby/resources/lib/librarysync.py", line 81, in startSync
                                                self.refreshViews()
                                              File "/home/bibi/.kodi/addons/plugin.video.emby/resources/lib/librarysync.py", line 362, in refreshViews
                                                self.maintainViews(embycursor, kodicursor)
                                              File "/home/bibi/.kodi/addons/plugin.video.emby/resources/lib/librarysync.py", line 401, in maintainViews
                                                current_views = emby_db.getViews()
                                              File "/home/bibi/.kodi/addons/plugin.video.emby/resources/lib/embydb_functions.py", line 36, in getViews
                                                embycursor.execute(query)
                                            OperationalError: no such table: view
10:03:28 T:34699502592  NOTICE: Storing total System Uptime
10:03:28 T:34831406080  NOTICE: EMBY KodiMonitor -> Method: System.OnQuit Data: {"exitcode":64}
10:03:28 T:34699502592  NOTICE: Saving settings
10:03:28 T:34699502592  NOTICE: stop all

Help would be nice, I have already try to erase kodi databases, start a new scan library in Emby.

It used to works for month without any problem

 

thanks

++

Edited May 4, 2016 by gnubibi

[Angelblue05 4130]

Hum, that's a strange one. And launching the emby add-on > reset local database does not work? It should allow to recreate the database and the missing view table in the emby database...

[gnubibi 3]

Thanks, I have not try this way, and it works

I'll update this topic if it happens again.

++