Hi there,
I am currently running the latest release of Kodi.
I had setup Kodi to work with a MySQL server located on my server. This had worked fine for quite a while (years) until now…
I’m pretty sure it has to do with the database however I cannot seem to figure out what is causing this.
On the MySQL server I am able to log into the database fine. I can view the tables…etc. However when I try and view the tvshow_view.frm table I am prompted with an error about viewing it. i have tried copying an older version of this back but that did not seem to help. (although I was able to view it in MySQL after)
In Kodi:
I’m able to view Movies…etc just fine. Its only when I try and navigate into the TV Episodes sections that I have issues.
If I go through:
TV SHOWS (hit enter)
I’m thrown back into the source section. If I select TV Shows again from there it will bring me to the filter section where clicking anything does nothing at all.
If I go to the Files section and then click on my source for tv episodes Kodi will simply crash.
ERROR: Exception caught on main loop. Exiting
From there if I click anything Kodi will officially crash.
In the Kodi log I do see this:
20:03:24 T:3608 ERROR: SQL: [MyVideos99] The table does not exist
Query: select * from episode_view ORDER BY dateAdded desc, idEpisode desc LIMIT 10
20:03:24 T:3608 ERROR: CVideoDatabase::GetEpisodesByWhere failed
20:03:24 T:3608 ERROR: SQL: [MyVideos99] The table does not exist
Query: SELECT count(1) FROM tvshow_view LIMIT 1
20:03:24 T:3608 ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
20:03:24 T:3608 ERROR: SQL: [MyVideos99] The table does not exist
Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
20:03:24 T:3608 ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
20:03:24 T:3608 ERROR: SQL: [MyVideos99] The table does not exist
Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
20:03:24 T:3608 ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
20:03:24 T:3608 ERROR: SQL: [MyVideos99] The table does not exist
Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
20:03:24 T:3608 ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
20:03:24 T:920 ERROR: SQL: [MyVideos99] The table does not exist
Query: update episode set c09=5733 where idFile=10497 and c09=''
20:03:24 T:920 ERROR: CVideoDatabase::SetStreamDetailsForFileId (10497) failed
20:03:35 T:6068 ERROR: SQL: [MyVideos99] The table does not exist
Query: SELECT * FROM tvshow_view
20:03:35 T:6068 ERROR: CVideoDatabase::GetTvShowsByWhere failed
20:03:35 T:6068 ERROR: XFILE::CDirectory::GetDirectory - Error getting videodb://tvshows/titles/
20:03:35 T:6068 ERROR: CGUIMediaWindow::GetDirectory(videodb://tvshows/titles/) failed
I have also tried completely uninstalling Kodi and re installing but this did nothing.
I even removed all the TV labeled files on the MySQL server in hopes that Kodi would just recreate them (nope)
So if anyone a) has any idea how to fix this (database issue?) so I can view my TV Episodes again or b) knows how I can get Kodi to start over I’m willing to lose my TV settings and re scan. However I’d really prefer to not lose the Movies database information as this seems to work just fine.
Any help would be greatly appreciated.
Cheers!