bfir3 117 Posted September 16, 2015 Posted September 16, 2015 I launched Kodi today after being gone for the weekend and the Emby plugin automatically updated to 1.1.39. I wasn't sure which version I was using before so I decided to do the full database reset. Now every time I try to resync my media I get this error: 00:55:27 T:13524 NOTICE: EMBY WriteKodiVideoDB -> logMsg : Movie Id: a4dc18fe283a5a707cc05f2122d193a1 not found. 00:55:27 T:13524 NOTICE: EMBY WriteKodiVideoDB -> logMsg : ADD movie to Kodi Library, Id: a4dc18fe283a5a707cc05f2122d193a1 - Title: Zombie Holocaust 00:55:27 T:13524 NOTICE: EMBY WriteKodiVideoDB -> logMsg : Add Tag to media, adding tag: Movies 00:55:27 T:13524 NOTICE: Sync DB -> FullLibrarySync : syncDatabase Exiting 00:55:27 T:13524 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: table emby has no column named rotten_tomatoes Traceback (most recent call last): File "H:\Program Files\Kodi\portable_data\addons\plugin.video.emby\default.py", line 125, in <module> Main() File "H:\Program Files\Kodi\portable_data\addons\plugin.video.emby\default.py", line 66, in __init__ LibrarySync().FullLibrarySync(True) File "H:\Program Files\Kodi\portable_data\addons\plugin.video.emby\resources\lib\LibrarySync.py", line 150, in FullLibrarySync self.MoviesFullSync(connection,cursor,pDialog) File "H:\Program Files\Kodi\portable_data\addons\plugin.video.emby\resources\lib\LibrarySync.py", line 277, in MoviesFullSync WriteKodiVideoDB().addOrUpdateMovieToKodiLibrary(item["Id"],connection, cursor, title) File "H:\Program Files\Kodi\portable_data\addons\plugin.video.emby\resources\lib\WriteKodiVideoDB.py", line 227, in addOrUpdateMovieToKodiLibrary cursor.execute(query, (embyId, movieid, fileid, "movie", checksum, criticrating, criticratingsummary, metascorerating)) OperationalError: table emby has no column named rotten_tomatoes -->End of Python script error report<-- 00:55:27 T:13524 WARNING: CPythonInvoker(16, H:\Program Files\Kodi\portable_data\addons\plugin.video.emby\default.py): the python script "H:\Program Files\Kodi\portable_data\addons\plugin.video.emby\default.py" has left several classes in memory that we couldn't clean up. The classes include: class PythonBindings::XBMCAddon_xbmc_Monitor_Director,class XBMCAddon::xbmcaddon::Addon,class XBMCAddon::xbmcgui::Window 00:55:27 T:13776 ERROR: XFILE::CDirectory::GetDirectory - Error getting plugin://plugin.video.emby/?mode=manualsync 00:55:27 T:13776 ERROR: CGUIMediaWindow::GetDirectory(plugin://plugin.video.emby/?mode=manualsync) failed 00:55:27 T:9200 NOTICE: Thread LanguageInvoker start, auto delete: false 00:55:27 T:9200 NOTICE: -->Python Interpreter Initialized<-- 00:55:27 T:9200 NOTICE: plugin.video.emby started 00:55:27 T:9200 NOTICE: Parameter string: ?content_type=video 00:55:27 T:9200 NOTICE: plugin.video.emby stopped 00:55:27 T:11276 NOTICE: Thread BackgroundLoader start, auto delete: false 00:55:31 T:10396 NOTICE: EMBY LibraryMonitor -> logMsg : ERROR in LibraryMonitor ! --> no such column: rotten_tomatoes I feel like this is probably something obvious that I'm overlooking but I haven't changed Kodi versions and the only thing that was updated was the Emby plugin. Still using Kodi 15.1.
im85288 1493 Posted September 16, 2015 Posted September 16, 2015 There may be something up with the database reset in that it is not removing the videos database. Can you do that manually (userdata/databases) and see if it then works correctly. 1
CBers 7450 Posted September 16, 2015 Posted September 16, 2015 Same problem, same error message, here on my Fire TV. I removed the MyVideos93 database, restarted Kodi and the full sync ran. 1
CBers 7450 Posted September 16, 2015 Posted September 16, 2015 Just had to do the same on my Nexus Player. Is this going to be fixed, or will we have to do this each time the addon is updated ??
xnappo 1611 Posted September 16, 2015 Posted September 16, 2015 I recommend using stable for non test machines.
CBers 7450 Posted September 16, 2015 Posted September 16, 2015 I recommend using stable for non test machines. Why did you post that ?? I only asked a question so I know if I need to do the same next time. I've been running beta since it was first released
Angelblue05 4132 Posted September 16, 2015 Posted September 16, 2015 I believe it is fixed with 1.1.41 where you won't need to do this anymore. 1
xnappo 1611 Posted September 16, 2015 Posted September 16, 2015 @@CBers - sorry I thought you meant the annoyance of the db reset in general, not the broken db reset which should be fixed now.T I do think that the current stable is pretty good though - so I recommend people who don't want to have things break move to it. We always appreciate beta testing of course. xnappo 2
CBers 7450 Posted September 16, 2015 Posted September 16, 2015 No annoyance whatsoever Anything that needs doing to add a new function, or correct a bug, is fine with me, just need a heads-up. For what it's worth, there's been nothing added to the changelog within the addon since 1.1.35 Would be nice to see in there that a DB reset is needed rather than having to refer to the forums each time something breaks. My updates are on notify, so I don't blindly update.
im85288 1493 Posted September 16, 2015 Posted September 16, 2015 Yes It should be working fine with 1.1.41 - it was only 1.1.40 where the deletion of a certain table was not occurring in the reset procedure which had this knock on effect.
im85288 1493 Posted September 16, 2015 Posted September 16, 2015 Would be nice to see in there that a DB reset is needed rather than having to refer to the forums each time something breaks. My updates are on notify, so I don't blindly update. When you get version 1.1.41 it should inform you that a database reset is needed...so no need to refer to the forums or change log. Please report back if that is not the case 1
Recommended Posts